MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Set Auto_Increment and Transactions
Posted by: Chis Florinel
Date: September 05, 2005 06:41AM

A similar problem was posted some time ago:

http://forums.mysql.com/read.php?10,42263,42314#msg-42314

Beginning with MySQL 4.1.12 and MySQL 5.0.3, InnoDB supports the AUTO_INCREMENT = n table option in CREATE TABLE and ALTER TABLE statements, to set the initial counter value or alter the current counter value. The effect of this option is canceled by a server restart, for reasons discussed earlier in this section.

basicly the query is:
ALTER tableName auto_increment=100 (will set auto_increment value to 100), but InnoDB does not support that for mysql < 4.1.12

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


Subject
Views
Written By
Posted
Set Auto_Increment and Transactions
2927
Tatiana Lloret
September 05, 2005 04:47AM
Re: Set Auto_Increment and Transactions
4436
Chis Florinel
September 05, 2005 06:41AM


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.