Answer Posted / chaithra.t
ALTER TABLE tablename RENAME COLUMN old_columnname TO
new_columnname;
above is to change the column name of the table.
In case if u want to change the table name then:
ALTER TABLE tablename RENAME TO new_tablename;
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is max connection in mysql?
What are the functions of commit and rollback statements?
How to show table structure mysql?
What are the advantages of mysql?
What is mysql default port number?
What is strict mode in mysql?
What are mysql functions?
Is Mysql query is case sensitive?
How do you use auto increment?
Give string types available for column?
What is the query to display top 20 rows?
What is mysql database used for?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
Is mysql easy to learn?
What are the advantages of MySQL when compared with Oracle?