python 学习笔记（二十七）

# coding=utf8
__author__ = 'liwei'
import mysql.connector
'创建连接mysql连接'
conn=mysql.connector.connect(user='root',password='root',database='test',use_unicode=True)
cursor = conn.cursor()
'创建user表'
cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')
'插入一条记录'
cursor.execute('insert into user (id,name) value (%s,%s)',['1','Liwei'])
cursor.execute('insert into user (id,name) value (%s,%s)',['2','Lizhao'])
cursor.execute('insert into user (id,name) value (%s,%s)',['3','Guoli'])
cursor.execute('insert into user (id,name) value (%s,%s)',['4','Wangfengfeng'])

cursor.rowcount

conn.commit()
cursor.close()

'查询数据操作'
cursor = conn.cursor()
cursor.execute('select * from user where id =%s','1')
values = cursor.fetchall()


cursor.close()
conn.close()