Please see last line "comments text null," I do not believe you need the ',' between the End of statement and the ')'
Try this: create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null ) ; Regards, Chuck http://68.43.100.7:81/aa8vs ========================================== "Patriotism is the willingness to kill and be killed for trivial reasons." - Bertran Russell -----Original Message----- From: Beogradjanin [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 7:39 PM To: [EMAIL PROTECTED] Subject: I'm new in Mysql Hello mysql, I want to learn MySQL and PHP I've installed Apache , PHP and MySql Whan I try to make tables create table guestbook ( name varchar( 40 ) null, location varchar( 40 ) null. email varchar( 40 ) null, url varchar( 40 ) null, comments text null, ) ; I get this mysql>> create table guestbook > -> ( > -> name varchar( 40 ) null, > -> location varchar( 40 ) null, > -> email varchar( 40 ) null, > -> url varchar( 40 ) null, > -> comments text null, > -> ) > -> ; > ERROR 1064: You have an error in your SQL syntax near ')' at line 8 mysql>> Whats wrong here???? -- Best regards, Beogradjanin mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
