create table foo
(aa varchar(20),
id integer,
cc varchar(20));
delimiter |
create trigger foo_ins before insert on foo
for each row
begin
set new.aa = concat(new.cc,'-',new.id);
end; |
delimiter ;
insert into foo (cc,id) values ('www',1);
select * from foo;
-Original
being created...
any more pointers/thoughts/...
thanks
-Original Message-
From: joe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 7:33 PM
To: 'bruce'; 'mysql list'
Subject: RE: trigger question..
create table foo
(aa varchar(20),
id integer,
cc varchar(20
Hi Bruce,
delimiter |
create trigger mfgtst after insert on masterHostTBL
for each row begin
set @tmp = 55;
insert into masterTestResultStartTBL
set hostID = NEW.id,
testResultVal = 88;
/*
set @q = masterTestResultStartValTBL.serverStartVal;
Hi,
Olaf Stein wrote:
Hey all,
I asked this before (a while back) and have gotten some answers that solve
my problem partially only.
--- old message --
I have a table with 205 columns. When an update statement updates a row in
this table I want a trigger that creates a record of
Will a SELECT * FROM work there? I'm not using 5.x, so I haven't really
investigated triggers; this is just a guess.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
Baron,
Thanks a lot
Adding the columns to the end works...
Olaf
On 5/30/07 2:13 PM, Baron Schwartz [EMAIL PROTECTED] wrote:
Hi,
Olaf Stein wrote:
Hey all,
I asked this before (a while back) and have gotten some answers that solve
my problem partially only.
--- old message