本文共 1129 字，大约阅读时间需要 3 分钟。

# -*- coding: utf-8 -*-"""Created on Tue Nov 10 10:48:28 2020@author: Administrator"""import mysql.connectormydb = mysql.connector.connect(  host="localhost",  user="root",  passwd="123456",  auth_plugin='mysql_native_password',  database="musicdatabase")print(mydb)mycursor = mydb.cursor()"""创建表第一次使用，后直接用即可mycursor.execute("CREATE DATABASE musicdatabase")""""""你已经成功地创建了一个表。mycursor.execute("CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))")mycursor.execute("ALTER TABLE customers ADD COLUMN id INT AUTO_INCREMENT PRIMARY KEY")""""""插入数据"""sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"val = [  ('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'),  ('William', 'Central st 954'),  ('Chuck', 'Main Road 989'),  ('Viola', 'Sideway 1633')]mycursor.executemany(sql, val)mydb.commit()print(mycursor.rowcount, " 条已经插入")mycursor.execute("SHOW TABLES")for x in mycursor:  print(x)

转载地址：https://blog.csdn.net/weixin_33595571/article/details/109596427 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！