diff options
Diffstat (limited to 'sqlglot/dialects/mysql.py')
-rw-r--r-- | sqlglot/dialects/mysql.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sqlglot/dialects/mysql.py b/sqlglot/dialects/mysql.py index 8449379..524390f 100644 --- a/sqlglot/dialects/mysql.py +++ b/sqlglot/dialects/mysql.py @@ -97,6 +97,8 @@ class MySQL(Dialect): "%s": "%S", "%S": "%S", "%u": "%W", + "%k": "%-H", + "%l": "%-I", } class Tokenizer(Tokenizer): @@ -145,6 +147,9 @@ class MySQL(Dialect): "_TIS620": TokenType.INTRODUCER, "_UCS2": TokenType.INTRODUCER, "_UJIS": TokenType.INTRODUCER, + # https://dev.mysql.com/doc/refman/8.0/en/string-literals.html + "N": TokenType.INTRODUCER, + "n": TokenType.INTRODUCER, "_UTF8": TokenType.INTRODUCER, "_UTF16": TokenType.INTRODUCER, "_UTF16LE": TokenType.INTRODUCER, |