hr

create database if not exists hr DEFAULT CHARACTER set utf8;
use hr;

drop table if exists depts;
drop table if exists emps;
drop table if exists jobs;
drop table if exists locations;
drop table if exists countries;
drop table if exists regions;
drop table if exists job_history;

CREATE TABLE regions
(
region_id int primary key auto_increment,
region_name VARCHAR(25)
) engine=innodb default character set utf8;

CREATE TABLE countries
(
country_id CHAR(2) primary key
, country_name VARCHAR(40)
, region_id int
)engine=innodb default character set utf8;

ALTER TABLE countries
ADD (
CONSTRAINT countr_reg_fk
FOREIGN KEY (region_id)
REFERENCES regions(region_id)
);

CREATE TABLE locations
( loc_id int(4) primary key auto_increment
, street VARCHAR(40)
, post VARCHAR(12)
, city VARCHAR(30) not null
, state VARCHAR(25)
, country_id CHAR(2)
) engine=innodb default character set utf8;

ALTER TABLE locations
ADD (
CONSTRAINT loc_c_id_fk
FOREIGN KEY (country_id)
REFERENCES countries(country_id)
);

CREATE TABLE depts
( dept_id int(4) primary key auto_increment
, dept_name VARCHAR(30) NOT NULL
, mgr_id int(6)
, loc_id int(4)
) engine=innodb default character set utf8;

ALTER TABLE depts
ADD (
CONSTRAINT dept_loc_fk
FOREIGN KEY (loc_id)
REFERENCES locations (loc_id)
) ;

CREATE TABLE jobs
( job_id VARCHAR(10) primary key
, job_title VARCHAR(35) NOT NULL
, min_sal numeric(6)
, max_sal numeric(6)
) engine=innodb default character set utf8;

CREATE TABLE emps
( id int(6) primary key auto_increment
, fname VARCHAR(20)
, lname VARCHAR(25) NOT NULL
, email VARCHAR(25) NOT NULL
, tel VARCHAR(20)
, hdate DATE NOT NULL
, job_id VARCHAR(10) NOT NULL
, sal numeric(8,2)
, com_pct numeric(2,2)
, mgr_id int(6)
, dept_id int(4)
, CONSTRAINT emp_sal_min CHECK (sal > 0)
, CONSTRAINT emp_email_uk UNIQUE (email)
) engine=innodb default character set utf8;

ALTER TABLE emps
ADD (
CONSTRAINT emp_dept_fk
FOREIGN KEY (dept_id)
REFERENCES depts(dept_id)
,
CONSTRAINT emp_job_fk
FOREIGN KEY (job_id)
REFERENCES jobs (job_id)
,
CONSTRAINT emp_manager_fk
FOREIGN KEY (mgr_id)
REFERENCES emps(id)
) ;
ALTER TABLE depts
ADD (
CONSTRAINT dept_mgr_fk
FOREIGN KEY (mgr_id)
REFERENCES emps (id)
) ;

CREATE TABLE job_history
( id int(6) NOT NULL
, start_date DATE NOT NULL
, end_date DATE NOT NULL
, job_id VARCHAR(10) NOT NULL
, dept_id int(4)
, CONSTRAINT jhist_date_interval
CHECK (end_date > start_date)
, CONSTRAINT jhist_emp_id_st_date_pk PRIMARY KEY (id, start_date)
) engine=innodb default character set utf8;

ALTER TABLE job_history
ADD (
CONSTRAINT jhist_job_fk
FOREIGN KEY (job_id)
REFERENCES jobs(job_id)
,
CONSTRAINT jhist_emp_fk
FOREIGN KEY (id)
REFERENCES emps(id)
,
CONSTRAINT jhist_dept_fk
FOREIGN KEY (dept_id)
REFERENCES depts(dept_id)
) ;

SET FOREIGN_KEY_CHECKS = 0;

INSERT INTO regions VALUES
( 1
, 'Europe'
);

INSERT INTO regions VALUES
( 2
, 'Americas'
);

INSERT INTO regions VALUES
( 3
, 'Asia'
);

INSERT INTO regions VALUES
( 4
, 'Middle East and Africa'
);

INSERT INTO countries VALUES
( 'IT'
, 'Italy'
, 1
);

INSERT INTO countries VALUES
( 'JP'
, 'Japan'
, 3
);

INSERT INTO countries VALUES
( 'US'
, 'United States of America'
, 2
);

INSERT INTO countries VALUES
( 'CA'
, 'Canada'
, 2
);

INSERT INTO countries VALUES
( 'CN'
, 'China'
, 3
);

INSERT INTO countries VALUES
( 'IN'
, 'India'
, 3
);

INSERT INTO countries VALUES
( 'AU'
, 'Australia'
, 3
);

INSERT INTO countries VALUES
( 'ZW'
, 'Zimbabwe'
, 4
);

INSERT INTO countries VALUES
( 'SG'
, 'Singapore'
, 3
);

INSERT INTO countries VALUES
( 'UK'
, 'United Kingdom'
, 1
);

INSERT INTO countries VALUES
( 'FR'
, 'France'
, 1
);

INSERT INTO countries VALUES
( 'DE'
, 'Germany'
, 1
);

INSERT INTO countries VALUES
( 'ZM'
, 'Zambia'
, 4
);

INSERT INTO countries VALUES
( 'EG'
, 'Egypt'
, 4
);

INSERT INTO countries VALUES
( 'BR'
, 'Brazil'
, 2
);

INSERT INTO countries VALUES
( 'CH'
, 'Switzerland'
, 1
);

INSERT INTO countries VALUES
( 'NL'
, 'Netherlands'
, 1
);

INSERT INTO countries VALUES
( 'MX'
, 'Mexico'
, 2
);

INSERT INTO countries VALUES
( 'KW'
, 'Kuwait'
, 4
);

INSERT INTO countries VALUES
( 'IL'
, 'Israel'
, 4
);

INSERT INTO countries VALUES
( 'DK'
, 'Denmark'
, 1
);

INSERT INTO countries VALUES
( 'HK'
, 'HongKong'
, 3
);

INSERT INTO countries VALUES
( 'NG'
, 'Nigeria'
, 4
);

INSERT INTO countries VALUES
( 'AR'
, 'Argentina'
, 2
);

INSERT INTO countries VALUES
( 'BE'
, 'Belgium'
, 1
);

INSERT INTO locations VALUES
( 1000
, '1297 Via Cola di Rie'
, '00989'
, 'Roma'
, NULL
, 'IT'
);

