Error in IF statement in MySQL

[Jassim Rahma]

Hi, I am wondering why I am getting error when running below simple IF in MySQL?

IF NOT EXISTS (SELECT employee_attendance_id FROM employee_attendance WHERE employee_number = 10 AND attendance_date_time = '2015-10-11 13:14:16') THEN
BEGIN
INSERT IGNORE INTO employee_attendance (employee_number, attendance_date_time) VALUES (10, '2015-10-11 13:14:16');
END;
END IF;

This is the error I am getting:

[SQL] IF NOT EXISTS (SELECT employee_attendance_id FROM employee_attendance WHERE employee_number = 10 AND attendance_date_time = '2015-10-11 13:14:16') THEN
BEGIN
INSERT IGNORE INTO employee_attendance (employee_number, attendance_date_time) VALUES (10, '2015-10-11 13:14:16');
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS (SELECT employee_attendance_id FROM employee_attendance WHERE empl' at line 1

Thanks, Jassim[^]

Technology News @ www.JassimRahma.com

[Lost User]

..probably because you are showing a query for SQL Server. The error says to look up the correct syntax[^].

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

[Wombaticus]

Apart from what Eddy Vluggen said, you might want to look up MySQL's REPLACE[^] and/or INSERT ... ON DUPLICATE KEY UPDATE[^] syntax as an alternative way to achieve your goal.