注:本文所用到的版本
MySql 8.0.28
SpringBoot 2.7.2
准备工作 :建表 、pom.xml导入依赖 、application.yml 配置
- 建表
``mysql
rna
CREATE TABLE(
idint NOT NULL AUTO_INCREMENT,
namevarchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
card_imgvarchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
cardvarchar(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
sexvarchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
phonevarchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
check` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,