mysqlparser

mysqlparser is a python lib for parsing MySQL statements.

Usage

import mysqlparser

sqlparser = mysqlparser.Parser()

sql = 'SELECT * FROM `dbData`.`tbTest` WHERE `iId` > 100 LIMIT 10'
result = sqlparser.parse(sql)
print(sqlparser.sql_list)
print(sqlparser.sql_list[0].database)
print(sqlparser.sql_list[0].table)