可以下载安装http://dev.mysql.com/downloads/connector/python/
或者通过pip安装 pip install mysql-connector
确认安装成功：
C:\Users\aspwin01>python
Python 2.7.12 |Anaconda 4.2.0 (64-bit)| (default, Jun 29 2016, 11:07:13) [MSC v.1500 64 bit (AMD64)]
on win32
Type "help", "copyright", "credits" or "license" for more information.
Anaconda is brought to you by Continuum Analytics.
Please check out: http://continuum.io/thanks and https://anaconda.org
>>> import mysql
>>>
安装配置MySQL
创建数据库asp测试用
create database asp;
操作MySQL的基本步骤
创建连接：connect
创建游标：cursor
执行SQL：excute、executemany
关闭连接：close
点击(此处)折叠或打开
-
#测试完整的代码
-
-
from mysql import connector
-
-
#1-创建连接
-
-
connectStr = dict(host='localhost',
-
port=3306,
-
user='root',
-
password='root_123',
-
database='asp')
-
-
conn=connector.connect(**connectStr)
-
-
#2-创建游标
-
-
cursor=conn.cursor()
-
-
print '3-执行DDL语句'
-
-
ddl1='''
-
create table test1(
-
id int,
-
name varchar(20),
-
address varchar(30))
-
'''
-
#cursor.execute(ddl1)
-
-
print '4-执行单条插入语句'
-
-
sqltext1='''
-
insert into test1 (name, address) values('Tom', 'Beijing');
-
'''
-
-
cursor.execute(sqltext1)
-
-
print '5-执行多条SQL语句'
-
sqltext2="insert into test1(name, address) values (%s,%s)"
-
-
cursor.executemany(sqltext2,[
-
('Lili0', 'Sanghai'),
-
('Lili1', 'Sanghai'),
-
('Lili2', 'Sanghai'),
-
])
-
-
print '6-执行查询语句'
-
select_text='''
-
select * from test1;
-
'''
-
-
cursor.execute(select_text)
-
for row in cursor:
-
print row
-
-
结果：
-
-
3-执行DDL语句
-
4-执行单条插入语句
-
5-执行多条SQL语句
-
6-执行查询语句
-
(37, u'Tom', u'Beijing')
-
(38, u'Lili0', u'Sanghai')
-
(39, u'Lili1', u'Sanghai')
- (40, u'Lili2', u'Sanghai')
参数化的SQL语句
点击(此处)折叠或打开
-
print '6-参数化的SQL语句1'
-
sqltext3="insert into test1(name,address) values (%s,%s)"
-
v1=('Sari','Suzhou')
-
cursor.execute(sqltext3,v1)
-
conn.commit()
-
-
print '7-参数化的SQL语句2'
-
sqltext4="insert into test1(name,address) values (%s,%s)"
-
v1=('Sari1','Suzhou')
-
v2=('Sari2','Suzhou')
-
v3=('Sari3','Suzhou')
-
v4=('Sari4','Suzhou')
-
vall=[v1,v2,v3,v4]
-
-
cursor.executemany(sqltext4,vall)
- conn.commit()
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29023300/viewspace-2130736/ ，如需转载，请注明出处，否则将追究法律责任。
