
MySQL
yao_yao_2015
这个作者很懒,什么都没留下…
展开
-
[数据库SQL实战] 习题及答案
1. 查找最晚员工信息SELECT * FROM employees WHERE hire_date=(SELECT MAX(hire_date) FROM employees) LIMIT 0,1SELECT * FROM employees ORDER BY hire_date DESC LIMIT 0,1注意:一定要增加limit,因为最晚入职的人可能不止一个2. 查找最晚入职排名第三的员工...原创 2018-03-19 11:00:58 · 2260 阅读 · 1 评论 -
MySQL 5.7使用时出现的问题
create database create;报错:ERROR 1064(42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘create' at line1.解决方...原创 2018-03-30 13:33:05 · 911 阅读 · 0 评论