MysqlQuest_simple

useage

def main():
    db = MysqlQuest(host='localhost', user='root', password='root', port=3306)
    db.do_quest(colum_like=[], value=['40733'])

Introduce

This can be solved. When you have a value, but do not know the specific information of the database, perform all database queries Like this

When you know a spell ID is 30407, but you need to know the location in the database to modify it, and you just don't know this location, you can use it at this time

It is strongly recommended to enter only one value of column_like at a time, as it has not been determined whether multiple values are appropriate

Theory

It will get all the information of the database at init time, and then make a lot of SELECT statements at the time of query, like this,

and then query

Then you can get an excel result like this!