ALTER TABLE `test`.`new table`
MODIFY COLUMN `username` VARCHAR(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
MODIFY COLUMN `password` VARCHAR(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD COLUMN `tel` VARCHAR(45) AFTER `password`;
mysql 增加一列
最新推荐文章于 2024-07-15 19:19:56 发布