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 64 65 66 67
| --------------
SET AUTOCOMMIT = 0
--------------
--------------
START TRANSACTION
--------------
--------------
DROP DATABASE IF EXISTS `base`
--------------
--------------
CREATE DATABASE IF NOT EXISTS `base`
DEFAULT CHARACTER SET `latin1`
DEFAULT COLLATE `latin1_general_ci`
--------------
--------------
COMMIT
--------------
--------------
DROP TABLE IF EXISTS `test`
--------------
--------------
CREATE TABLE `test` (
`id` integer unsigned NOT NULL auto_increment Primary Key,
`nom` varchar(255) NOT NULL,
`prenom` varchar(255) NOT NULL,
`ville` varchar(255) NOT NULL,
`pays` varchar(255) NOT NULL,
`date` date NOT NULL,
`acces` date NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=`latin1` COLLATE=`latin1_general_ci`
ROW_FORMAT=COMPRESSED
--------------
--------------
INSERT IGNORE INTO `test` (`nom`,`prenom`,`ville`,`pays`,`date`,`acces`) value
('nom 1', 'prenom 1', 'paris', 'france', '2015-07-01', '2016-02-29'),
('nom 2', 'prenom 2', 'casablanca', 'maroc', '2014-03-07', '2016-03-05'),
('nom 3', 'prenom 3', 'marrakech', 'maroc', '2013-11-25', '2016-04-08')
--------------
--------------
select * from test
--------------
+----+-------+----------+------------+--------+------------+------------+
| id | nom | prenom | ville | pays | date | acces |
+----+-------+----------+------------+--------+------------+------------+
| 1 | nom 1 | prenom 1 | paris | france | 2015-07-01 | 2016-02-29 |
| 2 | nom 2 | prenom 2 | casablanca | maroc | 2014-03-07 | 2016-03-05 |
| 3 | nom 3 | prenom 3 | marrakech | maroc | 2013-11-25 | 2016-04-08 |
+----+-------+----------+------------+--------+------------+------------+
--------------
COMMIT
--------------
--------------
SET AUTOCOMMIT = 0
--------------
Appuyez sur une touche pour continuer... |
Partager