hans,
Tuesday, October 01, 2002, 1:02:02 PM, you wrote:
hp> got a little problem during learning mysql :
hp> have made a file called create_member.sql, looks like this here :
hp> CREATE TABLE member
hp> {
hp> last_name VARCHAR(20) NOT NULL,
hp> first_name VARCHAR(20) NOT NULL,
hp> suffix VARCHAR(5) NULL,
hp> expiration DATE NULL DEFAULT '0000-00-00',
hp> email VARCHAR(100) NULL,
hp> street VARCHAR(50) NULL,
hp> city VARCHAR(50) NULL,
hp> state VARCHAR(2) NULL,
hp> zip VARCHAR(10) NULL,
hp> phone VARCHAR(20) NULL,
hp> interests VARCHAR(255) NULL
hp> }
hp> then I tried :
hp> mysql samp_db -u root -p < create_member.sql
hp> and get the following message :
hp> [papabaer@hanna papabaer]$ mysql samp_db -u root -p < create_member.sql
hp> Enter password:
hp> ERROR 1064 at line 1: You have an error in your SQL syntax near '{
hp> last_name VARCHAR(20) NOT NULL,
hp> first_name VARCHAR(20) NOT NULL,
hp> suffix VAR' at line 2
hp> now I got a liitle hickup, because don't know, whats happen - don't know why
hp> this error-message
You should use '(', ')' instead of '{','}'.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
