bonjour j'essaye executer ce script mais voici mon erreur
ERROR at line 4: Invalid default value for 'id'
voici mon script
# Table structure for table 'userinfo'
CREATE TABLE userinfo (
id int(10) DEFAULT '0' NOT NULL auto_increment,
UserName varchar(30),
Name varchar(200),
Mail varchar(200),
Department varchar(200),
WorkPhone varchar(200),
HomePhone varchar(200),
Mobile varchar(200),
PRIMARY KEY (id),
KEY UserName (UserName),
KEY Department (Department)
);
si quelqu'un a une idée merci
Partager