Trigger (varios campos de una tabla)

[wchiquito]

Hola alejandrosc,

Te anexo un ejemplo básico y sencillo que te puede ayudar a solventar el problema:

Código MySQL:

/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
CREATE DATABASE /*!32312 IF NOT EXISTS*/`principal`;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`secundaria1`;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`secundaria2`;
 
USE `principal`;
 
/*Table structure for table `jos_users` */
 
CREATE TABLE `jos_users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;
 
/* Trigger structure for table `jos_users` */
 
DELIMITER $$
 
/*!50003 CREATE TRIGGER `insertar_user` AFTER INSERT ON `jos_users`
FOR EACH ROW
BEGIN
    insert into secundaria1.jos_users (`id`, `name`) values (new.`id`, new.`name`);
    insert into secundaria2.jos_users (`id`, `name`) values (new.`id`, new.`name`);
END */$$
 
DELIMITER ;
 
USE `secundaria1`;
 
/*Table structure for table `jos_users` */
 
CREATE TABLE `jos_users` (
  `id` int(11) NOT NULL,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;
 
USE `secundaria2`;
 
/*Table structure for table `jos_users` */
 
CREATE TABLE `jos_users` (
  `id` int(11) NOT NULL,
  `name` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB;
 
insert into principal.jos_users (`name`) values ('Nuevo Usuario');
 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;