---
--- Generated by EmmyLua(https://github.com/EmmyLua)
--- Created by 22040515.
--- DateTime: 2023年1月5日 19:36
---
require('luasql.mysql')

env = luasql.mysql()
conn = env:connect('test', 'snb', 'Snb@cloud123', '10.243.178.150', 3306)
print(conn)
conn:execute('set names utf-8')

cur = conn:execute('select * from role')
row = cur:fetch({}, 'a')

file = io.open('role.txt', 'w+')
head = 'table:role\nid | name\n---------\n'
print(head)
file:write(head)
while row do
 var = string.format('%d | %s\n', row.id, row.name)
 print(var)
 file:write(var)
 row = cur:fetch(row, 'a')
end

file:close()
conn:close()
env:close()