List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:March 12 1999 1:31pm
Subject:Re: AUTO_INCREMENT Limits to 256 records
View as plain text  
"Kevin P. O'Brien" wrote:
< ... > 
> #
> # Dumping data for table 'Tickets'
> #
> 
> 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

Hi Kevin

This is an invalid INSERT because TicketNumber isn't a number at all!

If you want to use the AUTO_INCREMENT feature to give it new values to TicketNumber, 
you have to leave this field out.
Example:

INSERT INTO Tickets (LoginID, ContactName, ContactPhone, OpenCallDate, OpenCallTime,
CloseCallDate, CloseCallTime,
SystemConfigurationID, Problem, Resolved, Resolution, Comments, TechName, TimeOfCall)
VALUES ('LoginID', 'Contact', 'Contact PH',
'11-03-1998', '08:00', '12-03-1998', '11:00', 'PC', 'Problem', 'y', 'Resolution',
'Comments', 'Joe', '10:00')

But if you only substituted the real TicketNumber value through its name, then your dump
has two INSERT's with the same TicketNumber
value (which should be = 256).

Hope this helps
Christian

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