MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: truncate table-auto increment values
Posted by: Peter Brawley
Date: May 15, 2014 02:57PM

After I fix your Create Table statement by adding missing commas ... 

`Bookfrom` int(11) DEFAULT NULL,     -- comma was missing
`bookedfor` int(11) DEFAULT NULL,    -- comma was missing

... and after I supply missing referenced tables, your Create Table statement executes ok.

Then executing your Insert statement, a Truncate command, and Show Create Table shows auto_increment has been reset to 1.

Likewise after a new Insert at this point, last_insert_id() returns 1, showing again that auto_increment has been reset to 1.

So as I said six weeks ago, I am unable to replicate the behaviour you describe.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
truncate table-auto increment values
Dimitris Papageorgiou
April 01, 2014 08:51AM
Re: truncate table-auto increment values
Peter Brawley
April 01, 2014 09:18AM
Re: truncate table-auto increment values
Dimitris Papageorgiou
April 01, 2014 02:05PM
Re: truncate table-auto increment values
Peter Brawley
April 01, 2014 03:26PM
Re: truncate table-auto increment values
Dimitris Papageorgiou
April 03, 2014 07:34AM
Re: truncate table-auto increment values
Peter Brawley
April 03, 2014 08:54AM
Re: truncate table-auto increment values
Dimitris Papageorgiou
April 03, 2014 11:14AM
Re: truncate table-auto increment values
Peter Brawley
April 03, 2014 01:50PM
Re: truncate table-auto increment values
Dimitris Papageorgiou
April 03, 2014 01:56PM
Re: truncate table-auto increment values
Peter Brawley
April 03, 2014 02:16PM
Re: truncate table-auto increment values
Rick James
April 04, 2014 11:36PM
Re: truncate table-auto increment values
Dimitris Papageorgiou
April 07, 2014 02:53AM
Re: truncate table-auto increment values
Rick James
April 07, 2014 09:14AM
Re: truncate table-auto increment values
Dimitris Papageorgiou
April 07, 2014 01:15PM
Re: truncate table-auto increment values
Rick James
April 08, 2014 04:38PM
Re: truncate table-auto increment values
Peter Brawley
April 08, 2014 09:28PM
Re: truncate table-auto increment values
Barry Galbraith
April 08, 2014 05:17PM
Re: truncate table-auto increment values
Dimitris Papageorgiou
May 15, 2014 02:31PM
Re: truncate table-auto increment values
Peter Brawley
May 15, 2014 02:57PM
Re: truncate table-auto increment values
Dimitris Papageorgiou
May 27, 2014 01:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.