List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:September 8 1999 6:47pm
Subject:Re: Two inserts
View as plain text  
Mick Hanna wrote:
> 
> can i insert one entry into two tables at once??

Hi Mick

No.
But you can enclose the two INSERT statements by LOCK TABLES .... UNLOCK TABLES.
For further info read the manuall on these and also read about the LAST_INSERT_ID()
function.

Tschau
Christian

PS: Sorry for the late answer, I was really busy.

Thread
Two insertsMick Hanna23 Aug
  • count of rowsUrb LeJeune23 Aug
    • Re: count of rowsAndrian Pervazov23 Aug
    • Re: count of rowsSteve Ruby23 Aug
      • Re: count of rowsBenjamin Pflugmann23 Aug
  • Re: Two insertsChristian Mack8 Sep
RE: count of rowsDarren L Sweeney23 Aug