¿Cómo cargar datos de fecha en MySQL cuando se utilizan datos de carga?

How to load date data in MySQL when using load data?

The data file that I am trying load from has a date field that has the date in DD-MON-YY HH:MM:SS format. When I load this file using LOAD DATA command, the database gets confused and just makes all date entries to 0000-00-00 00:00:00 or NULL Here is the test I did using STR_TO_DATE option and it doesn’t work. Test infile (test_temp.csv)

The default date format of a date column is YYYY-MM-DD HH:MM:SS in MySQL. The data file that I am trying load from has a date field that has the date in DD-MON-YY HH:MM:SS format. When I load this file using LOAD DATA command, the database gets confused and just makes all date entries to 0000-00-00 00:00:00 or NULL

If the MySQL Debian-7 minimal cannot use local_infile, look around all the make files used for compiling to see if it is disabled by default or if local_infile is enabled for the Debian-7. If it still says ‘OFF’, then look deep within the compiler settings to enable it. If it sets to ‘ON’, you are OK.

In MySQL database (or MariaDB), using “load data infile” command, you can upload data from a text file to tables. The load data infile command provides several flexible options to load various formats of data from text file to tables. 1.

If you use the LOAD DATA INFILE command to populate a table with existing data, you will often find that the import fails due to duplicates. There are several possible ways to overcome this problem. If this option has been enabled in your server, it can be used to load a file that exists on the client computer rather than the server.

These rules determine the LOAD DATA input file location: If LOCAL is not specified, the file must be located on the server host. The server reads the file directly, locating it as follows: If the file name is an absolute path name, the server uses it as given.

The date in your data file is already in a format MySQL should natively understand. It’s just enclosed in double quotes. You need to tell LOAD DATA INFILE how to deal with the quotes. Try something like this: Since you’ve said it doesn’t work, I created a test table and verified that it does work.

The mysqlimport utility provides another way to load data files; it operates by sending a LOAD DATA statement to the server. See Section 4.5.5, “mysqlimport — A Data Import Program” .

If you are running LOAD DATA LOCAL INFILE from the windows shell, and you need to use OPTIONALLY ENCLOSED BY ‘”‘, you will have to do something like this in order to escape characters properly: “C://Program Files//MySQL//MySQL Server 5.6//bin//mysql” -u root –password=%password% -e “LOAD DATA LOCAL INFILE ‘!file!’ INTO TABLE !table!

You need to import it into a MySQL database DATE field named “my_dates”. A straight import will result in all your dates showing up as ‘0000-00-00’, because MySQL uses the format ‘Y-m-d’, and won’t translate it natively. Here’s the solution: Create a VARCHAR field named “my_text_dates” in the database, and import the dates there.

A straight import will result in all your dates showing up as ‘0000-00-00’, because MySQL uses the format ‘Y-m-d’, and won’t translate it natively. Create a VARCHAR field named “my_text_dates” in the database, and import the dates there. Then, just delete the “my_text_dates” field, and you’re all set!