mz8TLxbE

1CREATE DATABASE /*!32312 IF NOT EXISTS*/ `audrey_me_wcs_bruxelles` /*!40100 DEFAULT CHARACTER SET utf8 */;
2
3USE `audrey_me_wcs_bruxelles`;
4
5--
6-- Table structure for table `students`
7--
8
9DROP TABLE IF EXISTS `students`;
10/*!40101 SET @saved_cs_client     = @@character_set_client */;
11/*!40101 SET character_set_client = utf8 */;
12CREATE TABLE `students` (
13  `id` int(11) NOT NULL AUTO_INCREMENT,
14  `name` varchar(10) DEFAULT NULL,
15  `first_name` varchar(10) DEFAULT NULL,
16  `address` varchar(30) DEFAULT NULL,
17  `birth_place` varchar(30) DEFAULT NULL,
18  PRIMARY KEY (`id`)
19) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
20/*!40101 SET character_set_client = @saved_cs_client */;
21
22--
23-- Dumping data for table `students`
24--
25
26LOCK TABLES `students` WRITE;
27/*!40000 ALTER TABLE `students` DISABLE KEYS */;
28INSERT INTO `students` VALUES (1,'google','earth','home','hopital'),(2,'lolita','lorie','rue chant','paris'),(3,'mertens','audrey','rue soleil','etterbeek'),(4,'dupont','jean','strass','lion'),(5,'jeen','jeanne','rue du parc','bretagne');
29/*!40000 ALTER TABLE `students` ENABLE KEYS */;
30UNLOCK TABLES;