· 6 years ago · Jan 21, 2020, 12:08 PM
1CREATE TABLE IF NOT EXISTS `spieentree` (
2 `Date` varchar(20) NOT NULL,
3 `Incident` varchar(10) NOT NULL,
4 `Horaire` varchar(10) NOT NULL,
5 `Materiel` varchar(1000) NOT NULL,
6 `Matricule` varchar(11) NOT NULL,
7 `Etat` varchar(30) NOT NULL,
8 `Trigramme` varchar(10) NOT NULL,
9 `Commentaire` varchar(1000) NOT NULL,
10 `Repentree` int(11) NOT NULL auto_increment,
11 `Statut` varchar(20) NOT NULL,
12 PRIMARY KEY (`Repentree`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=0 ;
14
15
16
17INSERT IGNORE INTO `spieentree` (`Date`, `Incident`, `Materiel`, `Etat`, `Trigramme`, `Commentaire`, `Repentree`, `Statut`) VALUES
18('29/03/2018 13:50', '537368', ' DELL 360 - 2009/000948 ', 'Spare', 'ADA', '', 20780, 'Traité;'),