常用的sql語句
1.數據庫相關
查所有數據庫
?show?databases
創建數據庫?
create?database?db1
查看數據庫?
show?create?database?db1
創建數據庫指定字符集?
create?database?db1?character?set?utf8/gbk
刪除數據庫?
drop?database?db1
使用數據庫?
use?db1
表相關
創建表
?create?table?t1(id?int,name?varchar(10))
查看所有表?
show?tables
查看單個表屬性?
show?create?table?t1
查看表字段?
desc?t1
創建表指定引擎和字符集?
create?table?t1(id?int,name?varchar(10))?engine=myisam/innodb?charset=utf8/gbk
修改表
修改表名?
rename?table?t1?to?t2
修改表屬性?
alter?table?t1?engine=myisam/innodb?charset=utf8/gbk
添加表字段?
alter?table?t1?add?age?int?first/after?xxx
刪除表字段?
alter?table?t1?drop?age
修改表字段名和類型?
alter?table?t1?change?age?newAge?int
修改表的類型和位置?
alter?table?t1?modify?age?int?first/after?xx
刪除表?
drop?table?t1
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
