2 MySQL questions

[hearn]

What is the syntax for renaming a specific field within a table?

And

What is the syntax to add a field to an existing table that already has defined fields as TEXT, INT, CHAR, etc?

Thanks in advance!

[omidh]

Dear Tom;
If I dont wrong you can use following syntsx to add a field to a table

ALTER TABLE tablename ADD FieldName [property]

if you dont like do this work handly you can use mysqlfront freely download this software
from:
www.mysqlfront.de

[hearn]

Thanks a bunch for your info.

Cheers,
Tom