con = assert (env:connect ("databasename", "username", "password", "servername"))

con = assert (env:connect ("YOURDATABASENAME", "aardxaxz", "YOURPASSWORD", "freesql.org"))

table.foreach (row, print)  

print ("Mob:", row.name)
print ("Level:", row.level)

<script>
<![CDATA[
function mfind(strig, sline, wildcards )
assert (package.loadlib ("mysql.dll", "luaopen_luasqlmysql")) ()
-- create environment object
env = assert (luasql.mysql())

-- connect to data source
con = assert (env:connect ("db", "usr", "pass", "server"))

-- retrieve a cursor
cur = assert (con:execute ("SELECT * from mobfinder WHERE name Like ".."\'%"..wildcards[1].."%\'" ))

-- print all rows, the rows will be indexed by field names
row = cur:fetch ({})

while row do
  print ("\n------ new row ---------\n")
  table.foreach (row, print)  
  -- reusing the table of results
  row = cur:fetch (row, "a")
end

-- close everything
cur:close()
con:close()
env:close()
end
]]>
</script>

43b953fe2f93cb98d39aa3ae63776f5d  libmySQL.zip

-- load the MySQL dll
loadlib ("mysql.dll", "luaopen_luasqlmysql") ()

-- load the MySQL dll
assert (package.loadlib ("mysql.dll", "luaopen_luasqlmysql")) ()

-- load the MySQL dll
loadlib ("mysql.dll", "luaopen_luasqlmysql") ()

-- create environment object
env = assert (luasql.mysql())

-- connect to data source
con = assert (env:connect ("databasename", "username", "password", "servername"))

-- empty our table
res = con:execute"DROP TABLE players"

res = assert (con:execute[[
  CREATE TABLE players(
    name  varchar(50),
    class varchar(50)
  )
]])


-- add a few elements
list = {
  { name="Nick Gammon", class="mage", },
  { name="David Haley", class="warrior", },
  { name="Shadowfyr", class="priest", },
}

for i, p in pairs (list) do
  res = assert (con:execute(string.format([[
    INSERT INTO players
    VALUES ('%s', '%s')]], p.name, p.class)
  ))
end

-- retrieve a cursor
cur = assert (con:execute ("SELECT * from players" ))

-- print all rows, the rows will be indexed by field names
row = cur:fetch ({}, "a")

while row do
  print ("\n------ new row ---------\n")
  table.foreach (row, print)
  
  -- reusing the table of results
  row = cur:fetch (row, "a")
end

-- close everything
cur:close()
con:close()
env:close()

------ new row ---------

class mage
name Nick Gammon

------ new row ---------

class warrior
name David Haley

------ new row ---------

class priest
name Shadowfyr

mysql> select * from players;
+-------------+---------+
| name        | class   |
+-------------+---------+
| Nick Gammon | mage    |
| David Haley | warrior |
| Shadowfyr   | priest  |
+-------------+---------+
3 rows in set (0.00 sec)