I need help solving a problem,
Code:
DELIMITER $$
create procedure sp_ptopedido( TPOMEDIOREPOS int, DEMANDA int, ESTOQUEMINIMO int),
begin
PONTOPEDIDOTOPEDIDO = ((TPOMEDIOREPOS / 30) * DEMANDA) + ESTOQUEMINIMO FROM produto;
END $$
DELIMITER ;
I get this error when executing the command:
SQL command:
create procedure sp_ptopedido( TPOMEDIOREPOS int, DEMANDA int, ESTOQUEMINIMO int),
begin
PTOPEDIDO = ((TPOMEDIOREPOS / 30) * DEMANDA) + ESTOQUEMINIMO FROM produto;
END
MySQL Messages: Documentation
# 1064 - You have an error in your SQL syntax; check the manual that correspond to your MariaDB server version for the right syntax to use near 'begin
PTOPEDIDO = ((TPOMEDIOREPOS / 30) * DEMANDA) + ESTOQUEMINIMO ' at line 1