| laredotornado@zipmail.com 2005-11-02, 6:56 pm |
| Hi, I was wondering how, using MySQL and PHP 4 (if necessary), could I
import a single CSV file to populate two MySQL tables. The tables are
CREATE TABLE MANUFACTURERS (
`MANUFACTURER_ID` int(10) unsigned NOT NULL auto_increment,
`NAME` varchar(64) NOT NULL default '',
PRIMARY KEY (`MANUFACTURER_ID`)
) TYPE=InnoDB AUTO_INCREMENT=3 ;
CREATE TABLE `PRINTERS` (
`PRINTER_ID` int(11) NOT NULL auto_increment,
`MANUFACTURER_ID` int(10) unsigned NOT NULL default '0',
`NAME` varchar(64) NOT NULL default '',
PRIMARY KEY (`PRINTER_ID`),
KEY `PRINTERS_IDX1` (`MANUFACTURER_ID`)
) TYPE = INNODB AUTO_INCREMENT=35;
ALTER TABLE `PRINTERS`
ADD CONSTRAINT `FK_PRINTERS` FOREIGN KEY (`MANUFACTURER_ID`)
REFERENCES `MANUFACTURERS` (`MANUFACTURER_ID`) ON DELETE CASCADE;
The CSV file has 2 columns
Manufacturer_Name,Printer_Name
I've seen a mysql import command when there's just one table and I'm
hoping there is a slight variation for two.
Thanks, - Dave
|