use mysql-connector-python memo

mysql-connector-python

#!/usr/bin/env python
# -*- coding: utf-8 -*-

import mysql.connector

def sql_executer(sql):

  con = mysql.connector.connect(
    host = "localhost",
    port = 3306,
    db = "table",
    user = "test",
    passwd = "password",
    buffered=True)

  cur = con.cursor()
  cur.execute(sql)
  res = cur.fetchall()

  cur.close()
  con.close()

  return res