接触原生sql语句也有一段时间了，记录下一些常用的sql语句

持续更新中......

//查询
SELECT * FROM table_name

SELECT * FROM table_name WHERE column_name='column_value'

SELECT column_name FROM table_name

//修改
UPDATE table_name WHERE column_name='column_value'

UPDATE table_name SET  column_name = CASE WHEN column_name_1='column_value' AND column_name_2='0' THEN '0' ELSE '1' END  WHERE column_name_3 = 'column_value'

//删除
DELETE table_name WHERE column_name='column_value'

//left join
SELECT * FROM table_name_1 AS a LEFT JOIN table_name_2 AS b WHERE a.column_name = b.cloumn