Error 1062

[CalEvans]

http://www.phpbuilder.com/mail/php-general…001072/1686.php

Google is your friend.

=C=

[mchenrycounty]

I deleted the row, and changed the table type to MyISAM and it didn't work.

Can you explain the Delete From, How do I do that?

Table Name =users

Column = “id”

Row= with problem= id = 2147483647, when it should be about 369

[Shadow]

Issue an INSERT INTO command that explicitly sets the id column to the next desired value. That will reset the counter.

[Shadow]

My bad, I replied before thinking! An INSERT INTO works only if you specify a higher value than the current seed. If you use MyISAM then you should take advantage of the -A option of myisamchk:

Quote:

-A or –set-auto-increment[=value]

Force AUTO_INCREMENT to start at this or higher value. If no value is given, then sets the next AUTO_INCREMENT value to the highest used value for the auto key + 1.

[mchenrycounty]

Shadow

what do I actually type to set to a value I keep getting

and then do I hit “execute query”

This is the error code I get when I hit “execute query”

Error Code : 1064

You have an error in your SQL syntax near 'auto-increment[=372] ' at line 1

(350 ms taken)

Thanks

[mchenrycounty]

What if I unchecked the auto-increment, and then assigned the id number myself?

[mchenrycounty]

Its fixed: these are the steps I took:

1. Clicked on the Table

2. went to “Alter Table Structure”

3. went to “Other Properties”

4. then inserted the next number in “Autoincremet box”

Thanks

[Author]

Posts