By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,450 Members | 941 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,450 IT Pros & Developers. It's quick & easy.

Error getting when insert data after truncate the table in mysql

P: 16
Error getting when i insert data after truncate the table.once more i truncate that table data is going otherwise it will show the error message.
this is the error message i am getting .."Failed to read-auto increment storage engine."

Can anyone help to sove this,pls reply as soon as possible.

Thanks in advance
Jul 6 '10 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,168
Never seen this before but I found the following:
The problem happens when the Auto-Increment value of a table grows beyond the limit.

Just run this SQL query in MySQL to fix the bug.

Expand|Select|Wrap|Line Numbers
  1. ALTER TABLE `table_name`  AUTO_INCREMENT =1
Table_name is the name of the table where you found the error while inserting data into. Don’t bother about the Auto_Increment value even if you have records in your table.
Jul 6 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.