访问数据库

pip install pymysql

import pymysql

conn = pymysql.connect('localhost', 'root', 'root', 'test')     #链接数据库
cursor = conn.cursor()

cursor.execute('create table user (id varchar(20) primary key, name varchar(20))')  # 创建user表:

cursor.execute('insert into user (id, name) values (%s, %s)', ['1', 'Michael'])     #插入数据四种方式
cursor.execute('insert into user (id, name) values (%s, %s)', ('4', 'Jack'))
user_id = '2'
user_name = 'suki'
cursor.execute('insert into user values("%s", "%s")' % (user_id, user_name))

cursor.execute('insert into user (id, name) values ("%s", "%s")' % ('3', 'Adam'))

print(cursor.rowcount)

#提交事务:
conn.commit()
cursor.close()

#运行查新
cursor = conn.cursor()
cursor.execute('select * from user where id = %s', '4')

#cursor.execute('select * from user where id = "%s"' % '2')
values = cursor.fetchall()
value = cursor.fetchone()
print(values)
print(value)

#关闭Cursor和Connection:
cursor.close()
conn.close()