uldn't be set prior to the
row 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 ta
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 Message
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
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.
>>
>> --
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
www.giiexpr
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 t
