Possibly "comment" is a reserved word in MySQL?
Carl Reynolds Ph: +64-9-4154790
CJN Technologies Ltd. Fax: +64-9-4154791
[EMAIL PROTECTED] DDI: +64-9-4154795
PO Box 302-278, North Harbour, Auckland, New Zealand
12 Piermark Drive, North Harbour Estate, Auckland, NZ
Visit our website at http://www.cjntech.co.nz/
> -----Original Message-----
> From: Mark Derricutt [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, September 24, 1999 10:43 AM
> To: Multiple recipients of list database
> Subject: [DUG-DB]: mysql question...
>
> I've got a weird problem with MySQL:
>
> [derricuttm@cvs derricuttm]$ mysql test < chalice.sql
> ERROR 1064 at line 1: You have an error in your SQL syntax near ';
>
> CREATE TABLE bands
> (
> bandname VARCHAR (64) NOT NULL,
> band_full_name VARCHAR' at line 44
> [derricuttm@cvs derricuttm]$
>
> Now, it's saying line 1 (possibly cause I'm piping the sql in), which
> doesn't really help me at all, but, this is the SQL that's being run
> at
> that point:
>
> CREATE TABLE bands
> (
> bandname VARCHAR (64) NOT NULL,
> band_full_name VARCHAR (255) NOT NULL,
> location VARCHAR (255),
> genre VARCHAR (255),
> url VARCHAR (255),
> image_url VARCHAR (255),
> email VARCHAR (255),
> postal_contact BLOB,
> band_active SMALLINT,
> comment BLOB
> );
>
> Can anyone spot anything -stupid- that i'm doing here? The error is
> saying its near '; which doesn't exist!
>
> The actual SQL script I'm running has more stuff in it than just this,
> so
> if anyone wants, I could send them that if they wanna take a quick
> peek at
> it... I can't see anything in there that I've got wrong...
>
> Mark
>
>
> --
> Mark Derricutt | Chalice of Blood
> Software Developer | New Zealand Christian Music News
> Auckland, New Zealand | http://www.chalice.gen.nz
> [EMAIL PROTECTED] | UIN: 1934853
>
> Getting jiggy with Yearning - Plaintive scenes
>
> ----------------------------------------------------------------------
> -----
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
application/ms-tnef
