随笔分类 -  msyql

摘要：1、select xxx from xxx where ... = > < <> >= <= and or not 2、模糊查询 LIKE BETWEEN IS NULL IS NOT NULL 阅读全文

摘要：//查询常量SELECT 100;SELECT 'Mike'; #查询表达式SELECT 100%98; #查询函数SELECT VERSION(); #起别名SELECT 100%98 AS result; SELECT last_name AS 姓, first_name AS 名FROM em 阅读全文