14,953
edits
SQL syntax debug: Difference between revisions
Jump to navigation
Jump to search
m
→Approach 4: Compare the row counts between source table with target table
Tags: Mobile edit Mobile web edit |
|||
| Line 30: | Line 30: | ||
SET @cnt_source := 31; | SET @cnt_source := 31; | ||
SET @cnt_target := 25; | SET @cnt_target := 25; | ||
SELECT IF(@cnt_source <> @cnt_target, @cnt_error := @cnt_error + 1, ''); | SELECT IF(@cnt_source <> @cnt_target, @cnt_error := @cnt_error + 1, ''); | ||
SELECT IF(@cnt_source <> @cnt_target, @message := CONCAT(@message, 'some problem!', '\r'), ''); | SELECT IF(@cnt_source <> @cnt_target, @message := CONCAT(@message, 'some problem!', '\r'), ''); | ||