List:General Discussion« Previous MessageNext Message »
From:Steve Edberg Date:February 10 2003 12:07am
Subject:Re: NEWBIE to mysql
View as plain text  
At 4:52 PM -0800 2/7/03, Wileynet wrote:
>Can anyone tell me why I keep getting an ERROR 1064 with this command ?
>I just would like to create a table with two fields, name and messages
>for a
>Simple guestbook but I want to store the data in a mysql database.
>
>mysql> CREATE TABLE info
>     -> (
>     -> name varchar(50)


You need a comma:

	name varchar(50),


>     -> message varchar(255)
>     -> )
>     -> ;
>
>
>thanks,
>-wiley
>


-- 
+------------------------------------------------------------------------+
| Steve Edberg                                      sbedberg@stripped |
| University of California, Davis                          (530)754-9127 |
| Programming/Database/SysAdmin               http://pgfsun.ucdavis.edu/ |
+------------------------------------------------------------------------+
| SETI@Home: 1001 Work units on 23 oct 2002                              |
| 3.152 years CPU time, 3.142 years SETI user... and STILL no aliens...  |
+------------------------------------------------------------------------+
Thread
NEWBIE to mysqlWileynet8 Feb
  • Re: NEWBIE to mysqlGurhan Ozen9 Feb
  • Re: NEWBIE to mysqlJerry9 Feb
  • Re: NEWBIE to mysqlStefan Hinz9 Feb
  • Re: NEWBIE to mysqlSteve Edberg10 Feb
  • Re: NEWBIE to mysqlBruce MacDonald10 Feb
  • re: NEWBIE to mysqlVictoria Reznichenko10 Feb
  • Re: NEWBIE to mysqlAggelos10 Feb