[Freeswitch-users] dbh:query - insert id

John M j_mj at aol.com
Sat May 25 07:59:54 MSD 2013


 Hi Seven Du,

I'd really like to know if this is possible too, couldn't find it documented anywhere.

Instead of being cryptic, if you know the answer won't you please help by explaining what the RETURNING clause is and how to use it?

Does it somehow return mysql_insert_id()?

How should we use it.

You help is invaluable and is contributing to the freeswitch community.

-Jm

 

 

-----Original Message-----
From: Seven Du <dujinfang at gmail.com>
To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
Sent: Sat, May 25, 2013 12:52 pm
Subject: Re: [Freeswitch-users] dbh:query - insert id


                
                    Maybe try the RETURNING clause ?                
                


-- 
Seven Du
http://www.freeswitch.org.cn
http://about.me/dujinfang

http://www.dujinfang.com



Sent with Sparrow


                                 
On Saturday, May 25, 2013 at 8:14 AM, Lloyd Aloysius wrote:
                
                    


Hello All


How to get the id value after insert a record a record using dbh:query


table_a - columns.


id - auto increment
field1
field2




dbh:query("insert into table_a ( field1,field2) values ('11','Test')")




After insert how to get the table_a - id value for the inserted record?


Thanks
Lloyd



_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org
http://www.freeswitchsolutions.com






Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com


FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

                                                                                    
                                 
                    
                

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org
http://www.freeswitchsolutions.com




Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130524/7ba0e708/attachment.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list