Mysql表简单的增加、删除、修改、查询语句

在Mysql语句中不区分大小写，但要注意语句中的空格；在语句中要注意values添加的值中字符类型要加单引号

例：user表

1.增加语句

insert into user ('userId','userName' ,'userTel' ,'userEmail') values (1,'张三','18739442997','[e-mail]');、

insert into user  values (1,'张三','18739442997','[e-mail]');      *如不写条件代表添加user表中所有的列

2.删除语句

delete from user where userId=1;

delete from user where userId=1 and userName='张三';
3.修改语句
update user set userName = '张三' where userId = 1;
4.查询语句
select * from user;   *查询user表中所有数据
select userName,userTel from user;   *查询userName,userTel字段