[thelist] Create tables on Local MySql

rudy r937 at interlog.com
Thu Aug 29 10:18:01 CDT 2002


> You have an error in your SQL syntax near '; CREATE ...

andrew, is there a semi-colon in front of CREATE TABLE CartItems ?

what's in front of that?


> Remove the comma at the end of
>       CartItemsID BIGINT NOT NULL AUTO_INCREMENT,
> Andrew, I hate to say this, but it is time to RTFM and STFW.

tsk, jay

rtfm?  pot?  kettle?

there are two ways to declare the pk, and that was one of them  ;o)

what's stfw?


> Silly thought ... don't you require a default value
> if a field is "NOT NULL"?

no, rob, but it's an awfully good idea


rudy
who doesn't really want to play sql cop,
but somebody's gotta do it




More information about the thelist mailing list