I have an asterisk system. And I program IVR.
Here is two script
first one
exten => h,1,MYSQL(Connect connid host user pass databases)
exten => h,2,MYSQL(Query resultid ${connid} INSERT\ INTO\ table1)
exten => h,3,MYSQL(Disconnect ${connid})
exten => h,4,MYSQL(Connect connid host user pass databases)
exten => h,5,MYSQL(Query resultid ${connid} UPDATE\ table2)
exten => h,6,MYSQL(Disconnect ${connid})
exten => h,7,MYSQL(Connect connid host user pass databases)
exten => h,8,MYSQL(Query resultid ${connid} UPDATE\ table3)
exten => h,9,MYSQL(Disconnect ${connid})
And
exten => h,1,MYSQL(Connect connid host user pass databases)
exten => h,2,MYSQL(Query resultid ${connid} INSERT\ INTO\ table1)
exten => h,3,MYSQL(Query resultid ${connid} UPDATE\ table2)
exten => h,4,MYSQL(Query resultid ${connid} UPDATE\ table3)
exten => h,5,MYSQL(Disconnect ${connid})
What do you prefer ?