show databases
show tables
select * from test1.user #查询test1库里user表中所有内容
select host,user,password from test1.user limit 3 #只显示前3列
select host,user,password from test1.user where user ="root" and host ="localhost" #加上条件
insert into test1.user(num) value(1) #向user表中的num属性插入一个value为1的值
creat table test1.user(num int,primary key(num)) #在test1库中建立user表
alter table test1.user add name char(20) after num #在test1库中的user表中建立name表,并且在num后
update test1.user set name='bob' #设置name属性值为bob
update test1.user set tel=123456789 #设置tel属性值为123456789