{MySQL} Erreur requete .sql
Résolu
inventel
Messages postés
94
Statut
Membre
-
giheller Messages postés 1952 Statut Membre -
giheller Messages postés 1952 Statut Membre -
Bonjour a tous ! alors voila mon problème j'ai un fichier .sql que j'importe mais j'ai l'erreur MySQL a répondu:Documentation
#1067 - Invalid default value for 'id
Donc voila le contenu du fichier si vous pouvez m'aidez a le corrigez
CREATE TABLE dynanews (
id INT (10) DEFAULT '0' not null AUTO_INCREMENT,
titre VARCHAR (255) not null ,
date DATETIME not null ,
message TEXT not null ,
auteur VARCHAR (255) not null ,
mail VARCHAR (255) ,
source VARCHAR (255) ,
url_source VARCHAR (255) ,
image VARCHAR (255) ,
url_image VARCHAR (255) ,
PRIMARY KEY (id)
);
CREATE TABLE dn_coment (
id INT (10) DEFAULT '0' not null AUTO_INCREMENT,
id_news INT (10) not null ,
date DATETIME not null ,
auteur VARCHAR (255) not null ,
mail VARCHAR (255) ,
sujet VARCHAR(255),
message TEXT not null ,
PRIMARY KEY (id)
);
CREATE TABLE dn_user (
mail varchar(255) NOT NULL ,
pseudo VARCHAR (50) not null ,
login VARCHAR (10) not null ,
mdp VARCHAR (10) not null ,
aut VARCHAR (13) not null ,
UNIQUE (login)
);
CREATE TABLE dn_smiley (
code VARCHAR (255) not null ,
image_url VARCHAR (255) not null ,
date DATETIME not null ,
UNIQUE (code)
);
INSERT INTO dn_smiley VALUES('{:)}','smilies/smile.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:D}','smilies/smile_big.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{8D}','smilies/smile_cool.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:(}','smilies/smile_sad.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:(!}','smilies/smile_angry.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:O}','smilies/smile_shock.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{^}','smilies/smile_approve.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{V}','smilies/smile_dissapprove.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:P}','smilies/smile_tongue.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{;)}','smilies/smile_wink.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{}:)}','smilies/smile_evil.gif','2001-05-08 00:00:00');
#1067 - Invalid default value for 'id
Donc voila le contenu du fichier si vous pouvez m'aidez a le corrigez
CREATE TABLE dynanews (
id INT (10) DEFAULT '0' not null AUTO_INCREMENT,
titre VARCHAR (255) not null ,
date DATETIME not null ,
message TEXT not null ,
auteur VARCHAR (255) not null ,
mail VARCHAR (255) ,
source VARCHAR (255) ,
url_source VARCHAR (255) ,
image VARCHAR (255) ,
url_image VARCHAR (255) ,
PRIMARY KEY (id)
);
CREATE TABLE dn_coment (
id INT (10) DEFAULT '0' not null AUTO_INCREMENT,
id_news INT (10) not null ,
date DATETIME not null ,
auteur VARCHAR (255) not null ,
mail VARCHAR (255) ,
sujet VARCHAR(255),
message TEXT not null ,
PRIMARY KEY (id)
);
CREATE TABLE dn_user (
mail varchar(255) NOT NULL ,
pseudo VARCHAR (50) not null ,
login VARCHAR (10) not null ,
mdp VARCHAR (10) not null ,
aut VARCHAR (13) not null ,
UNIQUE (login)
);
CREATE TABLE dn_smiley (
code VARCHAR (255) not null ,
image_url VARCHAR (255) not null ,
date DATETIME not null ,
UNIQUE (code)
);
INSERT INTO dn_smiley VALUES('{:)}','smilies/smile.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:D}','smilies/smile_big.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{8D}','smilies/smile_cool.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:(}','smilies/smile_sad.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:(!}','smilies/smile_angry.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:O}','smilies/smile_shock.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{^}','smilies/smile_approve.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{V}','smilies/smile_dissapprove.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{:P}','smilies/smile_tongue.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{;)}','smilies/smile_wink.gif','2001-05-08 00:00:00');
INSERT INTO dn_smiley VALUES('{}:)}','smilies/smile_evil.gif','2001-05-08 00:00:00');
A voir également:
- {MySQL} Erreur requete .sql
- Mysql community server - Télécharger - Bases de données
- Erreur 0x80070643 - Accueil - Windows
- Erreur 4201 france tv ✓ - Forum Réseaux sociaux
- Erreur lors de l'envoi de la requête facebook - Forum Facebook
- Erreur 4101 france tv - Forum Lecteurs et supports vidéo
4 réponses
ceci fonctionne
CREATE TABLE dynanews (
id INT (10) AUTO_INCREMENT,
titre VARCHAR (255) not null ,
date DATETIME not null ,
message TEXT not null ,
auteur VARCHAR (255) not null ,
mail VARCHAR (255) ,
source VARCHAR (255) ,
url_source VARCHAR (255) ,
image VARCHAR (255) ,
url_image VARCHAR (255) ,
PRIMARY KEY (id)
);
CREATE TABLE dynanews (
id INT (10) AUTO_INCREMENT,
titre VARCHAR (255) not null ,
date DATETIME not null ,
message TEXT not null ,
auteur VARCHAR (255) not null ,
mail VARCHAR (255) ,
source VARCHAR (255) ,
url_source VARCHAR (255) ,
image VARCHAR (255) ,
url_image VARCHAR (255) ,
PRIMARY KEY (id)
);
