"ALTER TABLE works by making a temporary copy of the original table. The
alteration is performed on the copy, then the original table is deleted and
the new one is renamed. This is done in such a way that all updates are
automatically redirected to the new table without any failed updates. While
ALTER TABLE is executing, the original table is readable by other clients.
Updates and writes to the table are stalled until the new table is ready."

So, I think your data will be saved.

Kind regards,

>>>> www.AceHoster.com <<<< Quality web hosting

"Anthony Rodriguez" <[EMAIL PROTECTED]> ???????/???????? ? ????????
> I've a VARCHAR(4) field that I want to change to a VARCHAR(6) field.
> What would happen to the existing data in MySQL db?
> Thanks!
> Tony

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to