del.del文件导入mysql_如何制作sql文件导入数据库学习

第一步：创建del_data.sql文件，复制分割线里的代码，将文本名和txt后缀改成del_data.sql；

----------------------------​分割线--------------------------------------------------------

​ALTER TABLE departmentsDISABLE

CONSTRAINT DEPT_MGR_FK;ALTER TABLE job_historyDISABLE CONSTRAINT

JHIST_EMP_FK;DROP TRIGGER secure_employees;DROP TRIGGER

update_job_history;DROP PROCEDURE add_job_history;DROP PROCEDURE

secure_dml;DELETE FROM employeesWHERE manager_id IN (108, 114, 120,

121, 122, 123, 145, 146, 147, 148);DELETE FROM employeesWHERE

employee_id IN (114, 120, 121, 122, 123, 145, 146, 147, 148,

196, 197, 198, 199, 105, 106, 108, 175, 177,

179, 203, 204);DELETE FROM locationsWHERE location_id NOT IN

(SELECT DISTINCT

location_id   FROM

departments);DELETE FROM countriesWHERE country_id NOT

IN  (SELECT

country_id   FROM

locations);DELETE FROM jobsWHERE job_id NOT IN

(SELECT job_id   FROM

employees);DELETE FROM departmentsWHERE department_id NOT IN

(SELECT DISTINCT

department_id   FROM

employees   WHERE department_id

IS NOT NULL);UPDATE departmentsSET manager_id = 124WHERE

department_id = 50;UPDATE departmentsSET manager_id = 149WHERE

department_id = 80;DELETE FROM locationsWHERE location_id IN (2700,

2400);UPDATE locationsSET street_address = '460 Bloor St. W.',

postal_code

= 'ON M5S 1X8'WHERE location_id = 1800;ALTER TABLE

departmentsENABLE CONSTRAINT DEPT_MGR_FK;CREATE TABLE

job_grades(grade_level

VARCHAR2(3), lowest_sal

NUMBER, highest_sal NUMBER);INSERT INTO

job_gradesVALUES ('A', 1000, 2999);INSERT INTO job_gradesVALUES

('B', 3000, 5999);INSERT INTO job_gradesVALUES('C', 6000,

9999);INSERT INTO job_gradesVALUES('D', 10000, 14999);INSERT INTO

job_gradesVALUES('E', 15000, 24999);INSERT INTO

job_gradesVALUES('F', 25000, 40000);INSERT INTO departments VALUES

( 190

,

'Contracting'

,

NULL

,

1700

);COMMIT;

​--------------分割线----------------------------------------------------------------------

创建​hr_cre.sql文件，操作步骤同上；

--------------------------分割线----------------------------------------------------------

​SET FEEDBACK 1SET NUMWIDTH 10SET

LINESIZE 80SET TRIMSPOOL ONSET TAB OFFSET PAGESIZE 100SET ECHO OFF

REM

*************************************