给列的属性赋值;
insert into user2 value(1,'张','asd',23,'1995-05-05');
insert into user2 value(null,'wang','sssasd',20,'1995-05-05');
insert into user2 value(null,'李','asd',13,'1995-05-05');
修改列的值;
修改某一列的所有值
update user2 set password = '12345';
根据username属性条件修改一个数据:
update user2 set password = 'abcd' where username = 'wang';
按条件修改多个列
update user set password = '6789',age=55 where username = '李';
删除表中记录:
删除一条记录
delete from user2 where id=1;
删除所有记录;
delete from user2;
truncate table user2;
查询表的记录:
基本查询格式:
select [distinct]*|列名 from 表 [where=条件];
查询所有信息
select * from user2;
查询某些列
select id,age from user2;
不显示重复的
select distinct age from user2;
查看姓名和某些列的总和;
select id,age+id from user2;
查看姓名和某些列的总和;并换名
select id,age+id as newsum from user2;
条件查询:
使用where自句 ,可以用>,<,>=,<=,<>,=
like:模糊查询
in:范围查询
条件关联:and,or,not
单个条件查询:
select * from user2 where id=4;
多个条件查询
select * from user2 where username='张' and age>20;
模糊查询:
like可以进行模糊查询,在like子句中可以使用_或者%作为站位符,_代表一个字符,%代表任意个字符
select * from user2 where birthday like '19%' and age>18;
范围查询;in
select * from user2 where age in(13,20);