weixin_45965693的博客

表格数据转csv格式导入 import mysql.connector #连接数据库 def dbConnect(db_host): db_user = 'root' db_pass = '12345%$#@!' db_name = 'pythondb' db_conn = mysql.connector.connect(user=db_user,password=db_pass,host=db_host,database=db_name) return db.

命令行pip install mysql-connector-python import mysql.connector # 密码修改成自己的 mysql_connection = mysql.connector.connect(user='root',password='12345%$#@!',host='localhost') cursor = mysql_connection.cursor() cursor.execute("CREATE DATABASE PythonDB") ###########

1.python pip库pymysql 2.创建test数据库 本地登陆 create database 3.连接 4.操作 参考https://www.bilibili.com/video/BV1bJ41137DJ/?spm_id_from=333.788.recommend_more_video.0 https://github.com/peiss/ant-learn-python/tree/master/2019-09-19%203分钟学会Python读写MySQL数据库 ...

本地登陆