lua mysql开发环境

local mysql = require("resty.mysql")
local db, err = mysql:new()
if not db then
    ngx.say("failed to create mysql: ", err)
    return
end

local ok, err, errno, sqlstate = db:connect{
    host = "your_mysql_host",
    port = your_mysql_port,
    user = "your_mysql_user",
    password = "your_mysql_password",
    database = "your_database_name"
}

if not ok then
    ngx.say("failed to connect to mysql: ", err, ": ", errno, " ", sqlstate)
    return
end

local res, err, errno, sqlstate = db:query("SELECT * FROM your_table WHERE id = 1")
if not res then
    ngx.say("failed to execute query: ", err, ": ", errno, " ", sqlstate)
    return
end

for _, row in ipairs(res) do
    ngx.say(row.id, ": ", row.name)
end

local res, err, errno, sqlstate = db:query("SELECT * FROM your_table")
if not res then
    ngx.say("failed to execute query: ", err, ": ", errno, " ", sqlstate)
    return
end

-- 处理查询结果

-- 释放连接
db:set_keepalive(10000, 100)