[globals]
DBCurrentHost=localhost
DBuser=root
DBpass=passw0rd
DBname=asterisk

[sip]
exten => _X.,1,Set(CALLERID(num)=58837999)
exten => _X.,n,MySql(connect connid ${DBCurrentHost} ${DBuser} ${DBpass} ${DBname})??? ;連接mysql 操作
exten => _X.,n,set(ID=12)
exten => _X.,n,MySql(query resultid ${connid} insert?? into? jd? set? id=14\, name =\'ppp\') ; //進行查詢??
exten => _X.,n,MySql(query resultidr ${connid} select name from jd where id=${ID}) ; //進行查詢??
exten => _X.,n,MySql(Fetch foundrow ${resultidr} name)????????????? ;//讀取
exten => _X.,n,MySql(clear ${resultidr})? ;//清除什么什么東東??
exten => _X.,n,MySql(disconnect ${connid}) ; //關(guān)閉連接?
exten => _X.,n,noop(${name})
exten => _X.,n,Queue(sipqueue,t,,,150)
exten => _X.,n,hangup

exten => 3000,1,SetMusicOnHold(default)
exten => 3000,n,WaitMusicOnHold(20)

轉(zhuǎn)載于:https://www.cnblogs.com/5dteam/articles/2059943.html

總結(jié)

以上是生活随笔為你收集整理的asterisk 操作mysql的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。