luarock是一个类似包管理,但是安装起来麻烦
安装部署大概
这里要提前安装 yum install mysql-devel
如果没找到libmysqlclient,尝试找下,再不行就下载
luarocks install luasql-mysql MYSQL_INCDIR=/usr/include/mysql
cp /usr/local/mysql/lib/libmysqlclient.so /usr/local/lib
luarocks install luasql-mysql
执行的时候lua 文件名称
lua 的代码简洁,复杂的数据清洗通过lua处理很块
mysql = require "luasql.mysql"
local env = mysql.mysql()
local conn = env:connect('BB_test','root','123456')
print(env,conn)
print(status,errorString )
cursor,errorString = conn:execute([[select * from BWccount]])
print(cursor,errorString)
row = cursor:fetch ({}, "a")
while row do
print(string.format("BWID: %s, BWName: %s", row.BWID, rowBWName))
local strSQL = string.format("select * from bwfri where BWID=%d", row.BWID);
print(strSQL);
fcursor,ferrorString = conn:execute(strSQL)
frow = fcursor:fetch ({}, "a");
if frow == nil then
print(string.format("BWID=%u BWFRIEND TABLE CANNOT FOUND",row.BWID));
iSQL = string.format("INSERT INTO `bwfriend` VALUES ('%u', '%u', '', '', '');", row.BWAccountID, row.BWAccountID);
icursor,ierrorString = conn:execute(iSQL)
icursor:close();
printf(iSQL)
end
fcursor:close();
row = cursor:fetch (row, "a")
end
cursor:close()
conn:close()
env:close()