mysql - IF 中的 SQL 变量存在

Question

我无法找出将查询输出分配给稍后可以在 INSERT 子句中使用的变量的正确方法。

我得到的错误是

ERROR 1064 (42000): 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 'SET @lennuid = (select lend_id from lend where sihtpunkt=in_kuhu AND kuupaev=in_' at line 8

我尝试查看有关 SQL 中变量的所有指南，但没有一个可以帮助我解决这个问题。

我使用以下代码:

CREATE PROCEDURE proov(
in_kuhu varchar(50), in_nimi1 varchar(50), in_nimi2 varchar(50), in_adre varchar(50), in_telo varchar(20), in_email varchar(100), in_date date)
BEGIN
DECLARE viga INTEGER DEFAULT 0 ;
DECLARE lennuid INT;
START TRANSACTION;
IF exists (
SET @lennuid = (select lend_id from lend where sihtpunkt=in_kuhu AND kuupaev=in_date)) THEN
INSERT INTO broneering
(lend_id, bron_aeg, eesnim, perenimi, aadress, telefon, email)
VALUES
(lennuid, NOW(), in_nimi1, in_nimi2, in_adre, in_telo, in_email);
ELSE
set viga=1;
SELECT 'Muudatus ebaonnestus ',viga;
END IF;
IF viga=0 then
COMMIT;
select 'korras';
ELSE
select 'tagasi';
ROLLBACK;
END IF;

Answer 1

THEN 导致问题。

IF exists (
SET @lennuid = (select lend_id from lend where sihtpunkt=in_kuhu AND kuupaev=in_date)) 
BEGIN  -- Instead of THEN use BEGIN , END
    INSERT INTO broneering
    (lend_id, bron_aeg, eesnim, perenimi, aadress, telefon, email)
    VALUES 
    (lennuid, NOW(), in_nimi1, in_nimi2, in_adre, in_telo, in_email);
END
ELSE
BEGIN
    set viga=1;
    SELECT 'Muudatus ebaonnestus ',viga;
END
END IF;