记录一些可能会用到的sql语句

记录一些SQL语句

IF…ELSE

select *,if(sva=1,"男","女") as ssva from taname where sva != ""

CASE…WHEN

update goods 

set price = ( 

case  

  when price between 0 and 99 then price * 1.2 

  when price between 100 and 999 then price * 1.1 

  when price between 1000 and 1999 then price * 1.05 

  when price > 1999 then price * 1.02 

end)

日期加减

INSERT INTO rentbookmsg VALUES ('bookname',2,'bob',3,NOW(),DATE_ADD(now(),INTERVAL 2 MONTH));

group_concat

直接上连接->>><<<<<—

查看事务隔离级别

查看当前会话

select @@tx_isolation;

查看全局

select @@global.tx_isolation;

设置当前会话

set session transaction isolatin level repeatable read;

设置全局

set global transaction isolation level repeatable read;