luasql在Fedora20下的安装与使用示例

主要参考:http://www.boll.me/archives/614

luasql安装, 在终端通过yum命令安装:

yum -y install lua-sql

接下来写个测试的lua脚本文件(通过lua连接mysql数据库),如:

#!/usr/bin/lua

local luasql = require "luasql.mysql"
local env = assert(luasql.mysql())
local con = assert(env:connect("mysql", "root", "123", "192.168.1.90", 3306))
local cur = assert(con:execute("show databases"))
local row = cur:fetch ({}, "a")
 
while row do
    print(row.Database)
    row = cur:fetch (row, "a")
end

cur:close()
con:close()
env:close()

运行结果:

[zcm@vm-fedora20 lua]$ ./mysql.lua 
information_schema
mysql
performance_schema
sakila
test
world

 

posted on 2015-03-16 16:27  清清飞扬  阅读(483)  评论(0编辑  收藏  举报