INSERT INTO locations VALUES
( 1100
, '93091 Calle della Testa'
, '10934'
, 'Venice'
, NULL
, 'IT'
);

INSERT INTO locations VALUES
( 1200
, '2017 Shinjuku-ku'
, '1689'
, 'Tokyo'
, 'Tokyo Prefecture'
, 'JP'
);

INSERT INTO locations VALUES
( 1300
, '9450 Kamiya-cho'
, '6823'
, 'Hiroshima'
, NULL
, 'JP'
);

INSERT INTO locations VALUES
( 1400
, '2014 Jabberwocky Rd'
, '26192'
, 'Southlake'
, 'Texas'
, 'US'
);

INSERT INTO locations VALUES
( 1500
, '2011 Interiors Blvd'
, '99236'
, 'South San Francisco'
, 'California'
, 'US'
);

INSERT INTO locations VALUES
( 1600
, '2007 Zagora St'
, '50090'
, 'South Brunswick'
, 'New Jersey'
, 'US'
);

INSERT INTO locations VALUES
( 1700
, '2004 Charade Rd'
, '98199'
, 'Seattle'
, 'Washington'
, 'US'
);

INSERT INTO locations VALUES
( 1800
, '147 Spadina Ave'
, 'M5V 2L7'
, 'Toronto'
, 'Ontario'
, 'CA'
);

INSERT INTO locations VALUES
( 1900
, '6092 Boxwood St'
, 'YSW 9T2'
, 'Whitehorse'
, 'Yukon'
, 'CA'
);

INSERT INTO locations VALUES
( 2000
, '40-5-12 Laogianggen'
, '190518'
, 'Beijing'
, NULL
, 'CN'
);

INSERT INTO locations VALUES
( 2100
, '1298 Vileparle (E)'
, '490231'
, 'Bombay'
, 'Maharashtra'
, 'IN'
);

INSERT INTO locations VALUES
( 2200
, '12-98 Victoria Street'
, '2901'
, 'Sydney'
, 'New South Wales'
, 'AU'
);

INSERT INTO locations VALUES
( 2300
, '198 Clementi North'
, '540198'
, 'Singapore'
, NULL
, 'SG'
);

INSERT INTO locations VALUES
( 2400
, '8204 Arthur St'
, NULL
, 'London'
, NULL
, 'UK'
);

INSERT INTO locations VALUES
( 2500
, 'Magdalen Centre, The Oxford Science Park'
, 'OX9 9ZB'
, 'Oxford'
, 'Oxford'
, 'UK'
);

INSERT INTO locations VALUES
( 2600
, '9702 Chester Road'
, '09629850293'
, 'Stretford'
, 'Manchester'
, 'UK'
);

INSERT INTO locations VALUES
( 2700
, 'Schwanthalerstr. 7031'
, '80925'
, 'Munich'
, 'Bavaria'
, 'DE'
);

INSERT INTO locations VALUES
( 2800
, 'Rua Frei Caneca 1360 '
, '01307-002'
, 'Sao Paulo'
, 'Sao Paulo'
, 'BR'
);

INSERT INTO locations VALUES
( 2900
, '20 Rue des Corps-Saints'
, '1730'
, 'Geneva'
, 'Geneve'
, 'CH'
);

INSERT INTO locations VALUES
( 3000
, 'Murtenstrasse 921'
, '3095'
, 'Bern'
, 'BE'
, 'CH'
);

INSERT INTO locations VALUES
( 3100
, 'Pieter Breughelstraat 837'
, '3029SK'
, 'Utrecht'
, 'Utrecht'
, 'NL'
);

INSERT INTO locations VALUES
( 3200
, 'Mariano Escobedo 9991'
, '11932'
, 'Mexico City'
, 'Distrito Federal,'
, 'MX'
);

INSERT INTO depts VALUES
( 10
, 'Administration'
, 200
, 1700
);

INSERT INTO depts VALUES
( 20
, 'Marketing'
, 201
, 1800
);

INSERT INTO depts VALUES
( 30
, 'Purchasing'
, 114
, 1700
);

INSERT INTO depts VALUES
( 40
, 'Human Resources'
, 203
, 2400
);

INSERT INTO depts VALUES
( 50
, 'Shipping'
, 121
, 1500
);

INSERT INTO depts VALUES
( 60
, 'IT'
, 103
, 1400
);

INSERT INTO depts VALUES
( 70
, 'Public Relations'
, 204
, 2700
);

INSERT INTO depts VALUES
( 80
, 'Sales'
, 145
, 2500
);

INSERT INTO depts VALUES
( 90
, 'Executive'
, 100
, 1700
);

INSERT INTO depts VALUES
( 100
, 'Finance'
, 108
, 1700
);

INSERT INTO depts VALUES
( 110
, 'Accounting'
, 205
, 1700
);

INSERT INTO depts VALUES
( 120
, 'Treasury'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 130
, 'Corporate Tax'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 140
, 'Control And Credit'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 150
, 'Shareholder Services'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 160
, 'Benefits'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 170
, 'Manufacturing'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 180
, 'Construction'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 190
, 'Contracting'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 200
, 'Operations'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 210
, 'IT Support'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 220
, 'NOC'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 230
, 'IT Helpdesk'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 240
, 'Government Sales'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 250
, 'Retail Sales'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 260
, 'Recruiting'
, NULL
, 1700
);

INSERT INTO depts VALUES
( 270
, 'Payroll'
, NULL
, 1700
);

INSERT INTO jobs VALUES
( 'AD_PRES'
, 'President'
, 20000
, 40000
);
INSERT INTO jobs VALUES
( 'AD_VP'
, 'Administration Vice President'
, 15000
, 30000
);

INSERT INTO jobs VALUES
( 'AD_ASST'
, 'Administration Assistant'
, 3000
, 6000
);

INSERT INTO jobs VALUES
( 'FI_MGR'
, 'Finance Manager'
, 8200
, 16000
);

INSERT INTO jobs VALUES
( 'FI_ACCOUNT'
, 'Accountant'
, 4200
, 9000
);

INSERT INTO jobs VALUES
( 'AC_MGR'
, 'Accounting Manager'
, 8200
, 16000
);

INSERT INTO jobs VALUES
( 'AC_ACCOUNT'
, 'Public Accountant'
, 4200
, 9000
);
INSERT INTO jobs VALUES
( 'SA_MAN'
, 'Sales Manager'
, 10000
, 20000
);

INSERT INTO jobs VALUES
( 'SA_REP'
, 'Sales Representative'
, 6000
, 12000
);

