problem creating a table
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
r)
)' at line 4
mysql>
Subject
Views
Written By
Posted
problem creating a table
3092
July 07, 2005 02:48PM
2374
July 07, 2005 06:00PM
1970
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.