This table lists how MySQL sql dialect was supported by general sql parser.
There are two supporting levels accroding to how general sql parser handle that sql.
Level 1 stands for this sql can be handled by GetRawSqlStatements function
Level 2 stands for this sql can be handled by Parse function
| All
sqls |
Level 1 |
Level 2 |
| alter
database |
Y |
|
| alter
event |
|
|
| alter
function |
Y |
|
| alter
procedure |
Y |
|
| alter
server |
|
|
| alter
table |
Y |
Y |
| alter
view |
Y |
|
| analyze |
Y |
|
| backup
database |
Y |
|
| binlog |
|
|
| cache
index |
Y |
|
| call |
Y |
Y |
| case |
Y |
Y |
| change
master to |
Y |
|
| check
table |
Y |
|
| checksum |
Y |
|
| close |
Y |
Y |
| commit |
Y |
|
| create
database |
Y |
Y |
| create
event |
|
|
| create
function |
Y |
Y |
| create
index |
Y |
Y |
| create
procedure |
Y |
Y |
| create
server |
|
|
| create
table |
Y |
Y |
| create
trigger |
Y |
Y |
| create
user |
Y |
|
| create
view |
Y |
Y |
| declare |
Y |
Y |
| delete |
Y |
Y |
| describle |
Y |
|
| do |
Y |
Y |
| drop
database |
Y |
|
| drop
event |
|
|
| drop
function |
Y |
|
| drop
index |
Y |
Y |
| drop
procedure |
Y |
|
| drop
server |
|
|
| drop
table |
Y |
Y |
| drop
trigger |
Y |
|
| drop
user |
Y |
|
| drop
view |
Y |
Y |
| execute |
Y |
|
| explain |
|
|
| fetch |
Y |
Y |
| flush |
Y |
|
| grant |
Y |
|
| handler |
Y |
|
| help |
|
|
| if |
Y |
Y |
| insert |
Y |
Y |
| install
plugin |
|
|
| iterate |
Y |
Y |
| kill |
Y |
|
| leave |
Y |
Y |
| load
data infile |
Y |
|
| load
index into cache |
Y |
|
| load xml |
|
|
| lock
tables |
Y |
|
| loop |
Y |
Y |
| open |
Y |
Y |
| optimize
table |
Y |
|
| purge
backup logs |
|
|
| purge
bianry logs |
Y |
|
| rename |
Y |
|
| rename
user |
Y |
|
| repair
table |
Y |
|
| repeat |
Y |
Y |
| replace |
Y |
|
| reset |
Y |
|
| reset
master |
Y |
|
| reset
slave |
Y |
|
| restore |
Y |
|
| return |
Y |
Y |
| revoke |
Y |
|
| rollback |
Y |
|
| savepoint |
Y |
|
| select |
Y |
Y |
| set |
Y |
Y |
| set
global |
Y |
|
| set
password |
Y |
|
| set
sql_log_bin |
Y |
|
| set
transaction |
Y |
|
| show |
Y |
Y |
| start
slave |
Y |
|
| start
transaction |
Y |
|
| stop
slave |
Y |
|
| truncate |
Y |
|
| uninstall
plugin |
|
|
| unlock
tables |
Y |
|
| update |
Y |
Y |
| use |
Y |
|
| while |
Y |
Y |
| xa
transaction |
|
|
|
|
|