Python中mysql查询重复数据并删除重复数据

#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'),