View Single Post
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