-----Original Message----- From: Sylvia Arzamendi-Foster [mailto:seaf...@yahoo.com] Sent: Wednesday, October 27, 2004 9:59 AM To: win...@lists.mysql.com Subject: Please Help me!!!

I downloaded MySQL 4.0.21. I wrote a script and was able to create a database, but when it attempts to create a table it fails due to a syntax error. I have checked the MySQL manual over and over and can't find anything wrong. Is there a manual specific for server 4.0.21. I'm desperate, please someone help me!

Here is my code and error message:

USE reservation; CREATE TABLE customer ( res_cust_phone_num VARCHAR(10) NOT NULL, res_first_name VARCHAR(20) NOT NULL, res_initial_name CHAR(1) NOT NULL, res_last_name VARCHAR(20) NOT NULL, res_addr_1 VARCHAR(20) NULL, res_addr_2 VARCHAR(20) NULL, res_state CHAR(1) NULL, res_zip VARCHAR(5) NULL, PRIMARY KEY(res_cust_phone_num), );

ERROR 1064 at line 2 in file: ":You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use.