Wstawianie rekordów do dwóch tabel Opcje

[grzegorz-gg]

Mam dwie tabele manufacturers i manufacturers_info jedna zawiera nazwy producentów druga zawiera inforacje o producentach takie jak np. adres strony www.
Jak wstawic do tabeli manufacturers nazwe producenta tak aby w tabeli manufacturers_info autoatycznie wstawil sie rekord z taka sama wartoscia manufacturers_id co w tabeli manufacturers ?

Ponizej zamieszczam kod tych dwoch tabel.

[SQL] pobierz, plaintext 
CREATE TABLE `manufacturers` (
  `manufacturers_id` int(11) NOT NULL AUTO_INCREMENT,
  `manufacturers_name` varchar(32) collate utf8_bin NOT NULL DEFAULT '',
  `manufacturers_image` varchar(64) collate utf8_bin DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `last_modified` datetime DEFAULT NULL,
  PRIMARY KEY  (`manufacturers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;
 
 
CREATE TABLE `manufacturers_info` (
  `manufacturers_id` int(11) NOT NULL DEFAULT '0',
  `manufacturers_url` varchar(255) collate utf8_bin NOT NULL DEFAULT '',
  `url_clicked` int(5) NOT NULL DEFAULT '0',
  `date_last_click` datetime DEFAULT NULL,
  PRIMARY KEY  (`manufacturers_id`)
  CONSTRAINT `manufacturers_info_ibfk_1` FOREIGN KEY (`manufacturers_id`) REFERENCES `manufacturers` (`manufacturers_id`) ON DELETE CASCADE;
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
[SQL] pobierz, plaintext 

[mhs]

Czy to odpowiada Twoim oczekiwaniom?

http://dev.mysql.com/tech-resources/articl...ql-triggers.pdf