Rumah > Artikel > pangkalan data > MYSQL里面的ALTER TABLE的方法
MYSQL里面的ALTER TABLE的步骤 ? ? ? MYSQL里面的ALTER?TABLE的步骤是 1:CREATE?TABLE?NEWTABLE(含最新的表结构); 2:INSERT?INTO?NEWTABLE?SELECT?*?FROM?OLDTABLE; 3:?DROP?TABLE?OLDTABLE; 4:?RENAME?TABLE?NEWTABLE?TO?OLDTABLE; ? ?
MYSQL里面的ALTER TABLE的步骤?
?
?
MYSQL里面的ALTER?TABLE的步骤是
1:CREATE?TABLE?NEWTABLE(含最新的表结构);
2:INSERT?INTO?NEWTABLE?SELECT?*?FROM?OLDTABLE;
3:?DROP?TABLE?OLDTABLE;
4:?RENAME?TABLE?NEWTABLE?TO?OLDTABLE;
?
?