{"id":286,"title":"sql\u4fee\u6539\u8868","good":0,"bad":0,"hit":2172,"created_at":"2018-06-14 22:15:10","content":"<p>\u4fee\u6539\u8868<\/p><p>alter table tablename add sex int after name;<\/p><p>alter table tablename drop sex,name;<\/p><p>alter table tablename modify id int first;(\u79fb\u52a8\u5230\u7b2c\u4e00\u4f4d\u7f6e\uff09<\/p><p>alter table tablename change id p_id tinyint;(id\u6539\u540d\u53ca\u7c7b\u578b\uff09<\/p><p>alter table tablename rename newtablename;(\u6539\u8868\u540d\uff09<\/p><p>rename table tablename to newtablename;(\u6539\u8868\u540d\uff09<\/p><p><br\/><\/p>"}