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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
| --------------
SET AUTOCOMMIT = 0
--------------
--------------
START TRANSACTION
--------------
--------------
DROP DATABASE IF EXISTS `base`
--------------
--------------
CREATE DATABASE `base`
DEFAULT CHARACTER SET `latin1`
DEFAULT COLLATE `latin1_general_ci`
--------------
--------------
DROP TABLE IF EXISTS `descriptif`
--------------
--------------
create table `descriptif` (
`id` int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
`salle` smallint NOT NULL,
`rangement` enum ('oui','non'),
`intervention` enum ('oui','non'),
`niveau` smallint NOT NULL,
`urgence` enum ('oui','non')
) ENGINE=InnoDB
DEFAULT CHARSET=`latin1` COLLATE=`latin1_general_ci`
ROW_FORMAT=COMPRESSED
--------------
--------------
insert into `descriptif` (`salle`,`rangement`,`intervention`,`niveau`,`urgence`) values
(24, 'non', 'oui', 2, 'oui'),
(34, 'oui', 'oui', 4, 'non'),
(57, 'oui', 'non', 0, 'oui')
--------------
--------------
select * from descriptif
--------------
+----+-------+-----------+--------------+--------+---------+
| id | salle | rangement | intervention | niveau | urgence |
+----+-------+-----------+--------------+--------+---------+
| 1 | 24 | non | oui | 2 | oui |
| 2 | 34 | oui | oui | 4 | non |
| 3 | 57 | oui | non | 0 | oui |
+----+-------+-----------+--------------+--------+---------+
--------------
COMMIT
--------------
--------------
SET AUTOCOMMIT = 1
--------------
Appuyez sur une touche pour continuer... |
Partager