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
| --
-- Table structure for table `test_innodb`
--
DROP TABLE IF EXISTS `test_innodb`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `test_innodb` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nom` varchar(30) NOT NULL,
`prenom` varchar(30) NOT NULL,
PRIMARY KEY (`id`),
KEY `nom` (`nom`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `test_innodb`
--
LOCK TABLES `test_innodb` WRITE;
/*!40000 ALTER TABLE `test_innodb` DISABLE KEYS */;
INSERT INTO `test_innodb` VALUES (1,'Leménager','Philippe'),(2,'Einstein','Albb
ert'),(3,'Hitchcock','Alfred'),(4,'Spielberg','Steven');
/*!40000 ALTER TABLE `test_innodb` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
Partager