modify:修改;
移动id列到第一列: ALTER TABLE user2 MODIFY id SMALLINT UNSIGNED NOT NULL FIRST;
移动到username列后面,用after: ALTER TABLE user2 MODIFY SMALLINT UNSIGNED NOT NULL AFTER username;
modify:修改;
移动id列到第一列: ALTER TABLE user2 MODIFY id SMALLINT UNSIGNED NOT NULL FIRST;
移动到username列后面,用after: ALTER TABLE user2 MODIFY SMALLINT UNSIGNED NOT NULL AFTER username;
2014-09-09
举报