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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
