11. INSERT INTO 语句(向table中插入raw)---*/
INSERT INTO departments VALUES ('d010', 'Information Management');
12. INSERT INTO 语句(向table中指定的column插入数据)---*/
INSERT INTO departments (dept_no) VALUES ('d011');
13. UPDATE 语句(更新table中已存在的记录)---*/
update departments set dept_name='Factory' where dept_no='d011';
14. DELETE 语句(删除table中已存在特定记录)---*/
delete from departments where dept_no='d011';
15. DELETE 语句(删除table中所有记录)---*/
DELETE FROM departments;
16. SELECT TOP 语句(选取table中前面8条的记录)---*/
SELECT * FROM departments LIMIT 8;
17. SELECT TOP 语句(选取table中从第2条以后的4条记录)---*/
SELECT * FROM departments LIMIT 2 , 4;
18. LIKE 操作符(搜索column中符合指定模式的数据)---*/
SELECT * FROM departments where dept_name like '%Management'
19. 通配符,在 SQL 中,可使用以下通配符:
%:替代 0 个或多个字符
_:替代一个字符
[]:字符列中的任何单一字符
19-2. % 通配符*/
SELECT * FROM departments where dept_name like '_a_e_%'
19-3. [charlist] 通配符 (找出dept_name有 "P"或"V"的数据)*/
SELECT * FROM departments where dept_name REGEXP '[PV]'
20. IN 操作符(搜索column中存在于指定条件内的数据)---*/
SELECT * FROM departments where dept_name IN ('Marketing', 'Finance', 'Sales');
INSERT INTO departments VALUES ('d010', 'Information Management');
12. INSERT INTO 语句(向table中指定的column插入数据)---*/
INSERT INTO departments (dept_no) VALUES ('d011');
13. UPDATE 语句(更新table中已存在的记录)---*/
update departments set dept_name='Factory' where dept_no='d011';
14. DELETE 语句(删除table中已存在特定记录)---*/
delete from departments where dept_no='d011';
15. DELETE 语句(删除table中所有记录)---*/
DELETE FROM departments;
16. SELECT TOP 语句(选取table中前面8条的记录)---*/
SELECT * FROM departments LIMIT 8;
17. SELECT TOP 语句(选取table中从第2条以后的4条记录)---*/
SELECT * FROM departments LIMIT 2 , 4;
18. LIKE 操作符(搜索column中符合指定模式的数据)---*/
SELECT * FROM departments where dept_name like '%Management'
19. 通配符,在 SQL 中,可使用以下通配符:
%:替代 0 个或多个字符
_:替代一个字符
[]:字符列中的任何单一字符
19-1. % 通配符*/
SELECT * FROM departments where dept_name like '%Re%'19-2. % 通配符*/
SELECT * FROM departments where dept_name like '_a_e_%'
19-3. [charlist] 通配符 (找出dept_name有 "P"或"V"的数据)*/
SELECT * FROM departments where dept_name REGEXP '[PV]'
20. IN 操作符(搜索column中存在于指定条件内的数据)---*/
SELECT * FROM departments where dept_name IN ('Marketing', 'Finance', 'Sales');