14,953
edits
SQL syntax debug: Difference between revisions
Jump to navigation
Jump to search
m
→Approach 4: Verify the row counts between source table with parsed table
No edit summary |
|||
| Line 45: | Line 45: | ||
SET @cnt_source := (SELECT COUNT(*) FROM `source_table`); | SET @cnt_source := (SELECT COUNT(*) FROM `source_table`); | ||
SET @cnt_target := (SELECT COUNT(*) FROM `parsed_table`); | SET @cnt_target := (SELECT COUNT(*) FROM `parsed_table`); | ||
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'), ''); | ||