本文章代码是根据疯狂的蚂蚁的博客中的MySQLdb连接python代码改编过来的,属于原创代码。
一、使用pycharm连接python和pymysql(实际上用不着import sys这语句)
import pymysql
import sys
con=pymysql.connect('127.0.0.1','root','abc123ABC','csdn')
with con:
cur=con.cursor()
cur.execute("SELECT*FROM Writers")
rows=cur.fetchall()
for row in rows:
print row
二、使用pycharm在python中创建数据库(csdn)和表格(Writers)。由于没有输出,所以无法在pycharm查看。但是,可以直接在mysql中查找到结果。
import pymysql
import sys
con=pymysql.connect('127.0.0.1','root','abc123ABC','csdn')
with con:
cur=con.cursor()
cur.execute("CREATE TABLE IF NOT EXISTS Writers(Id INT PRIMARY KEY AUTO_INCREMENT,Name VARCHAR(25))")
cur.execute("INSERT INTO Writers(Name) VALUES('Jack London')")
cur.execute("INSERT INTO Writers(Name) VALUES('hONORE DE bALZAC')")
cur.execute("INSERT INTO Writers(Name) VALUES('Lion Feuchtwanger')")
cur.execute("INSERT INTO Writers(Name) VALUES('Emile Zola')")
cur.execute("INSERT INTO Writers(Name) VALUES('Truman Capote')")
三、打印表格内容
import pymysql
import sys
con=pymysql.connect('127.0.0.1','root','abc123ABC','csdn')
with con:
cur=con.cursor()
cur.execute("SELECT*FROM Writers")
rows=cur.fetchall()
for row in rows:
print row