MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Insert data based on one datetime
Posted by: Ebolisa Tech
Date: October 20, 2021 06:16AM

Hi,

Below is a data subtracted from a log file. I'd like to insert the username and the UTC date but only one record per datetime. The UTC has milliseconds and it's multiplicating its inputs data.

How do I filter it?

TIA

'597', 'washup', '2021-10-11 13:02:14', '2021-10-11 12:49:37.571000'
'617', 'emilio', '2021-10-11 14:26:41', '2021-10-11 12:49:37.000000'
'619', 'washup', '2021-10-20 14:00:11', '2021-10-20 07:05:40.056000'
'620', 'washup', '2021-10-20 14:00:11', '2021-10-20 07:05:40.101000'
'621', 'washup', '2021-10-20 14:00:11', '2021-10-20 07:05:40.121000'
'622', 'washup', '2021-10-20 14:00:11', '2021-10-20 07:05:40.144000'
'623', 'washup', '2021-10-20 14:00:11', '2021-10-20 07:05:40.221000'
'624', 'washup', '2021-10-20 14:00:11', '2021-10-20 07:05:40.253000'
'625', 'washup', '2021-10-20 14:00:11', '2021-10-20 07:05:40.596000'

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Insert data based on one datetime
Ebolisa Tech
October 20, 2021 06:16AM
Re: Insert data based on one datetime
Peter Brawley
October 20, 2021 10:00AM
Re: Insert data based on one datetime
Ebolisa Tech
October 20, 2021 10:33AM
Re: Insert data based on one datetime
Peter Brawley
October 20, 2021 11:43AM
Re: Insert data based on one datetime
Ebolisa Tech
October 20, 2021 12:44PM


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.