Stack Overflow
Stack Overflow

Questions tagged [mysql-event]

The MySQL Event Scheduler manages the scheduling and execution of events: Tasks that run according to schedule. Event support was added in MySQL 5.1.6.

The MySQL Event Scheduler manages the scheduling and execution of events: Tasks that run according to schedule. Event support was added in MySQL 5.1.6.

163 questions
1
vote
1 answer

What will happen to running event if i turn off global event_scheduler to off

Suppose I have a event in mysql named event_data and that calls a stored proceduce data_sp. event_data is triggered and data_sp is currently running. Now I am doing SET GLOBAL event_scheduler = OFF; - basically turning off global event scheduler.…
Akshay
  • 3,558
  • 4
  • 43
  • 77
1
vote
1 answer

Schedule MySQL query every 24 hours; query table and store results in another table

I need this query: SELECT ItemID, Price FROM table WHERE ItemID = %d GROUP BY Price ORDER BY COUNT(*) DESC LIMIT 1 -run once a day, and have the results from it stored in another table with the time stamp of the…
Kreation
  • 327
  • 3
  • 10
1
vote
1 answer

MySql Event Creation giving me Syntax Error

I want to create an Event that will run each day at midnight + 1 second, I've check a lot of threads explaining the Event and all yet I don't understand why I have an Syntax error in MySql V.6.2 CREATE EVENT TestEvents ON SCHEDULE EVERY 1 DAY …
Sam
  • 85
  • 3
  • 16
1
vote
1 answer

SELECT * FROM mysql.event showing different start time

While creating an event in mysql, I have schedule defined as follows: ON SCHEDULE EVERY 1 DAY STARTS '2014-08-08 00:00:00' However, when I ran the following query: SELECT * FROM mysql.event; I saw the following output: I am wondering why the…
John
  • 1,210
  • 5
  • 23
  • 51
1
vote
1 answer

Some system for timer

i'm working on something like the auction, and when the user creates the lot, he need to set the time of it duration. When this time ends i need to close the auction for this lot, and choose the last bid for the deal. What is the best practice for…
Cawa
  • 1,269
  • 3
  • 25
  • 44
1
vote
1 answer

creating weekly scheduled event in mysql

error #1064 in the event what wrong i m doing please suggest me some good tutorials, current following mysql docs #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to…
Bipin Chandra Tripathi
  • 2,550
  • 4
  • 28
  • 45
0
votes
1 answer

Mysql Event to run on every sunday every 1 hour

I'm to new to mysql event scheduling and want to schedule a task which should run on every sunday internal of 1 hour. Can any one help with this ? CREATE EVENT event_forEverysundayeveryhour ON SCHEDULE EVERY 1 Week STARTS CURRENT_DATE + INTERVAL (6…
LATIF CHAUDHARY
  • 3
  • 3
0
votes
1 answer

Writing a While Loops with Events in MySQL

I want to write a While Loop with Events in MySQL. After searching the internet, unfortunately, i didn't find something like this. However, i don't want to write it using procedures. CREATE DEFINER=`root`@`localhost` EVENT `try` ON SCHEDULE EVERY 1…
hakankumas
  • 23
  • 7
0
votes
0 answers

What should I grant user who wants to view events?

There's a user who wants to view events, but what I know is that grant event will allow him to alter, drop, or create events and I don't want this to happen. Is there any way to grant a user only allowing them to view events? Btw, sorry with my bad…
Luke J
  • 3
  • 2
0
votes
0 answers

how many events can be created with mysql events?

i have many recurring data-centric tasks that i want to use mysql events. I am wondering how many events? thanks.
webdeveloper
  • 27
  • 5
0
votes
0 answers

Best way to write MySQL Events to run after every second if previous run is completed?

I have a stored procedure which picks (nu-processed) one row from a table and do the processing of the data and then mark that as processed. I am calling this stored procedure from MySQL Events/Job and I have selected the schedule of this as every…
Rabeel Javed
  • 1
  • 1
0
votes
1 answer

How to enable Mysql Event Scheduler in Google Cloud SQL?

I have a somewhat restricted access to a Mysql instance in Google Cloud. There, I need to run two scheduled events (call a procedure) every few minutes and once a day at a fixed time. However, I am unable to enable the event scheduler, nor could the…
chilli10
  • 54
  • 1
  • 9
0
votes
1 answer

Does a MySQL backup save custom functions, events, and queries?

I successfully did a backup of my database, dropped the DB in workbench and created a new one, and attempted to restore it. First, it didn’t restore until I ran the creation of a custom function first (which is something I use in multiple views),…
angryteacup
  • 1
0
votes
1 answer

MariaDB Exception Invalid utf8mb3 character string: 'ACED00'

I am writing a native query and keep getting the "Invalid utf8mb3 character string: 'ACED00'" error. Here is my query @Query(value = "select " + "(case when bh.type in :writeOff then 'WRITE_OFF' " + "when bh.type in…
Elen Mouradian
  • 475
  • 1
  • 8
  • 13
0
votes
1 answer

@rodrigogs/mysql-events with phpmytadmin5 shows TypeError [ERR_UNKNOWN_ENCODING]: Unknown encoding: utf8mb3

Hi everyone I'm facing an issue with using NodeJS MySQL event and PHPMyAdmin and I keep getting this error TypeError [ERR_UNKNOWN_ENCODING]: Unknown encoding: utf8mb3 and its really frustrating I tried many things but so far no result. const mysql =…
rawand feryad
  • 33
  • 1
  • 3
  • 11
1 2 3
…
10 11