[asterisk-users] Dialplan MySQL inserted ID

[Gergo Csibra]

Tuesday, August 20, 2013, 5:47:24 PM, Gareth wrote:

> On 20/08/13 14:53, Jonas Kellens wrote:
>> Hello,
>>
>> how can I obtain the "inserted ID" after having inserted a row with 
>> MySQL in the dialplan ?
>>
>> exten => s,n,MYSQL(Query resultid ${connid} INSERT INTO myTable SET 
>> C1="${ARG1}", C2="${ARG2}", 
>> timestamp="${STRFTIME(${EPOCH},,%Y-%m-%d_%H:%M:%S)}")
>>
>> I need to know the ID of the newly inserted row.

> You could write an AGI script in something like php or perl and get it 
> to write to the mysql database instead. It can then set a variable which 
> the dialplan can pick up.

meh...

SELECT LAST_INSERT_ID()

-- 
Best regards,
 Gergo                            mailto:csibra at gmail.com