INSERT INTO jobs VALUES
( 'PU_MAN'
, 'Purchasing Manager'
, 8000
, 15000
);

INSERT INTO jobs VALUES
( 'PU_CLERK'
, 'Purchasing Clerk'
, 2500
, 5500
);

INSERT INTO jobs VALUES
( 'ST_MAN'
, 'Stock Manager'
, 5500
, 8500
);
INSERT INTO jobs VALUES
( 'ST_CLERK'
, 'Stock Clerk'
, 2000
, 5000
);

INSERT INTO jobs VALUES
( 'SH_CLERK'
, 'Shipping Clerk'
, 2500
, 5500
);

INSERT INTO jobs VALUES
( 'IT_PROG'
, 'Programmer'
, 4000
, 10000
);

INSERT INTO jobs VALUES
( 'MK_MAN'
, 'Marketing Manager'
, 9000
, 15000
);

INSERT INTO jobs VALUES
( 'MK_REP'
, 'Marketing Representative'
, 4000
, 9000
);

INSERT INTO jobs VALUES
( 'HR_REP'
, 'Human Resources Representative'
, 4000
, 9000
);

INSERT INTO jobs VALUES
( 'PR_REP'
, 'Public Relations Representative'
, 4500
, 10500
);

INSERT INTO emps VALUES
( 100
, 'Steven'
, 'King'
, 'SKING'
, '515.123.4567'
, STR_TO_DATE('17-JUN-1987', '%d-%b-%Y')
, 'AD_PRES'
, 24000
, NULL
, NULL
, 90
);

INSERT INTO emps VALUES
( 101
, 'Neena'
, 'Kochhar'
, 'NKOCHHAR'
, '515.123.4568'
, STR_TO_DATE('21-SEP-1989', '%d-%b-%Y')
, 'AD_VP'
, 17000
, NULL
, 100
, 90
);

INSERT INTO emps VALUES
( 102
, 'Lex'
, 'De Haan'
, 'LDEHAAN'
, '515.123.4569'
, STR_TO_DATE('13-JAN-1993', '%d-%b-%Y')
, 'AD_VP'
, 17000
, NULL
, 100
, 90
);

INSERT INTO emps VALUES
( 103
, 'Alexander'
, 'Hunold'
, 'AHUNOLD'
, '590.423.4567'
, STR_TO_DATE('03-JAN-1990', '%d-%b-%Y')
, 'IT_PROG'
, 9000
, NULL
, 102
, 60
);

INSERT INTO emps VALUES
( 104
, 'Bruce'
, 'Ernst'
, 'BERNST'
, '590.423.4568'
, STR_TO_DATE('21-MAY-1991', '%d-%b-%Y')
, 'IT_PROG'
, 6000
, NULL
, 103
, 60
);

INSERT INTO emps VALUES
( 105
, 'David'
, 'Austin'
, 'DAUSTIN'
, '590.423.4569'
, STR_TO_DATE('25-JUN-1997', '%d-%b-%Y')
, 'IT_PROG'
, 4800
, NULL
, 103
, 60
);

INSERT INTO emps VALUES
( 106
, 'Valli'
, 'Pataballa'
, 'VPATABAL'
, '590.423.4560'
, STR_TO_DATE('05-FEB-1998', '%d-%b-%Y')
, 'IT_PROG'
, 4800
, NULL
, 103
, 60
);

INSERT INTO emps VALUES
( 107
, 'Diana'
, 'Lorentz'
, 'DLORENTZ'
, '590.423.5567'
, STR_TO_DATE('07-FEB-1999', '%d-%b-%Y')
, 'IT_PROG'
, 4200
, NULL
, 103
, 60
);

INSERT INTO emps VALUES
( 108
, 'Nancy'
, 'Greenberg'
, 'NGREENBE'
, '515.124.4569'
, STR_TO_DATE('17-AUG-1994', '%d-%b-%Y')
, 'FI_MGR'
, 12000
, NULL
, 101
, 100
);

INSERT INTO emps VALUES
( 109
, 'Daniel'
, 'Faviet'
, 'DFAVIET'
, '515.124.4169'
, STR_TO_DATE('16-AUG-1994', '%d-%b-%Y')
, 'FI_ACCOUNT'
, 9000
, NULL
, 108
, 100
);

INSERT INTO emps VALUES
( 110
, 'John'
, 'Chen'
, 'JCHEN'
, '515.124.4269'
, STR_TO_DATE('28-SEP-1997', '%d-%b-%Y')
, 'FI_ACCOUNT'
, 8200
, NULL
, 108
, 100
);

INSERT INTO emps VALUES
( 111
, 'Ismael'
, 'Sciarra'
, 'ISCIARRA'
, '515.124.4369'
, STR_TO_DATE('30-SEP-1997', '%d-%b-%Y')
, 'FI_ACCOUNT'
, 7700
, NULL
, 108
, 100
);

INSERT INTO emps VALUES
( 112
, 'Jose Manuel'
, 'Urman'
, 'JMURMAN'
, '515.124.4469'
, STR_TO_DATE('07-MAR-1998', '%d-%b-%Y')
, 'FI_ACCOUNT'
, 7800
, NULL
, 108
, 100
);

INSERT INTO emps VALUES
( 113
, 'Luis'
, 'Popp'
, 'LPOPP'
, '515.124.4567'
, STR_TO_DATE('07-DEC-1999', '%d-%b-%Y')
, 'FI_ACCOUNT'
, 6900
, NULL
, 108
, 100
);

INSERT INTO emps VALUES
( 114
, 'Den'
, 'Raphaely'
, 'DRAPHEAL'
, '515.127.4561'
, STR_TO_DATE('07-DEC-1994', '%d-%b-%Y')
, 'PU_MAN'
, 11000
, NULL
, 100
, 30
);

INSERT INTO emps VALUES
( 115
, 'Alexander'
, 'Khoo'
, 'AKHOO'
, '515.127.4562'
, STR_TO_DATE('18-MAY-1995', '%d-%b-%Y')
, 'PU_CLERK'
, 3100
, NULL
, 114
, 30
);

INSERT INTO emps VALUES
( 116
, 'Shelli'
, 'Baida'
, 'SBAIDA'
, '515.127.4563'
, STR_TO_DATE('24-DEC-1997', '%d-%b-%Y')
, 'PU_CLERK'
, 2900
, NULL
, 114
, 30
);

