python操作mysql

上一篇 / 下一篇  2016-02-02 13:17:13 / 个人分类：python

查看( 690 ) / 评论( 0 ) / 评分( 0 / 0 )
# 导入MySQL驱动:
>>>importmysql.connector
# 注意把password设为你的root口令:
>>> conn=mysql.connector.connect(user='root', password='password', database='test', use_unicode=True)
>>> cursor=conn.cursor()
# 创建user表:
>>> cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')
# 插入一行记录，注意MySQL的占位符是%s:
>>> cursor.execute('insert into user (id, name) values (%s, %s)', ['1','Michael'])
>>> cursor.rowcount
1
# 提交事务:
>>> conn.commit()
>>> cursor.close()
# 运行查询:
>>> cursor=conn.cursor()
>>> cursor.execute('select * from user where id =1')
>>> values=cursor.fetchall()
>>> values
[(u'1', u'Michael')]
# 关闭Cursor和Connection:
>>> cursor.close()
True
>>> conn.close()

收藏 举报

TAG: MySQL Python python mysql

 

评分：0

我来说两句

Open Toolbar