How can i add date as auto update when import data from csv file?

Question

I want to add date and time auto update. Can anyone help me how can i do this. i am importing data from csv file and there is no any field of date i want to auto update this field in database when each data inserted through csv file. please help

Hello and welcome to stackoverflow. Perhaps you should take some time to review your question in order to explain more clearly your problem and how you have tried to solve it until now. Once done, while waiting for answers you could take a look at http://stackoverflow.com/help/someone-answers to know what you should do when someone answer to your question. — Sylvain Leroux, Aug 06 '13 at 13:44

juergen d · Accepted Answer · 2013-08-06T12:46:01.603

1

Just add a NOW() for that field.

Or if you have two seperate columns for date and time then you can use the build-in functions CURDATE() and TIME().

Example:

LOAD DATA INFILE 'data.csv'
INTO TABLE t1
(column1, col2, col3)
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
SET date_time_field = NOW();

edited Aug 06 '13 at 12:46

answered Aug 06 '13 at 12:33

juergen d

201,996
37
293
362

how can i add NOW() after creating table? I didnt find any option for that in phpMyadmi – Sanjay Rathod Aug 06 '13 at 12:43
And i want auto increment date and time bro – Sanjay Rathod Aug 06 '13 at 12:57

score 0 · Answer 2 · answered Aug 03 '17 at 16:30

0

Sanjay Rathod --> UPDATE [yourTable] SET [yourDatetimeColumn] = NOW();

(see this post for more information.)

answered Aug 03 '17 at 16:30

jchleb

27
6

How can i add date as auto update when import data from csv file?

2 Answers2

Linked

Related