can we insert into two tables with single sql statement?

Will it be possible to insert into two tables wi开发者_如何学Goth same insert command?

---

No you cannot perform multiple inserts into two tables in one query.

---

No you can't.

If you want to ensure the atomicity of an operation that requires data to be inserted into 2 tables, you should protect it in a transaction. You either use the SQL statements BEGIN TRAN and COMMIT TRAN, or you use a transaction boundary in whatever language you're using to develop the db access layer. E.g. something like Connection.StartTransaction and Connection.Commit (or Connection.Rollback on an error).

---

You can call a stored procedure with inserts into two tables.

---

Maybe in a future release of MySQL you could create a View containing the 2 tables and insert into that.
But with MySQL 5.1.41 you'll get the error:
"Can not modify more than one base table through a join view"

But inserting into 2 tables with 1 query is a weird thing to do, and I don't recommend it.

For more on updatable views check out the MySQL reference.