1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114
| --------------
SET AUTOCOMMIT = 0
--------------
--------------
START TRANSACTION
--------------
--------------
DROP DATABASE IF EXISTS `base`
--------------
--------------
CREATE DATABASE `base`
DEFAULT CHARACTER SET `latin1`
DEFAULT COLLATE `latin1_general_ci`
--------------
--------------
DROP TABLE IF EXISTS `words`
--------------
--------------
CREATE TABLE `words`
(
`id` integer unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
`word` char(10) NOT NULL,
INDEX `idx` (`word`)
) ENGINE=InnoDB
DEFAULT CHARSET=`latin1` COLLATE=`latin1_general_ci`
ROW_FORMAT=COMPRESSED
--------------
--------------
INSERT INTO `words` (`word`) VALUES
('un'),('deux'),('trois'),('un'),('quatre'),('trois'),('un')
--------------
--------------
select * from words order by id
--------------
+----+--------+
| id | word |
+----+--------+
| 1 | un |
| 2 | deux |
| 3 | trois |
| 4 | un |
| 5 | quatre |
| 6 | trois |
| 7 | un |
+----+--------+
--------------
DROP TABLE IF EXISTS `words_file`
--------------
--------------
CREATE TABLE `words_file`
(
`id` integer unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
`word_id` integer unsigned NOT NULL,
`file_id` integer unsigned NOT NULL,
CONSTRAINT `FOREIGN` FOREIGN KEY (`word_id`) REFERENCES `words` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB
DEFAULT CHARSET=`latin1` COLLATE=`latin1_general_ci`
ROW_FORMAT=COMPRESSED
--------------
--------------
INSERT INTO `words_file` (`word_id`,`file_id`) VALUES
(1, 1),(1, 4),
(2, 3),(2, 7),(2, 9),
(3, 2),(3, 5),
(4, 1),(4, 7),
(5, 6),(5, 8),(5, 9),
(6, 3),(6, 5),
(7, 1),(7, 4)
--------------
--------------
select * from words_file order by id
--------------
+----+---------+---------+
| id | word_id | file_id |
+----+---------+---------+
| 1 | 1 | 1 |
| 2 | 1 | 4 |
| 3 | 2 | 3 |
| 4 | 2 | 7 |
| 5 | 2 | 9 |
| 6 | 3 | 2 |
| 7 | 3 | 5 |
| 8 | 4 | 1 |
| 9 | 4 | 7 |
| 10 | 5 | 6 |
| 11 | 5 | 8 |
| 12 | 5 | 9 |
| 13 | 6 | 3 |
| 14 | 6 | 5 |
| 15 | 7 | 1 |
| 16 | 7 | 4 |
+----+---------+---------+
--------------
COMMIT
--------------
--------------
SET AUTOCOMMIT = 1
--------------
Appuyez sur une touche pour continuer... |
Partager