ALTER: 原意指:改变;
插入年龄列:ALTER TABLE user1 ADD age TINYINT UNSIGNED NOT NULL;
在username后面插入password列: ALTER TABLE user1 ADD password VARCHAR(32) NOT NULL AFTER username;
ALTER: 原意指:改变;
插入年龄列:ALTER TABLE user1 ADD age TINYINT UNSIGNED NOT NULL;
在username后面插入password列: ALTER TABLE user1 ADD password VARCHAR(32) NOT NULL AFTER username;
2014-09-09
举报