New topic: 

Insert with LAST INSERT ID

<http://forums.realsoftware.com/viewtopic.php?t=45854>

         Page 1 of 1
   [ 1 post ]                 Previous topic | Next topic          Author  
Message        neonash7777          Post subject: Insert with LAST INSERT 
IDPosted: Thu Nov 08, 2012 4:07 pm                         
Joined: Mon Nov 29, 2010 7:01 pm
Posts: 304                I'm using 
INSERT INTO `Payments` SELECT * FROM `tempPayments` ON DUPLICATE KEY 
`Id`=LAST_INSERT_ID(`Id`)

But the code doesn't work. I'm not sure why? Any idea?   
                             Top             Display posts from previous: All 
posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost 
timeSubject AscendingDescending          Page 1 of 1
   [ 1 post ]      
-- 
Over 1500 classes with 29000 functions in one REALbasic plug-in collection. 
The Monkeybread Software Realbasic Plugin v9.3. 
http://www.monkeybreadsoftware.de/realbasic/plugins.shtml

[email protected]

Reply via email to