What is the correct way to use regexps and parentheses in lua?

Question

Lua

Why doesn't this design work?

local querycreate = "create user 'dddqwd123_dwqd'@'localhost'"
local create, usercreate, username, userhost = querycreate:match("^(%w+)%s+(%w+)%s+\'(%w)\'@\'(%w)\'$")
print(string.format("query: %s", querycreate))
print(string.format(" var create = %s \n var usercreate = %s \n var username = %s \n var userhost = %s", create, usercreate, username, userhost))

When executed, I get:
query: create user 'dddqwd123_dwqd'@'localhost'
var create = nil
var usercreate = nil
var username = nil
var userhost = nil
If the regexp is changed to ("^(%w+)%s+(%w+)%s+ "), then I get:
var create = create
var usercreate = user
var username = nil
var userhost =
nil w+)%s+(%w+) @ (%w+)$, then I get the output I need.

Answer 1

querycreate:match("^(%w+)%s+(%w+)%s+'([%w_]+)'@'(%w+)'$")

tyts tyts