Is it possible to rename tables in mysql, and if it is, what is the command within the query of the mysql call?
Sure.
ALTER TABLE oldname RENAME newname;
I am assuming that you can run the same command to a database just replacing the TABLE with DATABASE and the old and new names? Correct me if I'm wrong? Thank you for your help sp0rk!
I'm afraid the answer to that one is no. It's listed as an feature "TODO" for version 4.1.
http://www.mysql.com/doc/T/O/TODO_MySQL_4.1.html
Thanks for your help, greatly appreciated!
Two more questions for you sp0rk, sorry to keep bothering you:
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
