List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 7 2003 1:07am
Subject:Re: I'm new in Mysql
View as plain text  
At 16:38 -0800 1/6/03, Beogradjanin wrote:
>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,

No comma here, it's the final column in the definition.

>  >     -> )
>>      -> ;
>>  ERROR 1064: You have an error in your SQL syntax near ')' at line 8
>mysql>>
>
>Whats wrong here????
>
>--
>Best regards,
>  Beogradjanin                          mailto:beogradjanin@stripped

Thread
I'm new in MysqlBeogradjanin7 Jan
  • Re: I'm new in MysqlPaul DuBois7 Jan
  • RE: I'm new in MysqlJennifer Goodie8 Jan
  • Re: I'm new in MysqlBhavin Vyas8 Jan
  • Re: I'm new in MysqlKip Turk8 Jan
  • RE: I'm new in MysqlCharles Mabbott9 Jan
    • combining tablesMatthew K. Gold9 Jan