Lua处理mysql转义字符

-- 处理mysql转义字符
local mysqlEscapeMode = "[%z\'\"\\\26\b\n\r\t]";
local mysqlEscapeReplace = {
    ['\0']='\\0',
    ['\''] = '\\\'',
    ['\"'] = '\\\"',
    ['\\'] = '\\\\',
    ['\26'] = '\\z',
    ['\b'] = '\\b',
    ['\n'] = '\\n',
    ['\r'] = '\\r',
    ['\t'] = '\\t',

    };

local function mysqlEscapeString(s)
    return string.gsub(s, mysqlEscapeMode, mysqlEscapeReplace);
end