Mysql Procedure Syntax error on Update

Question

DELIMITER //

DROP PROCEDURE IF EXISTS pad_fato_to_tad_fato//


CREATE PROCEDURE pad_fato_to_tad_fato(IN IDFATO BIGINT, IN UCI BIGINT)

BEGIN
  INSERT INTO tad_fato (FAT_UCI, FAT_DESCRICAO,   
                        FAT_DATA_CIENCIA_AUTORIDADE, 
                        FAT_CADASTRANTE, FAT_DATA_CAD) 
   SELECT FAT_UCI, FAT_DESCRICAO, FAT_DATA_CIENCIA_AUTORIDADE, 
      FAT_CADASTRANTE, FAT_DATA_CAD 
   FROM pad_fato WHERE (FAT_ID = IDFATO);
END//

BEGIN
  UPDATE tad_termo_de_ajustamento SET TAD_STATUS_ID="2" WHERE (TAD_FK_PRE_UCI = UCI);
END//

DELIMITER ;

Error (12,1): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near UPDATE tad_termo_de_ajustamento SET TAD_STATUS_ID="2" WHERE (TAD_FK_PRE_UCI=UCI) at line 2

VirCom · Accepted Answer · 2017-06-07 12:50:29Z

2

You have double "END" word after each query. And not pretty formatted code :)

DELIMITER //

DROP PROCEDURE IF EXISTS pad_fato_to_tad_fato//

CREATE PROCEDURE pad_fato_to_tad_fato(IN IDFATO BIGINT, IN UCI BIGINT)

BEGIN
    INSERT INTO tad_fato (
        FAT_UCI,FAT_DESCRICAO,
        FAT_DATA_CIENCIA_AUTORIDADE,
        FAT_CADASTRANTE,FAT_DATA_CAD
    )
    SELECT
        FAT_UCI,
        FAT_DESCRICAO,
        FAT_DATA_CIENCIA_AUTORIDADE,
        FAT_CADASTRANTE,
        FAT_DATA_CAD
    FROM pad_fato
    WHERE (FAT_ID=IDFATO);

    UPDATE tad_termo_de_ajustamento
    SET
        TAD_STATUS_ID="2"
    WHERE (TAD_FK_PRE_UCI=UCI);
END//

DELIMITER ;

answered Jun 7, 2017 at 12:50

VirCom

3,6421 gold badge12 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kin Over a year ago

Nice! tks dude!! Work´s fine!

Collectives™ on Stack Overflow

Mysql Procedure Syntax error on Update

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related