更新时间:2023-11-29 07:59:22
将计数选择为变量,然后在比较中使用.
Select the count into a variable and then use that in the comparison.
DECLARE total_row INT DEFAULT 0
START TRANSACTION;
INSERT INTO fields (field_name, control_type_id, needs_approval)
VALUES ('Array Photos', 3, 0);
SELECT count(job_type_name) FROM job_types WHERE job_type_name = 'Cash' INTO total_rows;
IF total_rows =2 THEN
ROLLBACK;
ELSE
INSERT INTO field_to_job_type (field_id, job_type_id, sequence_number, parent_id)
VALUES (last_insert_id(), (SELECT job_type_id FROM job_types WHERE job_type_name = 'Cash'), 1, (SELECT field_id FROM fields where field_name = 'Photo Pack'));
COMMIT;
END IF;