Re: mysql schema question

[Nick Roper]

Rick,

If you need to alter the structure of an existing table - e.g. table/column names, data types etc. then you should use the appropriate Data Definition statements, e.g:

ALTER TABLE (http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html)
RENAME TABLE (http://dev.mysql.com/doc/mysql/en/RENAME_TABLE.html)

These statements will ensure that any changes are properly reflected not only in the table structure, but also in any related data and indexes.

Nick

--
Nick Roper