力扣日记——数据库篇(1)
627
题目:
MySQL教程
MySQL的update用法
UPDATE table_name SET field1=new-value1, field2=new-value2
[WHERE Clause]
if用法
IF(expr1,expr2,expr3)
如果 expr1 是TRUE (expr1 <> 0 and expr1 <> NULL),则 IF()的返回值为expr2; 否则返回值则为 expr3。IF() 的返回值为数字值或字符串值,具体情况视其所在语境而定。
解:
update salary set sex = if (sex = "m", "f", "m");
620
题目:
mysql 查询语句用法:
SELECT column_name,column_name
FROM table_name
[WHERE Clause]
[LIMIT N][ OFFSET M]
where:
SELECT field1, field2,...fieldN FROM table_name1, table_name2...
[WHERE condition1 [AND [OR]] condition2.....
判断奇数用mod
mysql排序
SELECT field1, field2,...fieldN FROM table_name1, table_name2...
ORDER BY field1 [ASC [DESC][默认 ASC]], [field2...] [ASC [DESC][默认 ASC]]
desc是降序,默认升序
解:
SELECT *
FROM cinema
WHERE mod(id,2)=1 and description!='boring'
order by rating DESC
183
主要是
修改栏目名
用not in
可以嵌套select
解:
select Name as 'Customers' from Customers
where ID not in(select CustomerID from Orders)