常用sql語句有哪些

 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