Multiply procedure

0

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
    
asked by anonymous 23.10.2016 / 17:56

0 answers