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
,