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
