Can you use JOINS when inserting data?

[VitoCorleone]

hello,

This is a half mysql and PHP question. I was wondering if you can use JOINS to insert into multiple tables rather than using mysql_query() to invoke multiple queries?

If you can, could you point me to some examples?

 

[r937]

nope, only one table at a time



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[hessodreamy]

Dont quote me on this but I believe you can create a view incorporating multiple tables, insert data into the view, and define triggers in the view to update the base tables.

 

[r937]

triggers would be only in mysql 5

i wouldn't build anything with triggers in a beta product



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)