MySQL
数据库基本单词:
databas;数据库
table 数据表
row 数据行
column 列
field 列
unique 唯一的
基本查询语句
where代表条件,条件用and or..连接;*代表统配;count分页功能;最大值max,最小值min;平均值avg
增:insert
insert into 表名(name,gender...)values("张三",“男”...) 具体增加字段,values内容是
删:delete
delete from 表名 where where后面加删除的的条件
比如
delete from users where id = 6 id=1的删除
delete from users where id = 6 and gender = 0
delete from users where id = 6 or gender = 0
delete from users where id > 6
delete from users where id in (4, 5)
改:update
直接更改数据 名字改为王五,性别为0
update 表名 set name='王五',gender= 0
查:select
select into 字段,字段 from 表名
|
|