INSERT INTO emps VALUES
( 117
, 'Sigal'
, 'Tobias'
, 'STOBIAS'
, '515.127.4564'
, STR_TO_DATE('24-JUL-1997', '%d-%b-%Y')
, 'PU_CLERK'
, 2800
, NULL
, 114
, 30
);

INSERT INTO emps VALUES
( 118
, 'Guy'
, 'Himuro'
, 'GHIMURO'
, '515.127.4565'
, STR_TO_DATE('15-NOV-1998', '%d-%b-%Y')
, 'PU_CLERK'
, 2600
, NULL
, 114
, 30
);

INSERT INTO emps VALUES
( 119
, 'Karen'
, 'Colmenares'
, 'KCOLMENA'
, '515.127.4566'
, STR_TO_DATE('10-AUG-1999', '%d-%b-%Y')
, 'PU_CLERK'
, 2500
, NULL
, 114
, 30
);

INSERT INTO emps VALUES
( 120
, 'Matthew'
, 'Weiss'
, 'MWEISS'
, '650.123.1234'
, STR_TO_DATE('18-JUL-1996', '%d-%b-%Y')
, 'ST_MAN'
, 8000
, NULL
, 100
, 50
);

INSERT INTO emps VALUES
( 121
, 'Adam'
, 'Fripp'
, 'AFRIPP'
, '650.123.2234'
, STR_TO_DATE('10-APR-1997', '%d-%b-%Y')
, 'ST_MAN'
, 8200
, NULL
, 100
, 50
);

INSERT INTO emps VALUES
( 122
, 'Payam'
, 'Kaufling'
, 'PKAUFLIN'
, '650.123.3234'
, STR_TO_DATE('01-MAY-1995', '%d-%b-%Y')
, 'ST_MAN'
, 7900
, NULL
, 100
, 50
);

INSERT INTO emps VALUES
( 123
, 'Shanta'
, 'Vollman'
, 'SVOLLMAN'
, '650.123.4234'
, STR_TO_DATE('10-OCT-1997', '%d-%b-%Y')
, 'ST_MAN'
, 6500
, NULL
, 100
, 50
);

INSERT INTO emps VALUES
( 124
, 'Kevin'
, 'Mourgos'
, 'KMOURGOS'
, '650.123.5234'
, STR_TO_DATE('16-NOV-1999', '%d-%b-%Y')
, 'ST_MAN'
, 5800
, NULL
, 100
, 50
);

INSERT INTO emps VALUES
( 125
, 'Julia'
, 'Nayer'
, 'JNAYER'
, '650.124.1214'
, STR_TO_DATE('16-JUL-1997', '%d-%b-%Y')
, 'ST_CLERK'
, 3200
, NULL
, 120
, 50
);

INSERT INTO emps VALUES
( 126
, 'Irene'
, 'Mikkilineni'
, 'IMIKKILI'
, '650.124.1224'
, STR_TO_DATE('28-SEP-1998', '%d-%b-%Y')
, 'ST_CLERK'
, 2700
, NULL
, 120
, 50
);

INSERT INTO emps VALUES
( 127
, 'James'
, 'Landry'
, 'JLANDRY'
, '650.124.1334'
, STR_TO_DATE('14-JAN-1999', '%d-%b-%Y')
, 'ST_CLERK'
, 2400
, NULL
, 120
, 50
);

INSERT INTO emps VALUES
( 128
, 'Steven'
, 'Markle'
, 'SMARKLE'
, '650.124.1434'
, STR_TO_DATE('08-MAR-2000', '%d-%b-%Y')
, 'ST_CLERK'
, 2200
, NULL
, 120
, 50
);

INSERT INTO emps VALUES
( 129
, 'Laura'
, 'Bissot'
, 'LBISSOT'
, '650.124.5234'
, STR_TO_DATE('20-AUG-1997', '%d-%b-%Y')
, 'ST_CLERK'
, 3300
, NULL
, 121
, 50
);

INSERT INTO emps VALUES
( 130
, 'Mozhe'
, 'Atkinson'
, 'MATKINSO'
, '650.124.6234'
, STR_TO_DATE('30-OCT-1997', '%d-%b-%Y')
, 'ST_CLERK'
, 2800
, NULL
, 121
, 50
);

INSERT INTO emps VALUES
( 131
, 'James'
, 'Marlow'
, 'JAMRLOW'
, '650.124.7234'
, STR_TO_DATE('16-FEB-1997', '%d-%b-%Y')
, 'ST_CLERK'
, 2500
, NULL
, 121
, 50
);

INSERT INTO emps VALUES
( 132
, 'TJ'
, 'Olson'
, 'TJOLSON'
, '650.124.8234'
, STR_TO_DATE('10-APR-1999', '%d-%b-%Y')
, 'ST_CLERK'
, 2100
, NULL
, 121
, 50
);

INSERT INTO emps VALUES
( 133
, 'Jason'
, 'Mallin'
, 'JMALLIN'
, '650.127.1934'
, STR_TO_DATE('14-JUN-1996', '%d-%b-%Y')
, 'ST_CLERK'
, 3300
, NULL
, 122
, 50
);

INSERT INTO emps VALUES
( 134
, 'Michael'
, 'Rogers'
, 'MROGERS'
, '650.127.1834'
, STR_TO_DATE('26-AUG-1998', '%d-%b-%Y')
, 'ST_CLERK'
, 2900
, NULL
, 122
, 50
);

INSERT INTO emps VALUES
( 135
, 'Ki'
, 'Gee'
, 'KGEE'
, '650.127.1734'
, STR_TO_DATE('12-DEC-1999', '%d-%b-%Y')
, 'ST_CLERK'
, 2400
, NULL
, 122
, 50
);

INSERT INTO emps VALUES
( 136
, 'Hazel'
, 'Philtanker'
, 'HPHILTAN'
, '650.127.1634'
, STR_TO_DATE('06-FEB-2000', '%d-%b-%Y')
, 'ST_CLERK'
, 2200
, NULL
, 122
, 50
);

INSERT INTO emps VALUES
( 137
, 'Renske'
, 'Ladwig'
, 'RLADWIG'
, '650.121.1234'
, STR_TO_DATE('14-JUL-1995', '%d-%b-%Y')
, 'ST_CLERK'
, 3600
, NULL
, 123
, 50
);

INSERT INTO emps VALUES
( 138
, 'Stephen'
, 'Stiles'
, 'SSTILES'
, '650.121.2034'
, STR_TO_DATE('26-OCT-1997', '%d-%b-%Y')
, 'ST_CLERK'
, 3200
, NULL
, 123
, 50
);

