import MySQLdb
conn=MySQLdb.connect(host="127.0.0.1",user="root",passwd="123",db="test",port=3306,charset="utf8")
cur=conn.cursor()
cur.execute("insert into msg(title,name,content) values('test03','zz03','test03 cntent')")
conn.commit()
cur.close()
conn.close()
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/1c3ee4afb0d909088c45b3116df18779.png)
import MySQLdb
conn=MySQLdb.connect(host="127.0.0.1",user="root",passwd="123",db="test",port=3306,charset="utf8")
cur=conn.cursor()
sql="insert into msg(title,name,content) values(%s,%s,%s)"
cur.executemany(sql,[('test04','zz04','test04 content'),('test05','zz05','test05 content'),('test06', 'zz06', 'test06 content')])
conn.commit()
cur.close()
conn.close()
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/33385f5f74fe5a3551da33fbcde57b31.png)
import MySQLdb
conn=MySQLdb.connect(host="127.0.0.1",user="root",passwd="123",db="test",port=3306,charset="utf8")
cur=conn.cursor()
for i in range(100):
sql="insert into msg(title,name,content) values(%s,%s,%s)"
cur.executemany(sql,[('test'+str(i),'zz'+str(i),'test'+str(i)+' content')])
conn.commit()
cur.close()
conn.close()
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/016ee9cd61acd256be3376adcf444b5f.png)
import MySQLdb
conn=MySQLdb.connect(host="127.0.0.1",user="root",passwd="123",db="test",port=3306,charset="utf8")
cur=conn.cursor()
import random
sql="insert into user(name,gender) values "
for i in range(100):
sql += "('user" + str(i) + "'," + str(random.randint(0, 1)) + "),"
sql=sql[:-1]
cur.execute(sql)
conn.commit()
cur.close()
conn.close()
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/9fc6990065ac8dcf5b612137aa0bcade.png)
import MySQLdb
conn=MySQLdb.connect(host="127.0.0.1",user="root",passwd="123",db="test",port=3306,charset="utf8")
cur=conn.cursor()
cur.execute("select * from msg")
print cur.fetchall()
cur.execute("select * from msg")
print cur.fetchmany(size=3)
cur.execute("select * from msg")
print cur.fetchone()
cur.execute("select * from msg")
cur.scroll(1,mode='absolute')
print cur.fetchmany(1)
cur.execute("select * from msg")
cur.scroll(1,mode='relative')
print cur.fetchmany(1)
try:
cur.execute("drop table test")
conn.commit()
except:
conn.rollback()
cur.close()
conn.close()
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/5059de1c6db478a37c6b39eab06c925f.png)