Re: MySQL-pp, Perl and MySQL Triggers

Do the 2 tables have primary keys ?

Assuming the keys are tec_id, try this

my $sql = 'CREATE TRIGGER updt_type BEFORE UPDATE ON ec_user.login
           FOR EACH ROW
           BEGIN
             UPDATE ec_user.user
             SET type = NEW.type 
             WHERE tec_id=OLD.tec_id;
           END;';
[download]

poj

Comment on Re: MySQL-pp, Perl and MySQL Triggers Select or Download Code

Replies are listed 'Best First'.
Re^2: MySQL-pp, Perl and MySQL Triggers by skosterow (Novice) on Dec 18, 2015 at 21:04 UTC
Yes, Both have a field called ID, that is primary. Here is the Table creation code: $sql = "create table login ( id MEDIUMINT NOT NULL AUTO_INCREMENT, created DATE, tec_id VARCHAR(15), type VARCHAR(50), password VARCHAR(100), stage_name VARCHAR(150), last_log DATE, last_time TIME, active VARCHAR(3), banned VARCHAR(3), PRIMARY KEY (id), INDEX (`tec_id` ASC), INDEX (`type` ASC), INDEX (`stage_name` ASC), INDEX (`last_log` ASC) ) ENGINE=MyISAM;"; AND $sql = "create table user ( id MEDIUMINT NOT NULL AUTO_INCREMENT, tec_id VARCHAR(15) NOT NULL UNIQUE, created DATE, agent_id VARCHAR(15), type VARCHAR(50), approved DATE, dob DATE, age_create VARCHAR(3), first_name VARCHAR(100), last_name VARCHAR(100), address_01 VARCHAR(150), address_02 VARCHAR(150), country VARCHAR(50), state VARCHAR(50), city VARCHAR(50), zip CHAR(12), referring_user VARCHAR(15), referring_code VARCHAR(100), terms_accept VARCHAR(3), terms_initials VARCHAR(5), terms_date DATE, rate VARCHAR(5), PRIMARY KEY (id), INDEX (`tec_id` ASC), INDEX (`city` ASC), INDEX (`type` ASC) ) ENGINE=MyISAM;";	[reply]
Re^2: MySQL-pp, Perl and MySQL Triggers by Anonymous Monk on Dec 19, 2015 at 18:29 UTC
poj! Thanks mate SOOOOOOO much it works!!!! EXACTLY what i needed - YOU ROCK!	[reply]