I have a table with over 60,000 records, I have a text field that is a full text index. I need to change it to medium text. My question is can it do it without taking the site offline. will the table still be able to serve select queries while the alter is running or will they be locked until it is done, I know that it will lock inserts and updates while the alter is running, that's fine with me.
query sql -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.com 2002 EPpy Award, Best Online U.S. Newspaper --------------------------------------------------------------------- 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