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
