pymysql 基本操作

In [2]: conn = pymysql.connect(host="127.0.0.1",user="root",passwd="123456")In [3]: conn.query("create database pymysql")Out[3]: 1In [5]: conn = pymysql.connect(host="127.0.0.1",user="root",passwd="osyunwei",db="pymysql")In [6]: conn.query("create table mytb(id int primary key auto_increment,title char(20) not null,keywd char(30))")Out[6]: 0In [9]: conn.query("insert into mytb(title,keywd) values('first title','first key')")Out[9]: 1In [10]: conn.cursor()Out[10]: <pymysql.cursors.Cursor at 0x7fb686276710>In [11]: cs = conn.cursor()In [12]: cs.execute("select * from mytb")Out[12]: 1In [13]: for i in cs:    ...:     print i    ...:     (1, 'first title', 'first key')