Signup
DATABASE PROGRAMMING AND ADMINISTRATION FORUM
Top Web Hosts >> Forums >> Database Programming and Administration

   
  How do you reset MySQL sequence number?
  Name : Aladar     Date : 09-05-21 16:42     Hit : 4306    
  Trackback : http://www.topwebhosts.org/bbs/tb.php/database/25
MySQL doesn't really support sequence numbers, but it does have an auto increment value which may be applied to a primary key of a table. A column with an auto increment "Extra Attribute" set automatically increments the value by 1 from the last number. To reset or modify auto increment value, you may use the following ALTER command.


mysql> alter table {table_name} auto_increment = 1;

   

 


Cheap Web HostingBudget Web HostingEcommerce Web Hosting
Link to UsLink ExchangeAdvertisePrivacy PolicyTerms Of ServiceAbout UsContact UsSitemap
Copyright © 2006 - 2013 Broadband Media, Inc. All rights reserved.