7 lines
297 B
MySQL
7 lines
297 B
MySQL
|
ALTER TABLE vn.worker ADD mobileExtension INT(4) NULL;
|
||
|
|
ALTER TABLE vn.worker CHANGE mobileExtension mobileExtension int(4) DEFAULT NULL NULL AFTER phone;
|
||
|
|
ALTER TABLE vn.worker MODIFY COLUMN phone varchar(9) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;
|
||
|
|
|
||
|
|
UPDATE vn.worker
|
||
|
|
SET phone = NULL;
|