当前位置：网站首页>Database operation skills 7

Database operation skills 7

2022-07-26 08:52:00 【wuyunbilige66】

1. establish test database

2. stay test Create in the database emp surface

3. towards emp Add records to the table

4. Look up everything in the table

5. The name in the query table is all the message records of Zhang San
6. The name in the query table is the name of all employees consisting of three words ename,job,sal The corresponding information of the field

7. In the query table empno Fields from 1004 to 1008 Records of all employees

8. Query all in the table job All the information of the employee whose field is clerk and whose name is Huang Gai

9. Query table in 2001 Information of employees who have been employed since

10. The bonus in the query table （COMM） yes NULL Employee information

————————————————
Copyright notice ： This paper is about CSDN Blogger 「wuyunbilige66」 The original article of , follow CC 4.0 BY-SA Copyright agreement , For reprint, please attach the original source link and this statement .
Link to the original text ：https://blog.csdn.net/wuyunbilige66/article/details/125982450