freeSwitch_FreeSWITCH中数据库API与Lua操作简介

assert(dbh:connected())

dbh:query("Select Id, Info From MyTable Where Id<10",

    function(row) -- 对每一列进行操作

        print(row.Id, row.Info)

        if( row.Id == 5 ) then 

            dbh:query("Update MyTable Set Info='it is five' Where Id=" .. row.Id)

        end

    end)

dbh:release()