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.

Rent Charter Buses Company
READ ALSO
how to Replace date with mysql query

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

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)

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?

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