modify:修改;
移動(dòng)id列到第一列: ALTER TABLE user2 MODIFY id SMALLINT UNSIGNED NOT NULL FIRST;
移動(dòng)到username列后面,用after: ALTER TABLE user2 MODIFY SMALLINT UNSIGNED NOT NULL AFTER username;
modify:修改;
移動(dòng)id列到第一列: ALTER TABLE user2 MODIFY id SMALLINT UNSIGNED NOT NULL FIRST;
移動(dòng)到username列后面,用after: ALTER TABLE user2 MODIFY SMALLINT UNSIGNED NOT NULL AFTER username;
2014-09-09
舉報(bào)