mysql语法

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