Read/write mysql database

[Carlos Padilla]

Install packages:
https://dl.openrb.com/pkg/zlib_1.2.7-1_mxs.ipk
https://dl.openrb.com/pkg/libmysqlclient...-1_mxs.ipk
https://dl.openrb.com/pkg/liblua-mysql_2.2.0-2_mxs.ipk

Docs:
http://keplerproject.github.io/luasql/do...anual.html

Short example, don't use db as a variable name or you will mess up LM internal database connection

Code:

require('luasql.mysql') env = luasql.mysql() dbcon = env:connect(DB_NAME, USERNAME, PASSWORD, MYSQL_SERVER_IP, MYSQL_SERVER_PORT) cursor = dbcon:execute('SELECT * FROM mytable') while true do  row = cursor:fetch({}, 'a')  if row then    log(row)  else    break  end end cursor:close() dbcon:close() env:close()

Hi a question 


as that table select as in your case "select * from mytable"

where do you get
the user, password, dbname, server and port  for function connect?