lua-mysqlHow to update data
mysql = require "luasql.mysql"
local pool = mysql.mysql()
local db = pool:connect('test', 'usr', 'pwd')
db:execute('UPDATE test SET name = "Bill" WHERE id = 14')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 |
'UPDATE test SET name = "Bill" WHERE id = 14'sample | |