以“bank”为例
登录:mysql -u sccc -p * bank
创建:create database bank;
使用:use bank;
删除:drop database bank;
插入:insert into …
(A,B,C) 可以不包含全部列
values(a,b,c);
查询:select … 别名:as
from … 去重:distinct
where …
order by …;
更新:update …
set … = … ,
… = … ,
… = … ,
where … = … ;
删除:delete from …
where … = … ;
级联:on delete / upgrade cascade;
合并:from A inner join B on A.a = B.b;
A join B 等同于 B inner join A
count() -> group by
null不参与比较,查询可能会漏掉
ceil() floor() round() truncate()
mysql delete 不能使用别名