List:General Discussion« Previous MessageNext Message »
From:Kevin P. O'Brien Date:March 11 1999 2:25pm
Subject:Re: AUTO_INCREMENT Limits to 256 records
View as plain text  
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


Thread
AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsMicheal Mc Evoy11 Mar
  • one query for two identical tablesTao Liang3 Mar
    • RE: one query for two identical tablesNicolas Prade3 Mar
  • group by conditionsTao Liang5 Mar
    • Re: group by conditionssinisa6 Mar
      • accessing db while updating itTao Liang26 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsRobert Hazeltine11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • select count distinctChinaConnect11 Mar
    • Re: select count distinctChris12 Mar
    • Re: select count distinctScott Liu13 Mar
      • Re: select count distinctMichael Widenius15 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsChristian Mack12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp13 Mar
Re: Bad handshake problem with java and MySQL 3.22.32Carlos Proal15 Feb