youngchen12的博客

把某一个字段里的数据按照分隔符拆分成多数据SELECT t.*, substring_index( substring_index( t.DeptSecondName, '、', b.help_topic_id + 1 ), '、',- 1) AS curriculumFROM tb_subsidyproject t JOIN mysql.help_topic b O...

先在查询工具里查一下版本select version(), @@sql_mode;再执行以下语句set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERR..

先创建一个测试表CREATE TABLE `test` ( `id` int NOT NULL, `num` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `coun` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `sit` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB ...