Navicat Premium mysql
时间：2021-07-01 10:21:17
帮助过：2人阅读
create table user3(id
int(
11),name
varchar(
32),age
int (
3),sex
char(
1));
#添加语句
insert into user3(id ,name,age,sex)
values(
1,
‘张三‘,
99,
‘男‘);
insert into user3
values(
4,
‘王五‘,
21,
‘男‘);
#删除
delete from user3;#user3中所有数据全删
delete from user3
where name
=‘张三‘;
delete from user3
where name
=‘张三‘ and age
=99;#
and 出现在条件与条件之间
delete from user3
where name
=‘张三‘ & age
=99;#？？？为何没效果
&最好不用，Java中转义字符
#修改
update user3
set sex
=‘女‘ where name
=‘李四‘ and age
=22;
update user3
set sex
=‘女‘,age
=2 where name
=‘李四‘ and age
=22;#同时改多个
#查询
select name,id,age,sex
from user3;#查询所有
select * from user3;#查询所有 顺序
select name
from user3;#查询所有姓名
select id,name,age,sex
from user3
where name
=‘李四‘ and age
=2;
select id,name,age,sex
from user3
where name
=‘李四‘ or age
=2;
select * from user3
order by id
asc;#按id 升序排列
select * from user3
order by id
desc;#按id 降序排列
Navicat Premium mysql
标签：
