|
In [2]: import MySQLdb
In [7]: conn=MySQLdb.connect(host='127.0.0.1',user='root') #创建连接使用conncet
In [10]: conn.
conn.DataError conn.close conn.get_host_info conn.set_character_set
conn.DatabaseError conn.commit conn.get_proto_info conn.set_server_option
conn.Error conn.converter conn.get_server_info conn.set_sql_mode
conn.IntegrityError conn.cursor conn.info conn.show_warnings
conn.InterfaceError conn.cursorclass conn.insert_id conn.shutdown
conn.InternalError conn.default_cursor conn.kill conn.sqlstate
conn.NotSupportedError conn.dump_debug_info conn.literal conn.stat
conn.OperationalError conn.encoders conn.messages conn.store_result
conn.ProgrammingError conn.errno conn.next_result conn.string_decoder
conn.Warning conn.error conn.open conn.string_literal
conn.affected_rows conn.errorhandler conn.ping conn.thread_id
conn.autocommit conn.escape conn.port conn.unicode_literal
conn.begin conn.escape_string conn.query conn.use_result
conn.change_user conn.field_count conn.rollback conn.warning_count
conn.character_set_name conn.get_autocommit conn.select_db
conn.client_flag conn.get_character_set_info conn.server_capabilities
In [14]: conn.stat
Out[14]:
In [15]: conn.stat()
Out[15]: 'Uptime: 719 Threads: 1 Questions: 6 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.8'
In [4]: s1=conn.cursor() #创建游标
In [5]: s1.
s1.DataError s1.arraysize s1.fetchone
s1.DatabaseError s1.callproc s1.lastrowid
s1.Error s1.close s1.messages
s1.IntegrityError s1.connection s1.nextset
s1.InterfaceError s1.description s1.rowcount
s1.InternalError s1.description_flags s1.rownumber
s1.MySQLError s1.errorhandler s1.scroll
s1.NotSupportedError s1.execute s1.setinputsizes
s1.OperationalError s1.executemany s1.setoutputsizes
s1.ProgrammingError s1.fetchall
s1.Warning s1.fetchmany
In [5]: s1.execute('SHOW DATABASES;') #执行SQL语句
Out[5]: 3L #返回的结果
In [6]: s1.fe
s1.fetchall s1.fetchmany s1.fetchone
In [6]: s1.fetchall() #详细查看返回的结果,此时游标已经指到了尾部
Out[6]: (('information_schema',), ('mysql',), ('test',))
In [7]: s1.fetchone() #这里没数据了,需要调整游标的位置
In [8]: s1.fetchmany
Out[8]:
In [9]: s1.fetchmany()
Out[9]: ()
In [11]: s1.scroll(0,mode='absolute') #移到首部
In [13]: s1.fetchone() #读取一行
Out[13]: ('information_schema',)
In [14]: s1.fetchone()
Out[14]: ('mysql',)
In [15]: s1.fetchone()
Out[15]: ('test',)
In [16]: s1.fetchone()
In [17]: s1.scroll(1,mode='absolute')
In [18]: s1.fetchone()
Out[18]: ('mysql',)
In [19]: s1.fetchone()
Out[19]: ('test',)
In [20]: s1.fetchone()
In [21]: s1.scroll(0,mode='absolute')
In [22]: s1.fetchmany()
Out[22]: (('information_schema',),)
In [23]: s1.fetchmany()
Out[23]: (('mysql',),)
In [24]: s1.fetchmany()
Out[24]: (('test',),)
In [25]: s1.fetchmany()
Out[25]: ()
In [26]: s1.scroll(0,mode='absolute')
In [32]: s1.fetchmany(3) #可以指定一次读取几行
Out[32]: (('information_schema',), ('mysql',), ('test',))
In [33]: s1.fetchmany(2)
Out[33]: ()
In [34]: s1.scroll(0,mode='absolute')
In [35]: s1.fetchmany(2)
Out[35]: (('information_schema',), ('mysql',))
In [36]: s1.close() #关闭游标
In [37]: conn.close() #关闭连接
|
|
|