lua-mysqlHow to insert data
mysql = require "luasql.mysql"
local pool = mysql.mysql()
local db = pool:connect('test', 'usr', 'pwd')
db:execute('INSERT INTO test SET name = "Donald"')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 |
INSERT INTO test SET name = "Donald"sample | |