List:General Discussion« Previous MessageNext Message »
From:***ADI*** Date:December 1 2004 2:50pm
Subject:a query to insert values into two different tables using mySQL Server
View as plain text  
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



Thread
a query to insert values into two different tables using mySQL Server***ADI***1 Dec
  • Re: a query to insert values into two different tables using mySQL ServerEric Bergen4 Dec