您可以将MySQLdb用于Python。
示例代码（您需要对其进行调试，因为我无法在此处运行它）：
#!/usr/bin/python
import MysqLdb
# Open database connection
db = MysqLdb.connect("localhost","testuser","test123","TESTDB" )
# prepare a cursor object using cursor() method
cursor = db.cursor()
# Select qsql with id=4.
cursor.execute("SELECT qsql FROM TBLTEST WHERE id = 4")
# Fetch a single row using fetchone() method.
results = cursor.fetchone()
qsql = results[0]
cursor.execute(qsql)
# Fetch all the rows in a list of lists.
qsqlresults = cursor.fetchall()
for row in qsqlresults:
id = row[0]
city = row[1]
#sql query to INSERT a record into the table FACTRESTTBL.
cursor.execute('''INSERT into FACTRESTTBL (id, city)
values (%s, %s)''',
(id, city))
# Commit your changes in the database
db.commit()
# disconnect from server
db.close()
602392714
清零编程群