in MS SQL u can do it by the following query:
declare @transool varchar(20)
set @transool = 'opcofficelink'
begin transaction @transool
insert into Table1 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec,
@Sine_30_Sec)
insert into Table2 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec,
@Sine_30_Sec)
commit transaction @transool
is there any similar query that can be used in mySQL?
what i want to get is insert into Table1 and update row in Table2 the same
values.
i can't use two querries =/
thanx for ANY help,
ADI