Skip to content

#sql

CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ... ELSE resultn END

SQL 脚本中如何定义变量?

sql
SET @ps_id := (SELECT MAX(id) FROM datacenter.DC_POWER_STATION);
SET @ps_id := (SELECT MAX(id) FROM datacenter.DC_POWER_STATION);

// 自增