CREATE TABLE test(
\nid int(11) UNSIGNED not null AUTO_INCREMENT,
\nname varchar(30) not null comment '\u59d3\u540d',
\nage int(10) not null comment '\u5e74\u9f84',
\nPRIMARY KEY ( detection_id )
\n) comment '\u4eba\u5458\u8868';<\/p>\n
\u589e\u52a0\u5b57\u6bb5\uff1a<\/p>\n
alter TABLE test add mobile varchar(30) UNSIGNED not null DEFAULT 0 COMMENT \"\u624b\u673a\u53f7\u7801\";<\/p>\n
\u521b\u5efa\u89c6\u56fe\uff1a<\/p>\n
CREATE VIEW view_name AS select_statement;<\/p>\n
\u5220\u9664\u8868\uff1a<\/p>\n
DROP TABLE\u00a0 tbl_name;<\/p>\n
\u5220\u9664\u89c6\u56fe\uff1a<\/p>\n
drop view if exists view_name;<\/p>\n
\u5220\u9664\u5b57\u6bb5\uff1a<\/p>\n
alter table table_name drop column name;<\/p>\n
\u4fee\u6539\u8868\u540d\uff1a<\/p>\n
rename table test to demo;<\/p>\n
\u4fee\u6539\u6570\u636e\u5e93\u5b57\u6bb5\uff1a<\/p>\n
ALTER TABLE `test` CHANGE COLUMN `id` `uid`\u00a0 int() UNSIGNED not null\u00a0 comment \"\u7528\u6237id\";<\/p>\n
![\"mysql\"](\"http:\/\/bolg.fengyuwuzu.cn.com\/wp-content\/uploads\/2016\/11\/mysql.png\")
<\/a><\/p>\n