First of all MySQL rocks!!!
--------------
Now for my problem...
Unfortunately, before I knew how autoincrement worked, I have setup a database with a
signed autoincrement column.
When I insert columns, I usually pass NULL as the column value for the INSERT
statement to correctly insert the next autoincrement value.
Occasionally I have to manually insert values with negative numbers, this corrupts the
autoincrement value (autoincrement seems to be unsigned) so i have to run myisamchk -A
to fix it.
I wanted to know if there is an sql command i can execute which has the same effect of
myisamchk -A.
I have tried to use SET INSERT_ID=# but it seems to set the autoincrement value only
for the current connection and for the first insert only.
Another thing, is it safe to run myisamchk -A without shutting down the mysql in a
production environment?
regards,
Enea
------------------------------
P.Review srl
+39 02 29061035
[EMAIL PROTECTED]
www.presstoday.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
