Thanks Fred,
That did it. I wasn't sure what to put into the auto_increment field.
NULL works. Now I just have to fix little syntax errors in the rest of my data.
Many thanks to all of you who contributed on this.
Thanks again Fred.
.....back to work!! :(
On Thu, 11 Mar 1999 16:15:49 -0600, Fred Lindberg wrote:
>On Thu, 11 Mar 1999 14:00:21, Kevin P. O'Brien wrote:
>
>>INSERT INTO Tickets VALUES (TicketNumber, 'LoginID','Contact','Contact
> PH','11-03-1998','08:00','12-03-1998
>>','11:00','PC','Problem','y','Resolution','Comments','Joe','10:00')\g
>
>Maybe I don't understand this, but I usually enter NULL into
>autoincrement fields. What is the VALUE TicketNumber?
>
>
>-Sincerely, Fred
>
>(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)
>
>
Regards,
Kevin P. O'Brien, MCP, CPST <kevino@stripped>
Systems Administration
Irenyx Data Group, Inc.
(Office) 1.250.334.9641 ext.239
(Fax) 1.250.334.2365
(Pager) 1.888.805.3820
(Toll Free) 1.800.275.4260 ext.239
PGP Public Key Fingerprint: 56C4 2F8C 5731 08C1 684D 05DC 05E5 697F