INSERT INTO emps VALUES
( 139
, 'John'
, 'Seo'
, 'JSEO'
, '650.121.2019'
, STR_TO_DATE('12-FEB-1998', '%d-%b-%Y')
, 'ST_CLERK'
, 2700
, NULL
, 123
, 50
);

INSERT INTO emps VALUES
( 140
, 'Joshua'
, 'Patel'
, 'JPATEL'
, '650.121.1834'
, STR_TO_DATE('06-APR-1998', '%d-%b-%Y')
, 'ST_CLERK'
, 2500
, NULL
, 123
, 50
);

INSERT INTO emps VALUES
( 141
, 'Trenna'
, 'Rajs'
, 'TRAJS'
, '650.121.8009'
, STR_TO_DATE('17-OCT-1995', '%d-%b-%Y')
, 'ST_CLERK'
, 3500
, NULL
, 124
, 50
);

INSERT INTO emps VALUES
( 142
, 'Curtis'
, 'Davies'
, 'CDAVIES'
, '650.121.2994'
, STR_TO_DATE('29-JAN-1997', '%d-%b-%Y')
, 'ST_CLERK'
, 3100
, NULL
, 124
, 50
);

INSERT INTO emps VALUES
( 143
, 'Randall'
, 'Matos'
, 'RMATOS'
, '650.121.2874'
, STR_TO_DATE('15-MAR-1998', '%d-%b-%Y')
, 'ST_CLERK'
, 2600
, NULL
, 124
, 50
);

INSERT INTO emps VALUES
( 144
, 'Peter'
, 'Vargas'
, 'PVARGAS'
, '650.121.2004'
, STR_TO_DATE('09-JUL-1998', '%d-%b-%Y')
, 'ST_CLERK'
, 2500
, NULL
, 124
, 50
);

INSERT INTO emps VALUES
( 145
, 'John'
, 'Russell'
, 'JRUSSEL'
, '011.44.1344.429268'
, STR_TO_DATE('01-OCT-1996', '%d-%b-%Y')
, 'SA_MAN'
, 14000
, .4
, 100
, 80
);

INSERT INTO emps VALUES
( 146
, 'Karen'
, 'Partners'
, 'KPARTNER'
, '011.44.1344.467268'
, STR_TO_DATE('05-JAN-1997', '%d-%b-%Y')
, 'SA_MAN'
, 13500
, .3
, 100
, 80
);

INSERT INTO emps VALUES
( 147
, 'Alberto'
, 'Errazuriz'
, 'AERRAZUR'
, '011.44.1344.429278'
, STR_TO_DATE('10-MAR-1997', '%d-%b-%Y')
, 'SA_MAN'
, 12000
, .3
, 100
, 80
);

INSERT INTO emps VALUES
( 148
, 'Gerald'
, 'Cambrault'
, 'GCAMBRAU'
, '011.44.1344.619268'
, STR_TO_DATE('15-OCT-1999', '%d-%b-%Y')
, 'SA_MAN'
, 11000
, .3
, 100
, 80
);

INSERT INTO emps VALUES
( 149
, 'Eleni'
, 'Zlotkey'
, 'EZLOTKEY'
, '011.44.1344.429018'
, STR_TO_DATE('29-JAN-2000', '%d-%b-%Y')
, 'SA_MAN'
, 10500
, .2
, 100
, 80
);

INSERT INTO emps VALUES
( 150
, 'Peter'
, 'Tucker'
, 'PTUCKER'
, '011.44.1344.129268'
, STR_TO_DATE('30-JAN-1997', '%d-%b-%Y')
, 'SA_REP'
, 10000
, .3
, 145
, 80
);

INSERT INTO emps VALUES
( 151
, 'David'
, 'Bernstein'
, 'DBERNSTE'
, '011.44.1344.345268'
, STR_TO_DATE('24-MAR-1997', '%d-%b-%Y')
, 'SA_REP'
, 9500
, .25
, 145
, 80
);

INSERT INTO emps VALUES
( 152
, 'Peter'
, 'Hall'
, 'PHALL'
, '011.44.1344.478968'
, STR_TO_DATE('20-AUG-1997', '%d-%b-%Y')
, 'SA_REP'
, 9000
, .25
, 145
, 80
);

INSERT INTO emps VALUES
( 153
, 'Christopher'
, 'Olsen'
, 'COLSEN'
, '011.44.1344.498718'
, STR_TO_DATE('30-MAR-1998', '%d-%b-%Y')
, 'SA_REP'
, 8000
, .2
, 145
, 80
);

INSERT INTO emps VALUES
( 154
, 'Nanette'
, 'Cambrault'
, 'NCAMBRAU'
, '011.44.1344.987668'
, STR_TO_DATE('09-DEC-1998', '%d-%b-%Y')
, 'SA_REP'
, 7500
, .2
, 145
, 80
);

INSERT INTO emps VALUES
( 155
, 'Oliver'
, 'Tuvault'
, 'OTUVAULT'
, '011.44.1344.486508'
, STR_TO_DATE('23-NOV-1999', '%d-%b-%Y')
, 'SA_REP'
, 7000
, .15
, 145
, 80
);

INSERT INTO emps VALUES
( 156
, 'Janette'
, 'King'
, 'JKING'
, '011.44.1345.429268'
, STR_TO_DATE('30-JAN-1996', '%d-%b-%Y')
, 'SA_REP'
, 10000
, .35
, 146
, 80
);

INSERT INTO emps VALUES
( 157
, 'Patrick'
, 'Sully'
, 'PSULLY'
, '011.44.1345.929268'
, STR_TO_DATE('04-MAR-1996', '%d-%b-%Y')
, 'SA_REP'
, 9500
, .35
, 146
, 80
);

INSERT INTO emps VALUES
( 158
, 'Allan'
, 'McEwen'
, 'AMCEWEN'
, '011.44.1345.829268'
, STR_TO_DATE('01-AUG-1996', '%d-%b-%Y')
, 'SA_REP'
, 9000
, .35
, 146
, 80
);

INSERT INTO emps VALUES
( 159
, 'Lindsey'
, 'Smith'
, 'LSMITH'
, '011.44.1345.729268'
, STR_TO_DATE('10-MAR-1997', '%d-%b-%Y')
, 'SA_REP'
, 8000
, .3
, 146
, 80
);

INSERT INTO emps VALUES
( 160
, 'Louise'
, 'Doran'
, 'LDORAN'
, '011.44.1345.629268'
, STR_TO_DATE('15-DEC-1997', '%d-%b-%Y')
, 'SA_REP'
, 7500
, .3
, 146
, 80
);

