数据库
三木森森の
安安静静的过完这一生,有意义的事情都不简单,加油
展开
-
数据库练习,Navicat_Premium_12_破解补丁.zip
SELECT * FROM employee ORDER BY salary desc, id DESC; //asc 升序 默认 desc 降序 SELECT COUNT(*) from employee; SELECT count(*) from employee WHERE salary>2500; SELECT count(*) from employee WHERE IFNULL...原创 2018-09-07 00:25:41 · 290 阅读 · 0 评论 -
mysql 必知必会
#SHOW DATABASES #USE user #SELECT * FROM users ORDER BY name #SELECT * FROM users WHERE name NOT IN ('4444','Hello World') #SELECT * FROM users WHERE name LIKE '%4%' #百分号通配符 匹配多个 #SELECT * FROM users...原创 2019-09-19 18:52:51 · 152 阅读 · 0 评论