MySQL Forums
Forum List  »  InnoDB

problem creating a table
Posted by: Bimal Mehta
Date: July 07, 2005 02:48PM

I JUST INSTALLED MY SQL SERVER 4.1 AND INVOKED my sql command line. after inputting the password it looks like i'm at >mysql mode. I thought I would be able to create table, insert data, and then run queries from mysql mode. when I typed this syntax to create the table, I'm getting an error. Please see below syntax:

create table bank
(acctholder varchar(10), firstname varchar(20),
lastname varchar(20), address1 varchar(30), address2 varchar(30),
address3 varchar(30), zipcode number(5);

error i'm seeing is:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual tha
corresponds to your MySQL server version for the right syntax to use near 'num
)' at line 4

Options: ReplyQuote

Written By
problem creating a table
July 07, 2005 02:48PM
July 07, 2005 06:00PM
July 09, 2005 11:13PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.