INSERT INTO emps VALUES
( 161
, 'Sarath'
, 'Sewall'
, 'SSEWALL'
, '011.44.1345.529268'
, STR_TO_DATE('03-NOV-1998', '%d-%b-%Y')
, 'SA_REP'
, 7000
, .25
, 146
, 80
);

INSERT INTO emps VALUES
( 162
, 'Clara'
, 'Vishney'
, 'CVISHNEY'
, '011.44.1346.129268'
, STR_TO_DATE('11-NOV-1997', '%d-%b-%Y')
, 'SA_REP'
, 10500
, .25
, 147
, 80
);

INSERT INTO emps VALUES
( 163
, 'Danielle'
, 'Greene'
, 'DGREENE'
, '011.44.1346.229268'
, STR_TO_DATE('19-MAR-1999', '%d-%b-%Y')
, 'SA_REP'
, 9500
, .15
, 147
, 80
);

INSERT INTO emps VALUES
( 164
, 'Mattea'
, 'Marvins'
, 'MMARVINS'
, '011.44.1346.329268'
, STR_TO_DATE('24-JAN-2000', '%d-%b-%Y')
, 'SA_REP'
, 7200
, .10
, 147
, 80
);

INSERT INTO emps VALUES
( 165
, 'David'
, 'Lee'
, 'DLEE'
, '011.44.1346.529268'
, STR_TO_DATE('23-FEB-2000', '%d-%b-%Y')
, 'SA_REP'
, 6800
, .1
, 147
, 80
);

INSERT INTO emps VALUES
( 166
, 'Sundar'
, 'Ande'
, 'SANDE'
, '011.44.1346.629268'
, STR_TO_DATE('24-MAR-2000', '%d-%b-%Y')
, 'SA_REP'
, 6400
, .10
, 147
, 80
);

INSERT INTO emps VALUES
( 167
, 'Amit'
, 'Banda'
, 'ABANDA'
, '011.44.1346.729268'
, STR_TO_DATE('21-APR-2000', '%d-%b-%Y')
, 'SA_REP'
, 6200
, .10
, 147
, 80
);

INSERT INTO emps VALUES
( 168
, 'Lisa'
, 'Ozer'
, 'LOZER'
, '011.44.1343.929268'
, STR_TO_DATE('11-MAR-1997', '%d-%b-%Y')
, 'SA_REP'
, 11500
, .25
, 148
, 80
);

INSERT INTO emps VALUES
( 169
, 'Harrison'
, 'Bloom'
, 'HBLOOM'
, '011.44.1343.829268'
, STR_TO_DATE('23-MAR-1998', '%d-%b-%Y')
, 'SA_REP'
, 10000
, .20
, 148
, 80
);

INSERT INTO emps VALUES
( 170
, 'Tayler'
, 'Fox'
, 'TFOX'
, '011.44.1343.729268'
, STR_TO_DATE('24-JAN-1998', '%d-%b-%Y')
, 'SA_REP'
, 9600
, .20
, 148
, 80
);

INSERT INTO emps VALUES
( 171
, 'William'
, 'Smith'
, 'WSMITH'
, '011.44.1343.629268'
, STR_TO_DATE('23-FEB-1999', '%d-%b-%Y')
, 'SA_REP'
, 7400
, .15
, 148
, 80
);

INSERT INTO emps VALUES
( 172
, 'Elizabeth'
, 'Bates'
, 'EBATES'
, '011.44.1343.529268'
, STR_TO_DATE('24-MAR-1999', '%d-%b-%Y')
, 'SA_REP'
, 7300
, .15
, 148
, 80
);

INSERT INTO emps VALUES
( 173
, 'Sundita'
, 'Kumar'
, 'SKUMAR'
, '011.44.1343.329268'
, STR_TO_DATE('21-APR-2000', '%d-%b-%Y')
, 'SA_REP'
, 6100
, .10
, 148
, 80
);

INSERT INTO emps VALUES
( 174
, 'Ellen'
, 'Abel'
, 'EABEL'
, '011.44.1644.429267'
, STR_TO_DATE('11-MAY-1996', '%d-%b-%Y')
, 'SA_REP'
, 11000
, .30
, 149
, 80
);

INSERT INTO emps VALUES
( 175
, 'Alyssa'
, 'Hutton'
, 'AHUTTON'
, '011.44.1644.429266'
, STR_TO_DATE('19-MAR-1997', '%d-%b-%Y')
, 'SA_REP'
, 8800
, .25
, 149
, 80
);

INSERT INTO emps VALUES
( 176
, 'Jonathon'
, 'Taylor'
, 'JTAYLOR'
, '011.44.1644.429265'
, STR_TO_DATE('24-MAR-1998', '%d-%b-%Y')
, 'SA_REP'
, 8600
, .20
, 149
, 80
);

INSERT INTO emps VALUES
( 177
, 'Jack'
, 'Livingston'
, 'JLIVINGS'
, '011.44.1644.429264'
, STR_TO_DATE('23-APR-1998', '%d-%b-%Y')
, 'SA_REP'
, 8400
, .20
, 149
, 80
);

INSERT INTO emps VALUES
( 178
, 'Kimberely'
, 'Grant'
, 'KGRANT'
, '011.44.1644.429263'
, STR_TO_DATE('24-MAY-1999', '%d-%b-%Y')
, 'SA_REP'
, 7000
, .15
, 149
, NULL
);

INSERT INTO emps VALUES
( 179
, 'Charles'
, 'Johnson'
, 'CJOHNSON'
, '011.44.1644.429262'
, STR_TO_DATE('04-JAN-2000', '%d-%b-%Y')
, 'SA_REP'
, 6200
, .10
, 149
, 80
);

INSERT INTO emps VALUES
( 180
, 'Winston'
, 'Taylor'
, 'WTAYLOR'
, '650.507.9876'
, STR_TO_DATE('24-JAN-1998', '%d-%b-%Y')
, 'SH_CLERK'
, 3200
, NULL
, 120
, 50
);

INSERT INTO emps VALUES
( 181
, 'Jean'
, 'Fleaur'
, 'JFLEAUR'
, '650.507.9877'
, STR_TO_DATE('23-FEB-1998', '%d-%b-%Y')
, 'SH_CLERK'
, 3100
, NULL
, 120
, 50
);

INSERT INTO emps VALUES
( 182
, 'Martha'
, 'Sullivan'
, 'MSULLIVA'
, '650.507.9878'
, STR_TO_DATE('21-JUN-1999', '%d-%b-%Y')
, 'SH_CLERK'
, 2500
, NULL
, 120
, 50
);

