python class mysql_mysql-python-class-又一个用来连接 MySQL 数据库的模块

MySQL Python Class

Description

Python MySQL class helps the python developers to connect with MySQL and use queries like: SELECT (one and more conditions), INSERT, UPDATE, DELETE in an easy and fast way.

Usage

To start using the Python MySQL class you need to import the class and initialize with 4 required parameters: host, user, password, database

from mysql-python import MysqlPython

connect_mysql = MysqlPython('host.ip.address', 'user', 'password', 'database')

Select one condition

If you want to obtain information from one table and use one condition, you could use select function where args argument is for referencing the columns you need to obtain.

conditional_query = 'car_make = %s '

result = connect_mysql.select('car', conditional_query, 'id_car', 'car_text', car_make='n