擅长:python、mysql、java
<p>这是一个完整的工作示例</p>
<pre><code>def rtnwkpr(tick, table, col):
import MySQLdb as mdb
tickwild = tick + '%'
try:
con = mdb.connect(host, user, password, db);
cur = con.cursor()
selectq = "SELECT price FROM %s WHERE %s LIKE %%s;" % (table, col)
cur.execute(selectq,(tickwild))
return cur.fetchall()
</code></pre>