#coding:utf-8
import mysql.connector
mydb = mysql.connector.connect(
host='localhost',
user='root',
passwd='123456',
database='mydatabase',
buffered = True
)
print(mydb)
#1、创建数据库并插入数据:
mycursor = mydb.cursor()
sql = "insert into customers(name,address) values(%s,%s)"
val =("John","London 21")
mycursor.execute(sql,val)
mydb.commit()
print(mycursor.rowcount,"record inserted")
val2 = [
('Peter', 'Lowstreet 4'),
('Amy', 'Apple st 652'),
('Hannah', 'Mountain 21'),
('Michael', 'Valley 345'),
('Sandy', 'Ocean blvd 2'),
('Betty', 'Green Grass 1'),
('Richard', 'Sky st 331'),
('Susan', 'One way 98'),
('Vicky', 'Yellow Garden 2'),
('Ben', 'Park Lane 38'),
Python中mysql查询重复数据并删除重复数据
最新推荐文章于 2024-01-30 09:30:38 发布
本文介绍了如何在Python中利用MySQL数据库查询并删除重复的数据记录,重点在于数据的比较和清理策略。
摘要由CSDN通过智能技术生成