MYSQL

条件判断

CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ... ELSE defau...

检查是否有未关闭的事务

SELECT * FROM information_schema.INNODB_TRX;

mysql 格式化时间戳

SELECT DATE_FORMAT(FROM_UNIXTIME(timestamp_col), '%Y-%m-%d %H:%i:%s') AS formatted_time FROM you...