Re: Help sur les requetes SQL

Et voilà. bon c'est du basic, mais ça suffit

la table d'origine ...
CREATE TABLE `liste_bds` (
`ID` int(10) NOT NULL auto_increment,
`heros` varchar(100) NOT NULL default '',
`titre` varchar(100) NOT NULL default '',
`numero` int(10) NOT NULL default '0',
`auteur1` varchar(50) NOT NULL default '',
`auteur2` varchar(50) NOT NULL default '',
`editeur` varchar(50) NOT NULL default '',
`format` varchar(50) NOT NULL default '',
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ID`),
KEY `ID` (`ID`)
) TYPE=MyISAM;
--------------------------
--------------------------
et les tables destinations
les tables faciles à remplir
CREATE TABLE `bd_editor` (
`ID` int(11) NOT NULL auto_increment,
`e_name` varchar(100) NOT NULL default '',
`e_info` blob NOT NULL,
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
-------------------
CREATE TABLE `bd_heros` (
`ID` int(11) NOT NULL auto_increment,
`h_name` varchar(100) NOT NULL default '',
`h_info` blob NOT NULL,
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
------------------
CREATE TABLE `bd_type` (
`ID` int(11) NOT NULL auto_increment,
`t_format` varchar(100) NOT NULL default '',
`t_info` blob NOT NULL,
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
-----------------
CREATE TABLE `bd_writer` (
`ID` int(11) NOT NULL auto_increment,
`w_name` varchar(100) NOT NULL default '',
`w_surname` varchar(100) NOT NULL default '',
`w_info` blob NOT NULL,
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;

--------------------
la table chiante à remplir
CREATE TABLE `bd_bd` (
`ID` int(11) NOT NULL auto_increment,
`bd_heros` int(11) NOT NULL default '0',
`bd_title` varchar(100) NOT NULL default '',
`bd_info` blob NOT NULL,
`bd_purdate` date NOT NULL default '0000-00-00',
`bd_writer1` int(11) NOT NULL default '0',
`bd_writer2` int(11) NOT NULL default '0',
`bd_type` int(11) NOT NULL default '0',
`bd_editor` int(11) NOT NULL default '0',
`bd_ref` varchar(12) NOT NULL default '',
`bd_ISBN` varchar(20) NOT NULL default '',
`bd_cost` tinyint(4) NOT NULL default '0',
`timestamp` timestamp(14) NOT NULL,
PRIMARY KEY (`ID`)
) TYPE=MyISAM;