· 8 years ago · Mar 21, 2018, 09:54 PM
1DROP TABLE IF EXISTS `PROMO4`;
2/*!40101 SET @saved_cs_client = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `PROMO4` (
5 `id` int(11) NOT NULL AUTO_INCREMENT,
6 `nom` varchar(250) DEFAULT NULL,
7 `prenom` varchar(250) DEFAULT NULL,
8 `age` int(11) DEFAULT NULL,
9 `residence` text,
10 PRIMARY KEY (`id`)
11) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
12/*!40101 SET character_set_client = @saved_cs_client */;
13
14--
15-- Dumping data for table `PROMO4`
16--
17
18LOCK TABLES `PROMO4` WRITE;
19/*!40000 ALTER TABLE `PROMO4` DISABLE KEYS */;
20INSERT INTO `PROMO4` VALUES (1,'pinto','maxime',29,'lyon'),(2,'Google','Friend',19,'California'),(3,'Lorie','Pester',35,'Le Plessis-Bouchard'),(4,'Laurent','Conroux',46,'Lyon'),(5,'Romain','Coquery',37,'Lyon');
21/*!40000 ALTER TABLE `PROMO4` ENABLE KEYS */;
22UNLOCK TABLES;
23/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
24
25/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
26/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
27/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
28/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
29/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
30/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
31/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
32
33-- Dump completed on 2018-03-13 9:12:56