MySQL Forums
Forum List  »  Newbie

[INSERT 1 ROW AFTER 00h:00m:00s]
Posted by: nguyen dinh
Date: July 10, 2020 03:28AM

Hello every one !!!
I have problem with mysql ! I want to INSERT 1 ROW AFTER 00:00:00 . i use event
and this is my querry:

use test ;// user datable name
create event daily on schedule every 1 day
do
insert into test.up(day,A,B,C) values(now(),%f,%f,%f)

But the mysql insert 1 row after 24h when the mysql start. Example i run mysql after 14h:00:00 7/10/2020 and the row insert at 14h:00:00 7/11/2020

How can I insert 1 row after 00:00:00
Thanks best for your time !! Sorry my bad english!!!!

Options: ReplyQuote


Subject
Written By
Posted
[INSERT 1 ROW AFTER 00h:00m:00s]
July 10, 2020 03:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.