mysql - 过程查询中的多个 INTO

Question

是否可以在一个过程中将多个 INTO 添加到一个查询中以将值写入变量。我试图做以下事情，但它不起作用。

CREATE PROCEDURE slave (IN lat double, IN lon double, OUT var_procId BIGINT, OUT lati BIGINT)
BEGIN
    SELECT id INTO var_procId, Locations.latitude into lati  FROM Locations WHERE latitude=lat AND longitude=lon LIMIT 1;
END;

标签： mysqlprocedure

Answer 1

只需按照您要使用的顺序使用它，如下所示

CREATE PROCEDURE slave (IN lat double, IN lon double, OUT var_procId BIGINT, OUT lati BIGINT)
BEGIN
    SELECT id, Locations.latitude into  var_procId, lati  FROM Locations WHERE latitude=lat AND longitude=lon LIMIT 1;
END;