【Python基础】10、MySQLdb模块和python网络编程
In : import MySQLdbIn : conn=MySQLdb.connect(host='127.0.0.1',user='root') #创建连接使用conncet
In : 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_infoconn.server_capabilities
In : conn.stat
Out:
In : conn.stat()
Out: 'Uptime: 719Threads: 1Questions: 6Slow queries: 0Opens: 15Flush tables: 1Open tables: 8Queries per second avg: 0.8'
In : s1=conn.cursor() #创建游标
In : 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_flagss1.rownumber
s1.MySQLError s1.errorhandler s1.scroll
s1.NotSupportedErrors1.execute s1.setinputsizes
s1.OperationalError s1.executemany s1.setoutputsizes
s1.ProgrammingError s1.fetchall
s1.Warning s1.fetchmany
In : s1.execute('SHOW DATABASES;') #执行SQL语句
Out: 3L #返回的结果
In : s1.fe
s1.fetchall s1.fetchmanys1.fetchone
In : s1.fetchall() #详细查看返回的结果，此时游标已经指到了尾部
Out: (('information_schema',), ('mysql',), ('test',))
In : s1.fetchone() #这里没数据了，需要调整游标的位置
In : s1.fetchmany
Out:
In : s1.fetchmany()
Out: ()
In : s1.scroll(0,mode='absolute') #移到首部
In : s1.fetchone() #读取一行
Out: ('information_schema',)
In : s1.fetchone()
Out: ('mysql',)
In : s1.fetchone()
Out: ('test',)
In : s1.fetchone()
In : s1.scroll(1,mode='absolute')
In : s1.fetchone()
Out: ('mysql',)
In : s1.fetchone()
Out: ('test',)
In : s1.fetchone()
In : s1.scroll(0,mode='absolute')
In : s1.fetchmany()
Out: (('information_schema',),)
In : s1.fetchmany()
Out: (('mysql',),)
In : s1.fetchmany()
Out: (('test',),)
In : s1.fetchmany()
Out: ()
In : s1.scroll(0,mode='absolute')
In : s1.fetchmany(3) #可以指定一次读取几行
Out: (('information_schema',), ('mysql',), ('test',))
In : s1.fetchmany(2)
Out: ()
In : s1.scroll(0,mode='absolute')
In : s1.fetchmany(2)
Out: (('information_schema',), ('mysql',))
In : s1.close() #关闭游标
In : conn.close()#关闭连接
页:
[1]