luasql连接mysql数据库，遍历数据

最新推荐文章于 2024-04-28 16:47:51 发布

weixin_34363171

最新推荐文章于 2024-04-28 16:47:51 发布

阅读量145

点赞数

文章标签：数据库 python lua

原文链接：https://my.oschina.net/u/1053317/blog/158138

版权

2019独角兽企业重金招聘Python工程师标准>>>

<!-- lang: lua -->
 require "luasql.mysql"

env = assert (luasql.mysql())
con = assert (env:connect("dbname","username","password","127.0.0.1",3306))
con:execute("SET NAMES gb2312")
local cur = con:execute("select * from test")
row = cur:fetch({},"a")
while  row do
	row = cur:fetch({},"a")
	if(row == nil) then break end
	print(row.id)

end
cur:close()
con:close()

转载于:https://my.oschina.net/u/1053317/blog/158138