+------------------+ | INFO | +------------------+ | LOADING salaries | +------------------+ 1 row in set (0.00 sec) Query OK, 25526 rows affected (1.34 sec) Records: 25526 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (2.53 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (3.06 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (3.57 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (2.69 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (2.83 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (3.77 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25525 rows affected (3.27 sec) Records: 25525 Duplicates: 0 Warnings: 0 Query OK, 25531 rows affected (3.10 sec) Records: 25531 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (3.26 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (3.26 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (3.89 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (4.16 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (3.77 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25525 rows affected (3.42 sec) Records: 25525 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (3.64 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (3.76 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (3.72 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25526 rows affected (3.56 sec) Records: 25526 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (3.47 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (3.77 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (3.59 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (3.48 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (3.42 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (3.64 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (3.38 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25526 rows affected (3.49 sec) Records: 25526 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (3.70 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (4.14 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (4.30 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (3.84 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (3.50 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (3.52 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25224 rows affected (3.21 sec) Records: 25224 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.49 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.55 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.93 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.90 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.78 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (3.66 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.65 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.55 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.38 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.51 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (4.05 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.62 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.48 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.60 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.95 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (4.07 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.90 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.80 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (3.40 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.70 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.96 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (3.53 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.57 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.62 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.64 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.68 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.70 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (4.02 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (4.21 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.43 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.23 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.19 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (3.40 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.22 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.40 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (3.44 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.63 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.47 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.20 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (3.00 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.31 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.77 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24917 rows affected (3.21 sec) Records: 24917 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.09 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.29 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (3.50 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.30 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (2.90 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.00 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.37 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.29 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.44 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.49 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.74 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.75 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.39 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.60 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.83 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24924 rows affected (3.31 sec) Records: 24924 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.50 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.59 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (3.50 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (3.38 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (3.88 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.30 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24924 rows affected (4.35 sec) Records: 24924 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (5.32 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.98 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.51 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.29 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (4.07 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (4.22 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (3.16 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (3.12 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (3.79 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24924 rows affected (3.61 sec) Records: 24924 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.56 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (3.16 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (3.51 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 7671 rows affected (1.07 sec) Records: 7671 Duplicates: 0 Warnings: 0 mysql 6.0 > show create table salaries; +----------+--------------------------------------------- --------------------------------------------------------- | Table | Create Table +----------+--------------------------------------------- --------------------------------------------------------- | salaries | CREATE TABLE `salaries` ( `emp_no` int(11) NOT NULL, `salary` int(11) NOT NULL, `from_date` date NOT NULL, `to_date` date NOT NULL, PRIMARY KEY (`emp_no`,`from_date`), KEY `emp_no` (`emp_no`) ) ENGINE=MARIA DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 | +----------+--------------------------------------------- --------------------------------------------------------- 1 row in set (0.00 sec) mysql 6.0 > ----------------------------- INNODB-------------------------------- +------------------+ | INFO | +------------------+ | LOADING salaries | +------------------+ 1 row in set (0.00 sec) Query OK, 25526 rows affected (1.01 sec) Records: 25526 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (1.69 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (1.00 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (1.33 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.53 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.04 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (1.44 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25525 rows affected (1.33 sec) Records: 25525 Duplicates: 0 Warnings: 0 Query OK, 25531 rows affected (1.50 sec) Records: 25531 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.49 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (0.91 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (2.00 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (1.36 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (0.88 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25525 rows affected (1.49 sec) Records: 25525 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (1.52 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (1.30 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (1.31 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25526 rows affected (1.43 sec) Records: 25526 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (0.92 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.23 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (1.35 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.11 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25527 rows affected (1.60 sec) Records: 25527 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.90 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (0.83 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25526 rows affected (1.61 sec) Records: 25526 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.42 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.01 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (1.47 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25529 rows affected (1.36 sec) Records: 25529 Duplicates: 0 Warnings: 0 Query OK, 25530 rows affected (0.85 sec) Records: 25530 Duplicates: 0 Warnings: 0 Query OK, 25528 rows affected (1.29 sec) Records: 25528 Duplicates: 0 Warnings: 0 Query OK, 25224 rows affected (1.41 sec) Records: 25224 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (0.72 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.44 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (0.70 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.72 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.42 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (0.73 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.67 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.06 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (0.75 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.48 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (2.17 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (0.75 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.47 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.58 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (0.67 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (1.30 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.54 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (0.89 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (1.07 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (0.92 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.39 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (1.39 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (0.94 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.76 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (1.30 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (0.82 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.71 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.31 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (1.00 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.26 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (1.39 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (0.95 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (1.22 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (0.69 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.68 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (1.28 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (0.90 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.57 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.32 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (1.46 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (1.08 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.34 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24917 rows affected (0.68 sec) Records: 24917 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.34 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.46 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (0.83 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (2.07 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.09 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (0.99 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.23 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.07 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (0.88 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (1.67 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (2.10 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (0.74 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.30 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.08 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (0.89 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24924 rows affected (1.39 sec) Records: 24924 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.01 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (1.50 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (1.37 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (0.67 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (1.31 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.16 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24924 rows affected (0.74 sec) Records: 24924 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.62 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.22 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (0.77 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (0.98 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (1.24 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24921 rows affected (0.94 sec) Records: 24921 Duplicates: 0 Warnings: 0 Query OK, 24922 rows affected (1.15 sec) Records: 24922 Duplicates: 0 Warnings: 0 Query OK, 24918 rows affected (1.60 sec) Records: 24918 Duplicates: 0 Warnings: 0 Query OK, 24923 rows affected (1.03 sec) Records: 24923 Duplicates: 0 Warnings: 0 Query OK, 24924 rows affected (1.17 sec) Records: 24924 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (1.26 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24920 rows affected (0.81 sec) Records: 24920 Duplicates: 0 Warnings: 0 Query OK, 24919 rows affected (1.13 sec) Records: 24919 Duplicates: 0 Warnings: 0 Query OK, 7671 rows affected (0.25 sec) Records: 7671 Duplicates: 0 Warnings: 0 mysql 6.0 > show create table salaries; +----------+--------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------+ | Table | Create Table | +----------+--------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------+ | salaries | CREATE TABLE `salaries` ( `emp_no` int(11) NOT NULL, `salary` int(11) NOT NULL, `from_date` date NOT NULL, `to_date` date NOT NULL, PRIMARY KEY (`emp_no`,`from_date`), KEY `emp_no` (`emp_no`), CONSTRAINT `salaries_ibfk_1` FOREIGN KEY (`emp_no`) REFERENCES `employees` (`emp_no`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 | +----------+--------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql 6.0 >