hi:
哪位大侠能提供一个使用lua-resty-mysql按条读取记录的例子呢,在网上几乎所有的例子,都是一次读取所有的结果,然后使用cjson输出一个json字符串。
我这里业务需求,要求根据记录中的某个字段的值进行判断,再进行下面的处理。
如果能达到下面官方文档中的第二种结果也可以呢
不胜感激!!
read_result
syntax: res, err, errno, sqlstate = db:read_result()
syntax: res, err, errno, sqlstate = db:read_result(nrows)
Reads in one result returned from the MySQL server.
It returns a Lua table (res
) describing the MySQL OK packet
or result set packet
for the query result.
For queries corresponding to a result set, it returns an array
holding all the rows. Each row holds key-value apirs for each data
fields. For instance,
{
{ name = "Bob", age = 32, phone = ngx.null },
{ name = "Marry", age = 18, phone = "10666372"}
}
For queries that do not correspond to a result set, it returns a Lua table like this:
{
insert_id = 0,
server_status = 2,
warning_count = 1,
affected_rows = 32,
message = nil
}