Edit table column names?

[Anon]

How can I change a mysql column name? For instance Name to Business Name?, without changing or deleting the data content! Any help appreciated.

Marcel.

[Anon]

Try this:

ALTER TABLE table_name CHANGE old_column_name new_column_name INTEGER;

This assumes your old column data type is an integer. If your definition is different than the orgininal column type MySQL with try and convert the data to the new type. Just make sure you specify the same definition as the old column data type so it doesn't touch your data.
You can read more about this in the MySQL manual here if you need more help.

http://www.mysql.com/documentation/mysql/full

Troy

[Anon]

Thanks again,

I usually go to the books first and in fact did, but it was late last night and alas tired eyes won over patience and I posted for the quick way out. Seems I've become a new millenium man after all...hahaha..at any rate thanks i appreciate your time and talent.

Marcel.