摘要: 查询语句查询emp_no,所以先查询emp_no的索引使用primary select emp_no,salary from salaries use index(s_f_t) where emp_no<11010 and salary<60000 阅读全文
posted @ 2017-06-08 15:37 paul_hch 阅读(11177) 评论(0) 推荐(0)
摘要: 创建和表departments结构和数据一样的表departments_t mysql> create table departments_t like departments; Query OK, 0 rows affected (1.61 sec) mysql> insert into depa 阅读全文
posted @ 2017-06-08 15:16 paul_hch 阅读(3604) 评论(0) 推荐(0)