INSERT INTO emps VALUES
( 183
, 'Girard'
, 'Geoni'
, 'GGEONI'
, '650.507.9879'
, STR_TO_DATE('03-FEB-2000', '%d-%b-%Y')
, 'SH_CLERK'
, 2800
, NULL
, 120
, 50
);

INSERT INTO emps VALUES
( 184
, 'Nandita'
, 'Sarchand'
, 'NSARCHAN'
, '650.509.1876'
, STR_TO_DATE('27-JAN-1996', '%d-%b-%Y')
, 'SH_CLERK'
, 4200
, NULL
, 121
, 50
);

INSERT INTO emps VALUES
( 185
, 'Alexis'
, 'Bull'
, 'ABULL'
, '650.509.2876'
, STR_TO_DATE('20-FEB-1997', '%d-%b-%Y')
, 'SH_CLERK'
, 4100
, NULL
, 121
, 50
);

INSERT INTO emps VALUES
( 186
, 'Julia'
, 'Dellinger'
, 'JDELLING'
, '650.509.3876'
, STR_TO_DATE('24-JUN-1998', '%d-%b-%Y')
, 'SH_CLERK'
, 3400
, NULL
, 121
, 50
);

INSERT INTO emps VALUES
( 187
, 'Anthony'
, 'Cabrio'
, 'ACABRIO'
, '650.509.4876'
, STR_TO_DATE('07-FEB-1999', '%d-%b-%Y')
, 'SH_CLERK'
, 3000
, NULL
, 121
, 50
);

INSERT INTO emps VALUES
( 188
, 'Kelly'
, 'Chung'
, 'KCHUNG'
, '650.505.1876'
, STR_TO_DATE('14-JUN-1997', '%d-%b-%Y')
, 'SH_CLERK'
, 3800
, NULL
, 122
, 50
);

INSERT INTO emps VALUES
( 189
, 'Jennifer'
, 'Dilly'
, 'JDILLY'
, '650.505.2876'
, STR_TO_DATE('13-AUG-1997', '%d-%b-%Y')
, 'SH_CLERK'
, 3600
, NULL
, 122
, 50
);

INSERT INTO emps VALUES
( 190
, 'Timothy'
, 'Gates'
, 'TGATES'
, '650.505.3876'
, STR_TO_DATE('11-JUL-1998', '%d-%b-%Y')
, 'SH_CLERK'
, 2900
, NULL
, 122
, 50
);

INSERT INTO emps VALUES
( 191
, 'Randall'
, 'Perkins'
, 'RPERKINS'
, '650.505.4876'
, STR_TO_DATE('19-DEC-1999', '%d-%b-%Y')
, 'SH_CLERK'
, 2500
, NULL
, 122
, 50
);

INSERT INTO emps VALUES
( 192
, 'Sarah'
, 'Bell'
, 'SBELL'
, '650.501.1876'
, STR_TO_DATE('04-FEB-1996', '%d-%b-%Y')
, 'SH_CLERK'
, 4000
, NULL
, 123
, 50
);

INSERT INTO emps VALUES
( 193
, 'Britney'
, 'Everett'
, 'BEVERETT'
, '650.501.2876'
, STR_TO_DATE('03-MAR-1997', '%d-%b-%Y')
, 'SH_CLERK'
, 3900
, NULL
, 123
, 50
);

INSERT INTO emps VALUES
( 194
, 'Samuel'
, 'McCain'
, 'SMCCAIN'
, '650.501.3876'
, STR_TO_DATE('01-JUL-1998', '%d-%b-%Y')
, 'SH_CLERK'
, 3200
, NULL
, 123
, 50
);

INSERT INTO emps VALUES
( 195
, 'Vance'
, 'Jones'
, 'VJONES'
, '650.501.4876'
, STR_TO_DATE('17-MAR-1999', '%d-%b-%Y')
, 'SH_CLERK'
, 2800
, NULL
, 123
, 50
);

INSERT INTO emps VALUES
( 196
, 'Alana'
, 'Walsh'
, 'AWALSH'
, '650.507.9811'
, STR_TO_DATE('24-APR-1998', '%d-%b-%Y')
, 'SH_CLERK'
, 3100
, NULL
, 124
, 50
);

INSERT INTO emps VALUES
( 197
, 'Kevin'
, 'Feeney'
, 'KFEENEY'
, '650.507.9822'
, STR_TO_DATE('23-MAY-1998', '%d-%b-%Y')
, 'SH_CLERK'
, 3000
, NULL
, 124
, 50
);

INSERT INTO emps VALUES
( 198
, 'Donald'
, 'OConnell'
, 'DOCONNEL'
, '650.507.9833'
, STR_TO_DATE('21-JUN-1999', '%d-%b-%Y')
, 'SH_CLERK'
, 2600
, NULL
, 124
, 50
);

INSERT INTO emps VALUES
( 199
, 'Douglas'
, 'Grant'
, 'DGRANT'
, '650.507.9844'
, STR_TO_DATE('13-JAN-2000', '%d-%b-%Y')
, 'SH_CLERK'
, 2600
, NULL
, 124
, 50
);

INSERT INTO emps VALUES
( 200
, 'Jennifer'
, 'Whalen'
, 'JWHALEN'
, '515.123.4444'
, STR_TO_DATE('17-SEP-1987', '%d-%b-%Y')
, 'AD_ASST'
, 4400
, NULL
, 101
, 10
);

INSERT INTO emps VALUES
( 201
, 'Michael'
, 'Hartstein'
, 'MHARTSTE'
, '515.123.5555'
, STR_TO_DATE('17-FEB-1996', '%d-%b-%Y')
, 'MK_MAN'
, 13000
, NULL
, 100
, 20
);

INSERT INTO emps VALUES
( 202
, 'Pat'
, 'Fay'
, 'PFAY'
, '603.123.6666'
, STR_TO_DATE('17-AUG-1997', '%d-%b-%Y')
, 'MK_REP'
, 6000
, NULL
, 201
, 20
);

INSERT INTO emps VALUES
( 203
, 'Susan'
, 'Mavris'
, 'SMAVRIS'
, '515.123.7777'
, STR_TO_DATE('07-JUN-1994', '%d-%b-%Y')
, 'HR_REP'
, 6500
, NULL
, 101
, 40
);

