15:47:00','Anya',NULL),
(16,'chien','F','2009-05-26
08:50:00','Louya',NULL),(17,'chien','F','2008-03-10
13:45:00','Welva',NULL),(18,'chien','F','2007-04-24
12:59:00','Zira',NULL),
(19,'chien','F','2009-05-26
09:02:00','Java',NULL),(20,'chien','M','2007-04-24
12:45:00','Balou',NULL),(21,'chien','F','2008-03-10
13:43:00','Pataude',NULL),
(22,'chien','M','2007-04-24
12:42:00','Bouli',NULL),(24,'chien','M','2007-04-12
05:23:00','Cartouche',NULL),(25,'chien','M','2006-05-14
15:50:00','Zambo',NULL),
(26,'chien','M','2006-05-14
15:48:00','Samba',NULL),(27,'chien','M','2008-03-10
13:40:00','Moka',NULL),(28,'chien','M','2006-05-14
15:40:00','Pilou',NULL),
(29,'chat','M','2009-05-14
06:30:00','Fiero',NULL),(30,'chat','M','2007-03-12
12:05:00','Zonko',NULL),(31,'chat','M','2008-02-20
15:45:00','Filou',NULL),
(32,'chat','M','2007-03-12
12:07:00','Farceur',NULL),(33,'chat','M','2006-05-19
16:17:00','Caribou',NULL),(34,'chat','M','2008-04-20
03:22:00','Capou',NULL),
(35,'chat','M','2006-05-19 16:56:00','Raccou','Pas de queue depuis
la naissance'),(36,'chat','M','2009-05-14
06:42:00','Boucan',NULL),(37,'chat','F','2006-05-19
16:06:00','Callune',NULL),
(38,'chat','F','2009-05-14
06:45:00','Boule',NULL),(39,'chat','F','2008-04-20
03:26:00','Zara',NULL),(40,'chat','F','2007-03-12
12:00:00','Milla',NULL),
(41,'chat','F','2006-05-19
15:59:00','Feta',NULL),(42,'chat','F','2008-04-20
03:20:00','Bilba','Sourde de l''oreille droite à
80%'),(43,'chat','F','2007-03-12 11:54:00','Cracotte',NULL),
(44,'chat','F','2006-05-19
16:16:00','Cawette',NULL),(45,'tortue','F','2007-04-01
18:17:00','Nikki',NULL),(46,'tortue','F','2009-03-24
08:23:00','Tortilla',NULL),
(47,'tortue','F','2009-03-26
01:24:00','Scroupy',NULL),(48,'tortue','F','2006-03-15
14:56:00','Lulla',NULL),(49,'tortue','F','2008-03-15
12:02:00','Dana',NULL),
(50,'tortue','F','2009-05-25
19:57:00','Cheli',NULL),(51,'tortue','F','2007-04-01
03:54:00','Chicaca',NULL),(52,'tortue','F','2006-03-15
14:26:00','Redbul','Insomniaque'),
(53,'tortue','M','2007-04-02
01:45:00','Spoutnik',NULL),(54,'tortue','M','2008-03-16
08:20:00','Bubulle',NULL),(55,'tortue','M','2008-03-15
18:45:00','Relou','Surpoids'),
(56,'tortue','M','2009-05-25
18:54:00','Bulbizard',NULL),(57,'perroquet','M','2007-03-04
19:36:00','Safran',NULL),(58,'perroquet','M','2008-02-20
02:50:00','Gingko',NULL),
(59,'perroquet','M','2009-03-26
08:28:00','Bavard',NULL),(60,'perroquet','F','2009-03-26
07:55:00','Parlotte',NULL);
UNLOCK TABLES;
Qu'est-ce qu'un index ?
Revoyons la définition d'un index.
Citation : Définition
Structure de données qui reprend la liste ordonnée des valeurs auxquelles il se rapporte.
Partie 2 : Index, jointures et sous-requêtes
70/414
www.openclassrooms.com
(16,'chien','F','2009-05-26
08:50:00','Louya',NULL),(17,'chien','F','2008-03-10
13:45:00','Welva',NULL),(18,'chien','F','2007-04-24
12:59:00','Zira',NULL),
(19,'chien','F','2009-05-26
09:02:00','Java',NULL),(20,'chien','M','2007-04-24
12:45:00','Balou',NULL),(21,'chien','F','2008-03-10
13:43:00','Pataude',NULL),
(22,'chien','M','2007-04-24
12:42:00','Bouli',NULL),(24,'chien','M','2007-04-12
05:23:00','Cartouche',NULL),(25,'chien','M','2006-05-14
15:50:00','Zambo',NULL),
(26,'chien','M','2006-05-14
15:48:00','Samba',NULL),(27,'chien','M','2008-03-10
13:40:00','Moka',NULL),(28,'chien','M','2006-05-14
15:40:00','Pilou',NULL),
(29,'chat','M','2009-05-14
06:30:00','Fiero',NULL),(30,'chat','M','2007-03-12
12:05:00','Zonko',NULL),(31,'chat','M','2008-02-20
15:45:00','Filou',NULL),
(32,'chat','M','2007-03-12
12:07:00','Farceur',NULL),(33,'chat','M','2006-05-19
16:17:00','Caribou',NULL),(34,'chat','M','2008-04-20
03:22:00','Capou',NULL),
(35,'chat','M','2006-05-19 16:56:00','Raccou','Pas de queue depuis
la naissance'),(36,'chat','M','2009-05-14
06:42:00','Boucan',NULL),(37,'chat','F','2006-05-19
16:06:00','Callune',NULL),
(38,'chat','F','2009-05-14
06:45:00','Boule',NULL),(39,'chat','F','2008-04-20
03:26:00','Zara',NULL),(40,'chat','F','2007-03-12
12:00:00','Milla',NULL),
(41,'chat','F','2006-05-19
15:59:00','Feta',NULL),(42,'chat','F','2008-04-20
03:20:00','Bilba','Sourde de l''oreille droite à
80%'),(43,'chat','F','2007-03-12 11:54:00','Cracotte',NULL),
(44,'chat','F','2006-05-19
16:16:00','Cawette',NULL),(45,'tortue','F','2007-04-01
18:17:00','Nikki',NULL),(46,'tortue','F','2009-03-24
08:23:00','Tortilla',NULL),
(47,'tortue','F','2009-03-26
01:24:00','Scroupy',NULL),(48,'tortue','F','2006-03-15
14:56:00','Lulla',NULL),(49,'tortue','F','2008-03-15
12:02:00','Dana',NULL),
(50,'tortue','F','2009-05-25
19:57:00','Cheli',NULL),(51,'tortue','F','2007-04-01
03:54:00','Chicaca',NULL),(52,'tortue','F','2006-03-15
14:26:00','Redbul','Insomniaque'),
(53,'tortue','M','2007-04-02
01:45:00','Spoutnik',NULL),(54,'tortue','M','2008-03-16
08:20:00','Bubulle',NULL),(55,'tortue','M','2008-03-15
18:45:00','Relou','Surpoids'),
(56,'tortue','M','2009-05-25
18:54:00','Bulbizard',NULL),(57,'perroquet','M','2007-03-04
19:36:00','Safran',NULL),(58,'perroquet','M','2008-02-20
02:50:00','Gingko',NULL),
(59,'perroquet','M','2009-03-26
08:28:00','Bavard',NULL),(60,'perroquet','F','2009-03-26
07:55:00','Parlotte',NULL);
UNLOCK TABLES;
Qu'est-ce qu'un index ?
Revoyons la définition d'un index.
Citation : Définition
Structure de données qui reprend la liste ordonnée des valeurs auxquelles il se rapporte.
Partie 2 : Index, jointures et sous-requêtes
70/414
www.openclassrooms.com