insert into muliple tables at once ( 6 Views )

1. I want to inserts and initial record into muliple tables in one MySQL statement. I am tying these tables together with a common ID.
   
   I've never done it this way before, so I need help in building such a combined statement. Ideas?
   
   Thanks in advance for your help.
   
   
   (mehmet, Czech Republic)


2. It isn't possible to insert into multiple tables simultaneously with any current versions of MySQL.
   
   
   (mutlu, Niue)


3. Hi.
   
   I think only MySQL4 supports INSERTs into multiple tables.
   I guess that you probably want to get the last inserted id (probably by an AUTO_INCREMENTing field)? You can either use PHPs mysql_insert_id() or directly using MySQL's last_insert_id() function. Both return the id of the most recently inserted record.
   
   
   (pelin, Ukraine)

Related Topics ... (or search in 1.720.883 topics !)