mysql - 排序时MySQL触发变量错误

Question

我有下一个无法解决的代码。

行 Set @Numero=... 返回错误

  Begin
Declare @Numero INT;
SET @Numero= SELECT id from visita where cliente_id=OLD.cliente_Id order by id desc limit 1;


INSERT INTO HistoricoMaquina
    SET
    Precio=OLD.Precio,
    fecha = NOW(),
    Visita_Id=@Numero;
End;

我努力了

select @Numero=Id from visita where cliente_id=1 order by id desc limit 1;

还

select @Numero=Id from visita where cliente_id=1 order by id desc limit 1;

但它们都不起作用，有什么想法吗？

标签： mysqltriggers

Answer 1

如果您的 Select 查询给出答案，则此方法有效

INSERT INTO HistoricoMaquina (Precio,fecha,Visita_Id) 
 SELECT OLD.Precio, NOw(),id from visita where cliente_id=OLD.cliente_Id order by id desc limit 1;