utf8mb4 COLLATE utf8mb4_0900_ai_ci是什么意思

utf8mb4 COLLATE utf8mb4_0900_ai_ci是一种字符集和排序规则的组合。其中，utf8mb4是一种字符集，每个字符最多占4个字节，可以存储更多的Unicode字符。而utf8mb4_0900_ai_ci则是一种排序规则，它表示不区分大小写（case insensitivity）和不区分重音符号（accent insensitivity），适用于多种语言的排序 。

相关问题

帮我生成20条下面这个表的测试数据 CREATE TABLE `t_defind_ent_demand_report` ( `ID_` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键', `ENT_NAME_` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '企业名称', `RESPONSIBLE_PERSON_` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '负责人', `TELEPHONE_` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话', `REPORT_TYPE_` tinyint NULL DEFAULT NULL COMMENT '上报类型', `GARDEN_ID_` int NULL DEFAULT NULL COMMENT '所属园区id', `SPACE_TYPE_` tinyint NULL DEFAULT NULL COMMENT '空间类型', `AREA_` tinyint NULL DEFAULT NULL COMMENT '面积', `AMONT_` tinyint NULL DEFAULT NULL COMMENT '金额', `DESCRIPTION_` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '具体描述', `FILE_ID_` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '附件id', `DEL_FLAG` tinyint NULL DEFAULT NULL COMMENT '(0未删除;1删除)', `CREATE_TIME_` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建时间', `CREATE_USER_` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `LAST_UPDATE_TIME_` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改时间', `LAST_UPDATE_USER_` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '企业需求上报' ROW_FORMAT = Dynamic;

Sure, here are 20 sample data entries for the table t_defind_ent_demand_report:

1. ID_: 123456789abcdefghij, ENT_NAME_: ABC Inc., RESPONSIBLE_PERSON_: John Doe, TELEPHONE_: 1234567890, REPORT_TYPE_: 1, GARDEN_ID_: 1234, SPACE_TYPE_: 2, AREA_: 3, AMONT_: 4, DESCRIPTION_: This is a test description, FILE_ID_: abcdefghijklmnopqr, DEL_FLAG: 0, CREATE_TIME_: 2022-01-01 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-01 00:00:00, LAST_UPDATE_USER_: John Smith
2. ID_: 23456789abcdefghij123, ENT_NAME_: XYZ Corp., RESPONSIBLE_PERSON_: Jane Smith, TELEPHONE_: 2345678901, REPORT_TYPE_: 2, GARDEN_ID_: 2345, SPACE_TYPE_: 3, AREA_: 4, AMONT_: 5, DESCRIPTION_: This is another test description, FILE_ID_: bcdefghijklmnopqrs, DEL_FLAG: 0, CREATE_TIME_: 2022-01-02 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-02 00:00:00, LAST_UPDATE_USER_: Jane Doe
3. ID_: 3456789abcdefghij1234, ENT_NAME_: PQR Ltd., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 3456789012, REPORT_TYPE_: 1, GARDEN_ID_: 3456, SPACE_TYPE_: 1, AREA_: 2, AMONT_: 3, DESCRIPTION_: This is yet another test description, FILE_ID_: cdefghijklmnopqrst, DEL_FLAG: 0, CREATE_TIME_: 2022-01-03 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-03 00:00:00, LAST_UPDATE_USER_: John Smith
4. ID_: 456789abcdefghij12345, ENT_NAME_: LMN Inc., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 4567890123, REPORT_TYPE_: 2, GARDEN_ID_: 4567, SPACE_TYPE_: 2, AREA_: 3, AMONT_: 4, DESCRIPTION_: This is just a test description, FILE_ID_: defghijklmnopqrstu, DEL_FLAG: 0, CREATE_TIME_: 2022-01-04 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-04 00:00:00, LAST_UPDATE_USER_: Jane Doe
5. ID_: 56789abcdefghij123456, ENT_NAME_: GHI Corp., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 5678901234, REPORT_TYPE_: 1, GARDEN_ID_: 5678, SPACE_TYPE_: 3, AREA_: 4, AMONT_: 5, DESCRIPTION_: This is a sample description, FILE_ID_: efghijklmnopqrstuv, DEL_FLAG: 0, CREATE_TIME_: 2022-01-05 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-05 00:00:00, LAST_UPDATE_USER_: John Smith
6. ID_: 6789abcdefghij1234567, ENT_NAME_: QRS Ltd., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 6789012345, REPORT_TYPE_: 2, GARDEN_ID_: 6789, SPACE_TYPE_: 1, AREA_: 2, AMONT_: 3, DESCRIPTION_: This is a test description only, FILE_ID_: fghijklmnopqrstuvw, DEL_FLAG: 0, CREATE_TIME_: 2022-01-06 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-06 00:00:00, LAST_UPDATE_USER_: Jane Doe
7. ID_: 789abcdefghij12345678, ENT_NAME_: UVW Inc., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 7890123456, REPORT_TYPE_: 1, GARDEN_ID_: 7890, SPACE_TYPE_: 2, AREA_: 3, AMONT_: 4, DESCRIPTION_: This is just a sample description, FILE_ID_: ghijklmnopqrstuvwx, DEL_FLAG: 0, CREATE_TIME_: 2022-01-07 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-07 00:00:00, LAST_UPDATE_USER_: John Smith
8. ID_: 89abcdefghij123456789, ENT_NAME_: STU Corp., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 8901234567, REPORT_TYPE_: 2, GARDEN_ID_: 8901, SPACE_TYPE_: 3, AREA_: 4, AMONT_: 5, DESCRIPTION_: This is a description for testing, FILE_ID_: hijklmnopqrstuvwxy, DEL_FLAG: 0, CREATE_TIME_: 2022-01-08 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-08 00:00:00, LAST_UPDATE_USER_: Jane Doe
9. ID_: 9abcdefghij1234567890, ENT_NAME_: NOP Ltd., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 9012345678, REPORT_TYPE_: 1, GARDEN_ID_: 9012, SPACE_TYPE_: 1, AREA_: 2, AMONT_: 3, DESCRIPTION_: This is a test description, FILE_ID_: ijklmnopqrstuvwxyza, DEL_FLAG: 0, CREATE_TIME_: 2022-01-09 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-09 00:00:00, LAST_UPDATE_USER_: John Smith
10. ID_: abcdefghij123456789, ENT_NAME_: QWE Inc., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 0123456789, REPORT_TYPE_: 2, GARDEN_ID_: 1234, SPACE_TYPE_: 2, AREA_: 3, AMONT_: 4, DESCRIPTION_: This is a test description, FILE_ID_: jklmnopqrstuvwxyzab, DEL_FLAG: 0, CREATE_TIME_: 2022-01-10 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-10 00:00:00, LAST_UPDATE_USER_: Jane Doe
11. ID_: bcdefghij123456789a, ENT_NAME_: ASD Ltd., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 1234567890, REPORT_TYPE_: 1, GARDEN_ID_: 2345, SPACE_TYPE_: 3, AREA_: 4, AMONT_: 5, DESCRIPTION_: This is a sample description, FILE_ID_: klmnopqrstuvwxyzabc, DEL_FLAG: 0, CREATE_TIME_: 2022-01-11 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-11 00:00:00, LAST_UPDATE_USER_: John Smith
12. ID_: cdefghij123456789ab, ENT_NAME_: ZXC Corp., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 2345678901, REPORT_TYPE_: 2, GARDEN_ID_: 3456, SPACE_TYPE_: 1, AREA_: 2, AMONT_: 3, DESCRIPTION_: This is just a sample description, FILE_ID_: lmnopqrstuvwxyzabcd, DEL_FLAG: 0, CREATE_TIME_: 2022-01-12 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-12 00:00:00, LAST_UPDATE_USER_: Jane Doe
13. ID_: defghij123456789abc, ENT_NAME_: FGH Inc., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 3456789012, REPORT_TYPE_: 1, GARDEN_ID_: 4567, SPACE_TYPE_: 2, AREA_: 3, AMONT_: 4, DESCRIPTION_: This is a test description only, FILE_ID_: mnopqrstuvwxyzabcde, DEL_FLAG: 0, CREATE_TIME_: 2022-01-13 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-13 00:00:00, LAST_UPDATE_USER_: John Smith
14. ID_: efghij123456789abcd, ENT_NAME_: JKL Ltd., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 4567890123, REPORT_TYPE_: 2, GARDEN_ID_: 5678, SPACE_TYPE_: 3, AREA_: 4, AMONT_: 5, DESCRIPTION_: This is a sample description, FILE_ID_: nopqrstuvwxyzabcdef, DEL_FLAG: 0, CREATE_TIME_: 2022-01-14 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-14 00:00:00, LAST_UPDATE_USER_: Jane Doe
15. ID_: fghij123456789abcde, ENT_NAME_: MNO Corp., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 5678901234, REPORT_TYPE_: 1, GARDEN_ID_: 6789, SPACE_TYPE_: 1, AREA_: 2, AMONT_: 3, DESCRIPTION_: This is a test description, FILE_ID_: opqrstuvwxyzabcdefg, DEL_FLAG: 0, CREATE_TIME_: 2022-01-15 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-15 00:00:00, LAST_UPDATE_USER_: John Smith
16. ID_: ghij123456789abcdef, ENT_NAME_: BCD Inc., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 6789012345, REPORT_TYPE_: 2, GARDEN_ID_: 7890, SPACE_TYPE_: 2, AREA_: 3, AMONT_: 4, DESCRIPTION_: This is just a sample description, FILE_ID_: pqrstuvwxyzabcdefgh, DEL_FLAG: 0, CREATE_TIME_: 2022-01-16 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-16 00:00:00, LAST_UPDATE_USER_: Jane Doe
17. ID_: hij123456789abcdefghi, ENT_NAME_: EFG Corp., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 7890123456, REPORT_TYPE_: 1, GARDEN_ID_: 8901, SPACE_TYPE_: 3, AREA_: 4, AMONT_: 5, DESCRIPTION_: This is a test description only, FILE_ID_: qrstuvwxyzabcdefghi, DEL_FLAG: 0, CREATE_TIME_: 2022-01-17 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-17 00:00:00, LAST_UPDATE_USER_: John Smith
18. ID_: ijk123456789abcdefghij, ENT_NAME_: HIJ Ltd., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 8901234567, REPORT_TYPE_: 2, GARDEN_ID_: 9012, SPACE_TYPE_: 1, AREA_: 2, AMONT_: 3, DESCRIPTION_: This is a sample description, FILE_ID_: rstuvwxyzabcdefghij, DEL_FLAG: 0, CREATE_TIME_: 2022-01-18 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-18 00:00:00, LAST_UPDATE_USER_: Jane Doe
19. ID_: jkl123456789abcdefghijk, ENT_NAME_: KLM Inc., RESPONSIBLE_PERSON_: John Smith, TELEPHONE_: 9012345678, REPORT_TYPE_: 1, GARDEN_ID_: 1234, SPACE_TYPE_: 2, AREA_: 3, AMONT_: 4, DESCRIPTION_: This is just a test description, FILE_ID_: stuvwxyzabcdefghijkl, DEL_FLAG: 0, CREATE_TIME_: 2022-01-19 00:00:00, CREATE_USER_: Jane Doe, LAST_UPDATE_TIME_: 2022-01-19 00:00:00, LAST_UPDATE_USER_: John Smith
20. ID_: klm123456789abcdefghijkl, ENT_NAME_: NOP Corp., RESPONSIBLE_PERSON_: Jane Doe, TELEPHONE_: 0123456789, REPORT_TYPE_: 2, GARDEN_ID_: 2345, SPACE_TYPE_: 3, AREA_: 4, AMONT_: 5, DESCRIPTION_: This is a sample description only, FILE_ID_: tuvwxyzabcdefghijklm, DEL_FLAG: 0, CREATE_TIME_: 2022-01-20 00:00:00, CREATE_USER_: John Smith, LAST_UPDATE_TIME_: 2022-01-20 00:00:00, LAST_UPDATE_USER_: Jane Doe

CREATE TABLE `tb_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '账号', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '姓名', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

这是一个创建名为 `tb_admin` 的表的 SQL 语句，表中包含了四个字段：`id`、`account`、`password` 和 `name`。其中 `id` 是主键，也是自动递增的。`account` 是账号，`password` 是密码，`name` 是姓名。这个表使用的存储引擎是 InnoDB，字符集为 utf8mb4，行格式为 Dynamic。