Cqt0QefD

1CREATE DATABASE `wcs_toulouse`;
2
3USE `wcs_toulouse`;
4
5DROP TABLE IF EXISTS `promo_java`;
6CREATE TABLE `promo_java` (
7  `Id` int(11) NOT NULL AUTO_INCREMENT,
8  `Name` varchar(30) DEFAULT NULL,
9  `LastName` varchar(30) DEFAULT NULL,
10  `Address` varchar(50) DEFAULT NULL,
11  PRIMARY KEY (`Id`)
12);
13
14LOCK TABLES `promo_java` WRITE;
15INSERT INTO `promo_java` VALUES (1,'Lorie','Ta meilleure amie','8 rue de la rose'),(2,'ManuCHao','Me gustas tu','rue du paradis'),(3,'Orange','le fun','rue de la colombette'),(4,'Plus que 2','chiant','rue on y est presque'),(5,'Jean-Noël','Jean ai marre','Rue de la soulerie'),(6,'Last','Enfin','fini');
16UNLOCK TABLES;