MySQL query to rename table: RENAME TABLE tbl_name TO new_tbl_name
or,
ALTER TABLE tableName CHANGE OldName newName.
Showing posts with label How can we change the name of a column of a table?. Show all posts
Showing posts with label How can we change the name of a column of a table?. Show all posts
Saturday, May 16, 2009
How can we change the name of a column of a table?
This will change the name of column:
ALTER TABLE table_name CHANGE old_colm_name new_colm_name
ALTER TABLE table_name CHANGE old_colm_name new_colm_name
Subscribe to:
Posts (Atom)
