如何在sql中查询已经存在的语句,并判断sql是否执行
// 在items_test_case_node_info插入数据,如果NOt EXISTS...为真( 不存在NOt EXISTS),则执行insert语句
<insert id="insertStoryInfoByStatus">
INSERT INTO
items_test_case_node_info
(project_id,story_id,name,level,isVaild)
SELECT
#{projectId},#{storyId},#{storyNameAndTitle},0,1
FROM
DUAL
WHERE
NOt EXISTS (SELECT * FROM items_test_case_node_info WHERE project_id=#{projectId} AND story_id=#{storyId} and parent_id is null);
</insert>