Re: NEWBIE to mysql

2003-02-10 Thread Aggelos
mysql> CREATE TABLE info -> ( -> name varchar(50) , <---comma !!! -> message varchar(255) -> ) -> ; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql

re: NEWBIE to mysql

2003-02-10 Thread Victoria Reznichenko
On Saturday 08 February 2003 02:52, 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 TABL

Re: NEWBIE to mysql

2003-02-10 Thread Bruce MacDonald
- Original Message - From: "Wileynet" <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 6:52 PM Subject: NEWBIE to mysql > Can anyone tell me why I keep getting an ERROR 1064 with this command ? > mysql> CREATE TABLE info > -> ( > -> name

Re: NEWBIE to mysql

2003-02-10 Thread keith . jones
Wiley, there's a comma missing from the end of: name varchar(50), Keith Extranet [EMAIL PROTECTED] - 08/02/2003 00:52 To:mysql cc: Subject:NEWBIE to mysql Can anyone tell me why I keep getting an ERROR 1064 with this command ? I just would like to create a table wit

Re: NEWBIE to mysql

2003-02-10 Thread Veysel Harun Sahin
mysql> CREATE TABLE info -> ( -> name varchar(50), -> message varchar(255) -> ) -> ; [EMAIL PROTECTED] 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 bu

Re: NEWBIE to mysql

2003-02-10 Thread Steve Edberg
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 -> ( ->

Re: NEWBIE to mysql

2003-02-10 Thread Stefan Hinz
Wiley, mysql>> CREATE TABLE info > -> ( > -> name varchar(50) > -> message varchar(255) > -> ) > -> ; It's a missing comma: mysql>> CREATE TABLE info > -> ( > -> name varchar(50), /* the comma goes here */ > -> message varchar(255) > -> ) > -> ; Regards,

RE: NEWBIE to mysql

2003-02-10 Thread Bryan Lipscy
Bad syntax. Missing a , and type=MyISAM Try reading the documentation: http://www.mysql.com/doc/en/CREATE_TABLE.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: NEWBIE to mysql

2003-02-10 Thread Jerry
From: "Wileynet" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 08, 2003 12:52 AM Subject: NEWBIE to mysql > 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

Re: NEWBIE to mysql

2003-02-10 Thread Gurhan Ozen
You need to separate the fields with a comma.. Do: name varchar(50), message varchar(255) See: http://www.mysql.com/doc/en/CREATE_TABLE.html Gurhan On Fri, 2003-02-07 at 19:52, Wileynet wrote: > Can anyone tell me why I keep getting an ERROR 1064 with this command ? > I just would like to create

Re: NEWBIE to mysql

2003-02-10 Thread Gerald R. Jensen
Did you start the server? Normally, error 1064 means the server has not been started. - Original Message - From: "jsp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 6:49 PM Subject: NEWBIE to mysql Can anyone tell me why I keep gett

NEWBIE to mysql

2003-02-09 Thread Wileynet
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) -> message varchar(

NEWBIE to mysql

2003-02-09 Thread jsp
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) -> message varchar