MySQL Stored Procedure Runs Successfully but does not execute the mysql query

Asked Oct 19 '16 at 14:28

Active Oct 20 '16 at 06:41

Viewed 772 times

DELIMITER $$
   CREATE PROCEDURE sdmLoggingSystem()
   BEGIN
   INSERT IGNORE INTO `databasename`.`tablename`
  (`stringval1`, `numericValue2`,`datetime`)
   values("AA",23,now());
END $$
DELIMITER ;

The above MySQL Stored Procedure runs successfully, but it does not insert the data into the table, But when I run the mysql query separately, it does insert into the table. Is there anything wrong in the code that I cannot see?

edited Oct 20 '16 at 06:41

Mike Lischke

48,925
16
119
181

asked Oct 19 '16 at 14:28

Manam

is there autocommit mode for both cases? – Sergiy Tytarenko Oct 19 '16 at 14:30
no there is autocommit. – Manam Oct 19 '16 at 14:53
try without IGNORE and check any errors reported. – Sergiy Tytarenko Oct 19 '16 at 14:55
tried it, but it does not work with without IGNORE aswell – Manam Oct 19 '16 at 14:56
most likely you have different conditions inside stored procedure and have to see the error. Please check the following link: https://dev.mysql.com/doc/refman/5.6/en/get-diagnostics.html – Sergiy Tytarenko Oct 19 '16 at 15:01

MySQL Stored Procedure Runs Successfully but does not execute the mysql query

0 Answers0