How can we track events result in mysql?

100
December 30, 2018, at 07:20 AM

I setup some queries in stored procedures to run in the event scheduler using CREATE EVENT.Is there any way to find the result of queries or get errors? For example in the stored procedure, there is a INSERT INTO SELECT statement, event will run on time but because of a deadlock or a foreign key issue, the query (INSERT INTO SELECT) has been failed and i have now way to track the result.

LAST QUESTIONS
All questions
Rent Charter Buses Company
POPULAR ONLINE
jQuery Categories

JQuery animations and AngularJS

How to run Laravel project in PhpStorm?

A formula to find prime numbers in a loop

How to create a “parental control layer” feature in android?

CSP block google translate

READ ALSO
how to Replace date with mysql query
MySQL

how to Replace date with mysql query

I need a MySQL request to replace the DATE data typeBut when I use where this query doesn't work

 129
How to update & delete records using Perl Net::MySQL
MySQL

How to update & delete records using Perl Net::MySQL

I am spending time trying to get Net:MySQL to work for my database needs but am having trouble finding tutorials on the internet

 137
How to write the query to accept the input from the search box and search from MySql db (Wordpress)
MySQL

How to write the query to accept the input from the search box and search from MySql db (Wordpress)

I'm trying to access data from local wamp server from a Wordpress site using a Search boxI created the search box using the function get_search_form(), and I am unable to write a query in php to access using the same

 122
How to use wildcard search in FIND_IN_SET() mysql?
MySQL

How to use wildcard search in FIND_IN_SET() mysql?

I have a stored procedure I want to use Wildcard search in FIND_IN_SET

 113