Error 1064

[Satish Reddy]

I am getting this error message:

mysql> source chp18wkshp.sql
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 'varch
ar2(33) not null)' at line 6
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 'varch
ar2(15) not null,
fname varchar2(15) not null,
mname varchar2(15) null,' at line 5
........................................


I am run the following code example (from Sam's Beginning Databases)

create table sales (
emp_id char(9) not null,
prod_id char(4) not null,
amount decimal(3) not null,
ship_date date not null,
destination varchar2(33) not null);

Any idea how I can fix this. I used the command client and I still get the same error. I can however create this using the adminstrator. I am using version 4.1.

-- Thanks.