擅长:python、mysql、java
<p>尝试这样的方法…未经测试:</p>
<pre><code>cnx = mysql.connector.connect(user='user', password='pw', host='ip_here')
cursor.execute('SELECT * FROM database.`table_name`')
iValues = cursor.fetchall()
cursor.close
cnx.close
#for i,j in enumerate(iValues):
# if i == 0:
# extractedValues = iValues
# else:
# extractedValues = np.hstack(())
extractedValues = list(iValues)
</code></pre>