# rpm -qa |grep MySQL-python 查询是否有mysqldb库
MySQL-python-1.2.3-0.3.c1.1.el6.x86_64
>>> import MySQLdb...1L #显示增加一行记录
mysql> select * from t1;
+------+------+------+
| id | name | age |
+------+------+...), (6L, 'ff', '60'), (7L, 'uu', '70'), (8L, 'rr', '80'), (9L, 'yy', '90'))
>>> cur.fetchmany(7) #不可以重复取数据...()
>>> cur.scroll(0,'absolute') #光标移动到开头位置
>>> cur.fetchmany(7) #可以继续去数据
((1L, 'aa', '10'), (2L, 'bb...'), (7L, 'uu', '70'), (8L, 'rr', '80'))
>>> cur.fetchmany(cur.execute("select * from t1")) #查询表中所有数据条目