mysql - 错误代码: 1064 You have an error in your SQL syntax (the new One)

Question

我从 MySQL 代码中收到此错误消息。但我不知道我的错在哪里..这是我的代码:

DELIMITER $$

USE `kp`$$

DROP PROCEDURE IF EXISTS `getAllUmurPegawai`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `getAllUmurPegawai`()

BEGIN

    DECLARE currdate INT;
    DECLARE birthdate INT;
    DECLARE numRows INT;
    DECLARE numIteration INT;
    DECLARE tempMonth INT;

    SET numRows = SELECT COUNT(*) FROM pegawai;
    SET numIteration = 1;
    WHILE numIteration <= numRows DO
        SET currdate = (SELECT EXTRACT(YEAR FROM CURRENT_DATE));    
        SET birthdate = (SELECT EXTRACT(YEAR FROM (SELECT TGL_LAHIR FROM pegawai WHERE INDEXING = numIteration)));
        SET umur = currdate - birthdate;
        SET tempMonth = SELECT EXTRACT(MONTH FROM (SELECT TGL_LAHIR FROM pegawai WHERE INDEXING = numIteration));
        IF umur < 56 THEN
            INSERT INTO pegawai(STATUS_PEGAWAI,BULAN_PENSIUN(JIKA_SUDAH)) VALUES('Belum Pensiun',0);
        ELSE
            INSERT INTO pegawai(STATUS_PEGAWAI,BULAN_PENSIUN(JIKA_SUDAH)) VALUES('Pensiun',tempMonth);
        END IF;
        SET numIteration = numIteration + 1;
    END WHILE;  
END$$
DELIMITER ;

我收到此错误消息:

Query : CREATE DEFINER=`root`@`localhost` PROCEDURE `getAllUmurPegawai`() BEGIN DECLARE currdate INT; DECLARE birthdate INT; DECLARE num...

Error Code : 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 'SELECT COUNT(*) FROM pegawai;
SET numIteration = 1;

WHILE numIteration <= numR' at line 8

我该如何解决这个问题？最佳答案将不胜感激:))

Answer 1

要使用 SELECT 查询作为表达式，您必须将其放在括号中:

SET numRows = (SELECT COUNT(*) FROM pegawai);

您在设置 currDate 和 birthdate 时做得正确，但您忘记了这一行中的括号。