TTJxLNx9

1Mysql 1064 error
2IF EXISTS (`emails3`) THEN
3    SELECT * INTO `emails3` 
4    FROM `emails1`;
5
6    SELECT * INTO `emails3` 
7    FROM `emails2` 
8    WHERE NOT `word` IN (SELECT `word` 
9                         FROM `emails1`) AND 
10          `word` NOT IN (SELECT `word` 
11                         FROM `emails3`);
12END IF;
13
14IF NOT EXISTS (`emails3`) THEN
15            CREATE TABLE `emails3` SELECT * FROM `emails1`;
16            SELECT * INTO `emails3` 
17            FROM `emails2` 
18            WHERE NOT `word` IN (SELECT `word` FROM `emails1`);
19END IF;
20
21TRUNCATE `emails1`;
22	
23DELIMITER | 
24Drop procedure if exists `backup_table`;
25CREATE PROCEDURE `backup_table` () 
26
27BEGIN 
28
29IF EXISTS (SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'test' AND table_name = 'emails3') THEN
30    INSERT INTO `emails3` SELECT * FROM `emails1`;
31    INSERT INTO `emails3` SELECT * FROM `emails2` 
32        WHERE NOT `word` IN (SELECT `word` FROM `emails1`) 
33             AND `word` NOT IN (SELECT `word` FROM `emails3`);
34END IF;
35
36END| 
37
38DELIMITER ;