import pymssql #引入pymssql控制模块 server = "localhost" user = "root" password = "root" charset = "cp936" database = "text_01" def conn(): connect = pymssql.connect(server,user,password,database,charset) #网络服务器名,帐户,登陆密码,数据库名 if connect: print("联接取得成功!") cursor = con.cursor() # 查看数据库內容 sqlfirst = "select * from datatable" cursor.execute(sqlfirst) # 获得查看結果,如果是好几条应用:cursor.fetchall() result = cursor.fetchone() if __name__ == '__main__': conn = conn()
之上便是python联接MySQL数据库的基本编码实例 ,必须留意的是,假如你的数据库中存有中文,务必要设定编码格式为:"cp936"