MySQL插入数据Where条件_mysql 自定义字段值,怎么加入where条件-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_28019809/article/details/121752327

本文介绍了MySQL中如何带条件地插入数据，包括检查数据是否存在、字段值判断和数据量判断三种情况。提供了具体的SQL语句示例，帮助读者理解并实现有条件的数据插入操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MySQL带条件的插入

一、是否存在数据

INSERT INTO table(field1, field2, fieldn) SELECT ‘field1’, ‘field2’, ‘fieldn’ FROM DUAL WHERE NOT EXISTS(SELECT field FROM table WHERE field = ?)

二、字段值判断

INSERT INTO tb_cloud_laborun (id, laborun_code, laborun_name, laborun_addr, laborun_credit_code, laborun_kind, laborun_type, laborun_kind_name, laborun_type_name, laborun_status, laborun_level, establish_time, build_way, parent_laborun_name, parent_laborun_code, administrat_name, administrat_code, legal_person_flag, laborun_legal_person, principal, principal_phone, congress_date, congress_expire, review_flag, women_flag, congress_regime, work_open, race, bookroom, bookroom_date, books, site_flag, sub_laborun_nums, laborun_team_nums, approval_doc_no, approval_doc_date, approval_unit, level, is_leaf, sort, is_deleted, remark, create_time, update_time, level_code, current_level_code, is_tax, unit_type, workers, peasant_workers, is_consummate, unit_name, is_laborun) SELECT ‘1309068612606226432’, ‘140305030012’, ‘矿区西城影院工会委员会’, NULL, NULL, NULL, ‘1’, NULL, NULL, ‘1’, ‘3’, ‘2020-09-24 17:54:13’, NULL, ‘矿区总工会’, ‘140305020000’, NULL, ‘0’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ‘3’, ‘0’, NULL, ‘0’, NULL, ‘2020-09-24 17:54:13’, NULL, ‘3’, ‘001003012’, ‘0’, NULL, NULL, NULL, ‘1’, ‘矿区西城影院’, ‘1’ FROM DUAL WHERE NOT EXISTS(SELECT t.* FROM tb_cloud_laborun WHERE id = ‘1309068612606226432’ or laborun_code=‘140305030012’)；

三、数据量判断

INSERT INTO hunting_intrude (
id,
uid,
intrudeId,
limitJob,
endTime,
buffSuitId
) SELECT
8,
1,
1,
1,
‘2022-1-1 00:00:01’,
1
FROM
DUAL
WHERE
(
SELECT
count(*)
FROM
hunting_intrude
WHERE
uid = 1
) < 5