INSERT INTO emps VALUES
( 204
, 'Hermann'
, 'Baer'
, 'HBAER'
, '515.123.8888'
, STR_TO_DATE('07-JUN-1994', '%d-%b-%Y')
, 'PR_REP'
, 10000
, NULL
, 101
, 70
);

INSERT INTO emps VALUES
( 205
, 'Shelley'
, 'Higgins'
, 'SHIGGINS'
, '515.123.8080'
, STR_TO_DATE('07-JUN-1994', '%d-%b-%Y')
, 'AC_MGR'
, 12000
, NULL
, 101
, 110
);

INSERT INTO emps VALUES
( 206
, 'William'
, 'Gietz'
, 'WGIETZ'
, '515.123.8181'
, STR_TO_DATE('07-JUN-1994', '%d-%b-%Y')
, 'AC_ACCOUNT'
, 8300
, NULL
, 205
, 110
);

INSERT INTO job_history
VALUES (102
, STR_TO_DATE('13-JAN-1993', '%d-%b-%Y')
, STR_TO_DATE('24-JUL-1998', '%d-%b-%Y')
, 'IT_PROG'
, 60);

INSERT INTO job_history
VALUES (101
, STR_TO_DATE('21-SEP-1989', '%d-%b-%Y')
, STR_TO_DATE('27-OCT-1993', '%d-%b-%Y')
, 'AC_ACCOUNT'
, 110);

INSERT INTO job_history
VALUES (101
, STR_TO_DATE('28-OCT-1993', '%d-%b-%Y')
, STR_TO_DATE('15-MAR-1997', '%d-%b-%Y')
, 'AC_MGR'
, 110);

INSERT INTO job_history
VALUES (201
, STR_TO_DATE('17-FEB-1996', '%d-%b-%Y')
, STR_TO_DATE('19-DEC-1999', '%d-%b-%Y')
, 'MK_REP'
, 20);

INSERT INTO job_history
VALUES (114
, STR_TO_DATE('24-MAR-1998', '%d-%b-%Y')
, STR_TO_DATE('31-DEC-1999', '%d-%b-%Y')
, 'ST_CLERK'
, 50
);

INSERT INTO job_history
VALUES (122
, STR_TO_DATE('01-JAN-1999', '%d-%b-%Y')
, STR_TO_DATE('31-DEC-1999', '%d-%b-%Y')
, 'ST_CLERK'
, 50
);

INSERT INTO job_history
VALUES (200
, STR_TO_DATE('17-SEP-1987', '%d-%b-%Y')
, STR_TO_DATE('17-JUN-1993', '%d-%b-%Y')
, 'AD_ASST'
, 90
);

INSERT INTO job_history
VALUES (176
, STR_TO_DATE('24-MAR-1998', '%d-%b-%Y')
, STR_TO_DATE('31-DEC-1998', '%d-%b-%Y')
, 'SA_REP'
, 80
);

INSERT INTO job_history
VALUES (176
, STR_TO_DATE('01-JAN-1999', '%d-%b-%Y')
, STR_TO_DATE('31-DEC-1999', '%d-%b-%Y')
, 'SA_MAN'
, 80
);

INSERT INTO job_history
VALUES (200
, STR_TO_DATE('01-JUL-1994', '%d-%b-%Y')
, STR_TO_DATE('31-DEC-1998', '%d-%b-%Y')
, 'AC_ACCOUNT'
, 90
);

COMMIT;

©著作权归作者所有,转载或内容合作请联系作者
  • 人面猴
    序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
    沈念sama阅读 203,456评论 5赞 477
  • 死咒
    序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
    沈念sama阅读 85,370评论 2赞 381
  • 救了他两次的神仙让他今天三更去死
    文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
    开封第一讲书人阅读 150,337评论 0赞 337
  • 道士缉凶录：失踪的卖姜人
    文/不坏的土叔 我叫张陵，是天一观的道长。 经常有香客问我，道长，这世上最难降的妖魔是什么？ 我笑而不...
    开封第一讲书人阅读 54,583评论 1赞 273
  • 港岛之恋（遗憾婚礼）
    正文 为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
    茶点故事阅读 63,596评论 5赞 365
  • 恶毒庶女顶嫁案：这布局不是一般人想出来的
    文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
    开封第一讲书人阅读 48,572评论 1赞 281
  • 城市分裂传说
    那天，我揣着相机与录音，去河边找鬼。 笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。 我是一名探鬼主播，决...
    沈念sama阅读 37,936评论 3赞 395
  • 双鸳鸯连环套：你想象不到人心有多黑
    文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
    开封第一讲书人阅读 36,595评论 0赞 258
  • 万荣杀人案实录
    序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
    沈念sama阅读 40,850评论 1赞 297
  • 护林员之死
    正文 独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 35,601评论 2赞 321
  • 白月光启示录
    正文 我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 37,685评论 1赞 329
  • 活死人
    序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
    沈念sama阅读 33,371评论 4赞 318
  • 日本核电站爆炸内幕
    正文 年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
    茶点故事阅读 38,951评论 3赞 307
  • 男人毒药：我在死后第九天来索命
    文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 29,934评论 0赞 19
  • 一桩弑父案，背后竟有这般阴谋
    文/苍兰香墨 我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 31,167评论 1赞 259
  • 情欲美人皮
    我被黑心中介骗来泰国打工， 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。 一个月前我还...
    沈念sama阅读 43,636评论 2赞 349
  • 代替公主和亲
    正文 我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
    茶点故事阅读 42,411评论 2赞 342

推荐阅读更多精彩内容

  • pySpark 中文API (2)
    pyspark.sql模块 模块上下文 Spark SQL和DataFrames的重要类： pyspark.sql...
    mpro阅读 9,442评论 0赞 13
  • rljs
    rljs by sennchi Timeline of History Part One The Cognitiv...
    sennchi阅读 7,279评论 0赞 10
  • Python与Go异同之：函数式编程
    我们先来介绍几个概念： 什么是纯正的函数式编程？ 不可变性：不能有状态，只有常量和函数 函数只能有一个参数Go与P...
    __apple阅读 257评论 0赞 0
  • 七绝 掀帘
    七绝 掀帘 青丝垂柳掩弯严， 燕子双飞爱意恬。 情侣搂腰时去坐， 东风嫉妒尽掀帘
    书中樵夫阅读 855评论 19赞 56
  • 平等和自由？不存在的
    平等和自由无论任何年代都是被高频提出的两个词，今天我们撇开那些御用文人嘴里的平等自由不谈，就说说我们真切盼...
    一条漏网之鱼阅读 846评论 0赞 0