Bonjour,
j'ai créé une table (MySQL) dont la première colonne est un ID en auto-increment :
Code sql : Sélectionner tout - Visualiser dans une fenêtre à part
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 DROP TABLE IF EXISTS `license`; CREATE TABLE IF NOT EXISTS `license` ( `id` smallint(11) NOT NULL AUTO_INCREMENT, `id_SESA` int(6) DEFAULT NULL, `alternate_id` varchar(10) COLLATE utf8_bin DEFAULT NULL, `platform` varchar(20) COLLATE utf8_bin DEFAULT NULL, `platform_owner` int(6) DEFAULT NULL, `publisher` varchar(20) COLLATE utf8_bin DEFAULT NULL, `application_name` varchar(20) COLLATE utf8_bin DEFAULT NULL, `HFMCODE` varchar(10) COLLATE utf8_bin DEFAULT NULL, `Currently_active` varchar(5) COLLATE utf8_bin DEFAULT NULL, `Activate_date` date DEFAULT NULL, `Deactivate_date` varchar(2) COLLATE utf8_bin DEFAULT NULL, `Group_name` varchar(2) COLLATE utf8_bin DEFAULT NULL, `Office_Country` varchar(20) COLLATE utf8_bin DEFAULT NULL, `Firstname` varchar(20) COLLATE utf8_bin DEFAULT NULL, `Lastname` varchar(20) COLLATE utf8_bin DEFAULT NULL, `Company_name` varchar(30) COLLATE utf8_bin DEFAULT NULL, `Job_code` varchar(5) COLLATE utf8_bin DEFAULT NULL, `Reporting_entity` varchar(5) COLLATE utf8_bin DEFAULT NULL, `Business_unit_name` varchar(20) COLLATE utf8_bin DEFAULT NULL, `Location` varchar(20) COLLATE utf8_bin DEFAULT NULL, `Internet_Address` varchar(50) COLLATE utf8_bin DEFAULT NULL, `Manager_firstname` varchar(20) COLLATE utf8_bin DEFAULT NULL, `Manager_lastname` varchar(20) COLLATE utf8_bin DEFAULT NULL, `Manager_email` varchar(50) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Pour y insérer un nouvel enregistrement, je fais une requête de ce genre : INSERT INTO `license` VALUES('','100008','(none)','Software Engineering','69723','CollabNet','TeamForge_Full','','TRUE','2018-07-26','','','France','Bilhel','Ben Abdellah','Schneider Electric France','','','','','','','','')J'ai ce message d'erreur :Comment faudrait-il faire ? Merci.#1366 - Incorrect integer value: '' for column 'id' at row 1
Partager