TalkPHP - View Single Post - Insert data into two tables with one query

Wildhoney · 12-09-2007, 08:58 PM

I don't believe you can do it for an INSERT statement, but you can put them in a TRIGGER which can then be executed using one call to it. If you were looking for an easy solution then I think you're out of luck, I'm afraid.

12-09-2007, 08:58 PM	#3 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,267 Thanks: 90	I don't believe you can do it for an `INSERT` statement, but you can put them in a `TRIGGER` which can then be executed using one call to it. If you were looking for an easy solution then I think you're out of luck, I'm afraid. __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.