lua-resty-mysql
lua-resty-mysql copied to clipboard
openresty
Nonblocking Lua MySQL driver library for ngx_lua or OpenResty
Note : I don't use in product yet.
Do we have PDO style query in lua-resty-mysql The query and params can be sent separately rather than a string and it takes care of sql injection etc.
When i tried the query method as the readme said: `res,err,errcode,sqlstate=db:query("select * from account where id="..id..";")`The correct query was OK. And to test the condition of bad result("empty set"),i use...
Hello, I get a strange error from time to time: ``` lua entry thread aborted: runtime error: /resty/mysql.lua:63: attempt to call local 'new_tab' (a table value) stack traceback: coroutine 0:...
local function _get_byte8(data, i) local a, b, c, d, e, f, g, h = strbyte(data, i, i + 7) ``` -- XXX workaround for the lack of 64-bit support in...
``` bytes, err = db:send_query(query) res, err, errcode, sqlstate = db:read_result() res, err, errcode, sqlstate = db:read_result(nrows) res, err, errcode, sqlstate = db:query(query) res, err, errcode, sqlstate = db:query(query, nrows)...
I want to insert 3 SQL statements are inserted into the 3 table, but the performance is too low, I was so written, how do I do to make the...
It would be great if this library could support cursors. Is there a plan to add this or is there a reason not to do it? luasql has this support...
error: "Incorrect datetime value: 'Tue Jan 12 18:31:10 2016' for column 'createTime' at row 1" table: CREATE TABLE `jctx_group_members` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `groupId` int(20) unsigned NOT...
