hi, got a little problem during learning mysql : have made a file called create_member.sql, looks like this here : CREATE TABLE member { last_name VARCHAR(20) NOT NULL, first_name VARCHAR(20) NOT NULL, suffix VARCHAR(5) NULL, expiration DATE NULL DEFAULT '0000-00-00', email VARCHAR(100) NULL, street VARCHAR(50) NULL, city VARCHAR(50) NULL, state VARCHAR(2) NULL, zip VARCHAR(10) NULL, phone VARCHAR(20) NULL, interests VARCHAR(255) NULL }
then I tried : mysql samp_db -u root -p < create_member.sql and get the following message : [papabaer@hanna papabaer]$ mysql samp_db -u root -p < create_member.sql Enter password: ERROR 1064 at line 1: You have an error in your SQL syntax near '{ last_name VARCHAR(20) NOT NULL, first_name VARCHAR(20) NOT NULL, suffix VAR' at line 2 now I got a liitle hickup, because don't know, whats happen - don't know why this error-message am using MySQL-3.23.47-5mdk on a mdk 8.2 box hope anyone can help ? this example is from Paul DuBois's book Mysql thanks and bye hans --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php