Results 26 to 26 of 26
Thread: how to best do this schema
Jul 16, 2002, 04:59 #26
- Join Date
- Jan 2001
- buried in the database shell (Washington, DC)
- 0 Post(s)
- 0 Thread(s)
I tried to quote but there is a bug in vB in that it stops quoting everything after the first code/etc. block, so I can't see it.
I don't think you're supposed to specify a default on auto_increment -- you can set it to anything you want (DEFAULT 12345) and it always inserts the next highest number. One would think the AUTO_INCREMENT would be exempt from the NOT NULL error since it is a 'special case'.