SQL - Kuangcp/Note GitHub Wiki


title: SQL基础 date: 2018-12-16 17:29:28 tags: - SQL categories: - 数据库

目录 start

  1. SQL

目录 end|2020-04-27 23:42|


SQL

基础SQL语言的学习使用

soarSQL Optimizer And Rewriter

条件语句

case when then else end

update table_test set mark = 
    case
        when id = 2 then '2'
        when id = 5 then '5' 
        else ''
    end
where id in (2,5);
⚠️ **GitHub.com Fallback** ⚠️