在Mysql语句中不区分大小写,但要注意语句中的空格;在语句中要注意values添加的值中字符类型要加单引号
例:user表
1.增加语句
insert into user ('userId','userName' ,'userTel' ,'userEmail') values (1,'张三','18739442997','243457789@qq.com');、
insert into user values (1,'张三','18739442997','243457789@qq.com'); *如不写条件代表添加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字段