易语言读取数据库mysql

include <MYSQL.E>

func main()
    var hMysql = mysql_init()
    var nRet = mysql_real_connect(hMysql, "localhost", "root", "password", "database", 0, "")
    if nRet == 0 then
        // 连接失败
    else
        // 连接成功
    end if

    mysql_close(hMysql)
end

include <MYSQL.E>

func main()
    var hMysql = mysql_init()
    var nRet = mysql_real_connect(hMysql, "localhost", "root", "password", "database", 0, "")
    if nRet == 0 then
        // 连接失败
    else
        // 连接成功
        var sSQL = "SELECT * FROM table"
        var nQueryRet = mysql_query(hMysql, sSQL)
        if nQueryRet == 0 then
            var hRes = mysql_use_result(hMysql)
            while mysql_fetch(hRes) do
                // 读取数据行
                var sField1 = mysql_field(hRes, 0)
                var sField2 = mysql_field(hRes, 1)
                // 处理数据
            end while
            mysql_free_result(hRes)
        else
            // 查询失败
        end if
    end if

    mysql_close(hMysql)
end