ALTER TABLE tableName CHANGE `oldcolumnname` `newcolumnname` datatype(length);
MySQL rename or change column name will work with or without data in a table
MYSQL change or rename column name
MYSQL provides an option to rename the columns even after transaction happened in that table.Simple alter script will help to solve this problem.
MySQL rename or change column name will work with or without data in a table
MySQL rename or change column name will work with or without data in a table
Tags
database
0 Comments
Post a Comment