lua-mysqlHow to get number of rows from Mysql
mysql = require "luasql.mysql"
local pool = mysql.mysql()
local db = pool:connect('test', 'usr', 'pwd')
local cursor = db:execute('SELECT * FROM test')
local num = cursor:numrows()ctrl + crequire "luasql.mysql"includes mysql module to work with database | mysql.mysql()init Mysql connection |
pool:connectconnect to Mysql server based on specified credentials | db:executeexecutes given query and returns cursor to iterate through results |
cursorcursor to manipulate result set | :numrows()returns number of rows in a result set |
Usage example
mysql = require "luasql.mysql"
local pool = mysql.mysql()
local db = pool:connect('test', 'usr', 'pwd')
local cursor = db:execute('SELECT * FROM test')
local num = cursor:numrows()
print(num)output
16