[INSERT 1 ROW AFTER 00h:00m:00s]
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!!!!
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.