$req_insertion_texte_commentaire_article = "INSERT INTO commentaires(user_pseudo, date_depot, texte_commentaire, id_article) VALUE ('$user_pseudo', now(), '$texte_commentaire_article', '$id_article')";
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question$texte_commentaire_article=mysql_real_escape_string($_POST["texte_commentaire_article"]); $id_article=$_POST["id_article"]; echo $id_article; // Enregistrement du pseudo de l'utilisateur (variable de session) pour pouvoir l'utiliser dans la requête INSERT INTO $user_pseudo = $_SESSION["user_pseudo"]; // Insertion du commentaire dans la base de données $req_insertion_texte_commentaire_article = "INSERT INTO commentaires(user_pseudo, date_depot, texte_commentaire, id_article) VALUE ('$user_pseudo', now(), '$texte_commentaire_article', '$id_article')"; $query_insertion_texte_commentaire_article = mysql_query($req_insertion_texte_commentaire_article) or die ('Erreur sur la requête SQL concernant l\'insertion des commentaires sur des articles'.mysql_error()); // Envoie une requête à un serveur MySQL echo "Votre commentaire est posté. "; }
3Erreur sur la Requête SQL concernant l'insertion des Commentaires sur des articlesCannot ajouter ou mettre à jour une ligne enfant: une contrainte de clé étrangère échoue (sgbdd `` `` Commentaires, CONSTRAINT `commentaires_ibfk_100` FOREIGN KEY (`articles id_commentaire`) REFERENCES ``. (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE)
CREATE TABLE IF NOT EXISTS `commentaires` ( `id_commentaire` int(11) NOT NULL AUTO_INCREMENT, `user_pseudo` varchar(255) NOT NULL, `nom_village` varchar(255) NOT NULL, `nom_categorie` varchar(255) NOT NULL, `date_depot` datetime NOT NULL, `texte_commentaire` text NOT NULL, `id_article` int(11) NOT NULL, PRIMARY KEY (`id_commentaire`), KEY `FOREIGN KEY` (`id_article`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Contraintes pour les tables exportées -- -- -- Contraintes pour la table `commentaires` -- ALTER TABLE `commentaires` ADD CONSTRAINT `commentaires_ibfk_1` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_10` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_100` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_101` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_102` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_103` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_104` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_105` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_106` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_107` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_108` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_109` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_11` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_110` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_111` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_112` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_113` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_114` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_115` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_116` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_117` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_118` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_119` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_12` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_120` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_121` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_122` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_123` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_124` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_125` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_126` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_127` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_128` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_129` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_13` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_130` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_131` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_132` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_133` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_134` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_135` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_136` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_137` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_138` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_139` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_14` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_140` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_141` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_142` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_143` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_144` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_145` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_146` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_147` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_148` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_149` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_15` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_150` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_151` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_152` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_16` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_17` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_18` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_19` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_2` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_20` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_21` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_22` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_23` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_24` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_25` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_26` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_27` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_28` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_29` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_3` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_30` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_31` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_32` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_33` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_34` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_35` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_36` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_37` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_38` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_39` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_4` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_40` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_41` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_42` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_43` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_44` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_45` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_46` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_47` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_48` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_49` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_5` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_50` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_51` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_52` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_53` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_54` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_55` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_56` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE, ADD CONSTRAINT `commentaires_ibfk_57` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_58` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_59` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_6` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_60` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_61` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_62` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_63` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_64` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_65` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_66` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_67` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_68` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_69` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_7` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_70` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_71` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_72` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_73` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_74` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_75` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_76` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_77` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_78` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_79` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_8` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_80` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_81` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_82` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_83` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_84` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_85` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_86` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_87` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_88` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_89` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_9` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`), ADD CONSTRAINT `commentaires_ibfk_90` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_91` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_92` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_93` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_94` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_95` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_96` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_97` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_98` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `commentaires_ibfk_99` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE;
desc commentaires;
ALTER TABLE commentaires ADD FOREIGN KEY (id_article) REFERENCES articles(id_article)
Erreur sur la requête SQL concernant la suppression des articles et des commentaires correspondantsCannot delete or update a parent row: a foreign key constraint fails (`vincentsgbdd`.`commentaires`, CONSTRAINT `commentaires_ibfk_1` FOREIGN KEY (`id_article`) REFERENCES `articles` (`id_article`))
ALTER TABLE commentaires DROP INDEX FOREIGN KEY
ALTER TABLE `commentaires` ADD FOREIGN KEY (`id_commentaire`) REFERENCES `articles`(`id_article`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `articles` ( `id_article` int(11) NOT NULL AUTO_INCREMENT, `nom_village` varchar(255) CHARACTER SET latin1 NOT NULL, `nom_categorie` varchar(255) CHARACTER SET latin1 NOT NULL, `date_depot` datetime NOT NULL, `titre_article` varchar(255) NOT NULL, `texte_article` text NOT NULL, `auteur_article` varchar(255) NOT NULL, PRIMARY KEY (`id_article`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
CREATE TABLE IF NOT EXISTS `commentaires` ( `id_commentaire` int(11) NOT NULL AUTO_INCREMENT, `user_pseudo` varchar(255) NOT NULL, `nom_village` varchar(255) NOT NULL, `nom_categorie` varchar(255) NOT NULL, `date_depot` datetime NOT NULL, `texte_commentaire` text NOT NULL, `id_article` int(11) NOT NULL, PRIMARY KEY (`id_commentaire`), KEY `FOREIGN KEY` (`id_article`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Contraintes pour les tables exportées -- -- -- Contraintes pour la table `commentaires` -- ALTER TABLE `commentaires` ADD CONSTRAINT `commentaires_ibfk_1` FOREIGN KEY (`id_commentaire`) REFERENCES `articles` (`id_article`) ON DELETE CASCADE;