Insert question

[Anon]

Hi,
Can you insert data into two tables at the same time. If so how?

[sarahk]

I doubt you can but you could try
sqlstr = addslashes("insert into tableA (id, note) values (null,'test this'); insert into tableB (id, name) values (null, 'John Doe')");

might work. It's 2 statements but only a single call to the database.

You'd probably find that the reporting back, handles etc is screwed.

Sarah

[Anon]

If you mean in a single statement, the answer is no.

If you are using a dbms that supports Transactions then the answer is you might get what you want with a BEGIN TRANSACTION - COMMIT. Mysql has some limited support that probably does what you want (last insert id, etc).

What do you mean by "at the same time" and why is it important?