Hello everyone:
I want to create a table in DOS command line prompt.
I received a syntax error message but I couln't find out what caused the error.
Could somone take look at my 'create table' syntax and tell me what I did wrong?
I appreciate your help!
create table computers(
emp_id int unsigned not null auto_increment,
pc_name varchar(50) not null,
current_user varchar(50) not null,
act_key varchar(50),
ms_office_key varchar(50),
norton_order_num varchar(50),
serial_num varchar(50),
make varchar(50) not null,
model varchar(50) not null,
OS varchar(50) not null,
purchase_date datetime not null,
in_use varchar(1) not null,
location varchar(50) not null,
product_num varchar(50) not null,
os_key varchar(50) not null,
primary key (emp_id));
---------- Error Message --------------------------
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near 'current_user varchar(50) not null,
act_key varchar(50),
ms_office_key varchar(' at line 4
webdev077
3-2-07