本文实例讲述了python访问mysql数据库的实现方法。分享给大家供大家参考,具体如下:
首先安装与Python版本匹配的MySQLdb
示例一
1 2 3 4 5 6 7 8 9 10 | import MySQLdb
conn = MySQLdb.connect(user = 'root' ,passwd = '123' ,db = 'example' )
cur = conn.cursor()
cur.execute( "select id,lastname,firstname, date_format(dob,'%Y-%m-%d %H-%i-%s'),phone from employee" )
for data in cur.fetchall():
print data
cur.close()
conn.commit()
conn.close()
|
Copy after login
示例二
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | import MySQLdb
conn = MySQLdb.connect(host = 'localhost' ,user = 'root' ,passwd = '')
cursor = conn.cursor()
cursor.execute( "create database python" )
cursor.execute( 'use python' )
cursor.execute( "create table test(id int, content varchar(100))" )
for i in range ( 1 , 100 ):
cursor.execute( "insert into test values(%s,%s)" ,[i, 'haha' ])
cursor.execute( 'select * from test' )
results = cursor.fetchall()
for r in results
print r
conn.close()
|
Copy after login
希望本文所述对大家Python程序设计有所帮助。
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn