Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,255
Total Threads: 81,172
Total Posts: 566,877
There are 55 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     Programming     PHP and MySQL :

MySQLi: Multiple insert into's and last_insert_id

Thread title: MySQLi: Multiple insert into's and last_insert_id
     
    Thread tools Search this thread Display Modes  
Prev Previous Post   Next Post Next
12-31-2012, 02:17 AM
#1
Dan is offline Dan
Dan's Avatar
Status: Request a custom title
Join date: Feb 2005
Location:
Expertise:
Software:
 
Posts: 3,164
iTrader: 15 / 86%
 

Dan is an unknown quantity at this point

  Old  MySQLi: Multiple insert into's and last_insert_id

I'm attempting one large query rather than several smaller ones. Firstly I'm inserting into one table and grabbing it's row ID to insert into another, for multiple rows. Is there anyway to do this?

Is there a better method of multiple inserts than I'm currently doing? Writing the same insert into several times feels like overkill.

Code:
    INSERT INTO `users notes` (`text`) 
    	VALUES ('blah blah some text here');
    
    INSERT INTO `users exercises` (`userid`, `exerciseid`, `time`, `weight`, `distance`, `reps`, `intensity`, `notes`) 
    	(1, 188, 1, NULL, NULL, NULL, NULL, last_insert_id()),
    	(1, 188, 1, NULL, NULL, NULL, NULL, last_insert_id());
    
    
    INSERT INTO `users notes` (`text`) 
    	VALUES ('blah blah some text here');
    
    INSERT INTO `users exercises` (`userid`, `exerciseid`, `time`, `weight`, `distance`, `reps`, `intensity`, `notes`) 
    	(1, 188, 1, NULL, NULL, NULL, NULL, last_insert_id()),
    	(1, 188, 1, NULL, NULL, NULL, NULL, last_insert_id());

    etc.

Reply With Quote
     


Thread Tools
Display Modes

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed