兼职日志-mysqlpython出图

背景

1、win安装mysql
安装包https://downloads.mysql.com/archives/installer/
安装步骤https://blog.csdn.net/mumiandeci/article/details/134520684
数据库连接工具https://www.hexhub.cn/CREATE DATABASE IF NOT EXISTS database_name CHARACTER SET utf8mb4 
COLLATE utf8mb4_unicode_ci;DROP TABLE IF EXISTS `spatial_database_nationwide`;
CREATE TABLE `spatial_database_nationwide` (
`id` INT NOT NULL AUTO_INCREMENT COMMENT '全国河流水文站坐标_全
国',`name` varchar(255) CHARACTER SET utf8mb4 COLLATE 
utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '水文站名字',
`point` point NULL COMMENT '存储点数据',PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 63 CHARACTER SET = utf8mb4 
COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

1、将四川水文Excel写入mysql空间数据库