MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: truncate table-auto increment values
Posted by: Rick James
Date: April 08, 2014 04:38PM

AUTO_INCREMENT=1 is a clause on ALTER TABLE. Look at the online documentation for ALTER TABLE, which refers to CREATE TABLE. Do ALTER after doing TRUNCATE.

Or (an this might make more sense), do these (instead of TRUNCATE + ALTER):
DROP TABLE ...
CREATE TABLE ...
In this case you won't need the AUTO_INCREMENT clause.

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.