1、创建数据库:
sql语句如下:
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
为了操作方便,你也可以使用Navicat等软件,进行可视化操作来创建数据库。
2、创建表:
sql语句如下:
CREATE TABLE images (id VARCHAR(255) PRIMARY KEY, url VARCHAR(255) NULL,
title VARCHAR(255) NULL, thumb VARCHAR(255) NULL)
3、增:
Python 3.7代码如下 :
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# universal format for inserting data
import pymysql
db = pymysql.connect(host='localhost', user='root', password='root', port=3306, db='spiders')
cursor = db.cursor()
data = {
'id': '1800271038',
'name': 'gmn',
'age': 25
}
table = 'students'
keys = ','.join(data.keys())
print(type(keys))
print(keys)
values = ','.join(['%s'] * len(data))
print(type(values))
print(values)
sql = 'INSERT INTO {table}({keys}) VALUES ({values})'.format(table=table, keys=keys, values=values)
try:
if cursor.execute(sql, tuple(data.values())):
print('Successful')
db.commit()
except:
print('Failed')
db.rollback()
db.close()