擅长:python、mysql、java
<p>我试了一下,结果就出来了</p>
<pre><code>import MySQLdb
conn = MySQLdb.connect('localhost', 'test', 'test', db='test')
cur = conn.cursor()
result = cur.execute("select * from users where id > 7")
print "RESULT :", result
print "DATA :", cur.fetchall()
cur.execute("insert into users(day) values('2012-03-15')")
conn.commit()
result = cur.execute("select * from users where id > 7")
print "RESULT :", result
print "DATA :", cur.fetchall()
</code></pre>