Isn't that technically multiple queries? In mysql an insert inserts into one table. That's it.
-Eric On Wed, 1 Dec 2004 15:50:15 +0100, ***ADI*** <[EMAIL PROTECTED]> wrote: > 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] > > -- Eric Bergen [EMAIL PROTECTED] bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]