The MySQL server is running with the --secure-file-priv option so it cannot execute this statement. I tried to modify Priv apps xdating I was able to get data to load after getting adjusting per the advice from [a] the person that answered my question in a comment, but I started having trouble loading time string data to a table.
You appear to have a few issues going on here and to resolve you can make a few adjustments to get your data to Priv apps xdating without error.
I've source referenced and quoted the items in more detail below so you can read up on each for a more thorough explanation. LOCAL works only if your server and your client both have been configured to permit it. If LOCAL is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full path name to specify its exact location. If given as a relative path name, the name is interpreted relative to the directory in which the client
Priv apps xdating was started.
MySQL recognizes the escape sequences shown in Table 9. For all other escape sequences, backslash is ignored.
Questions Tags Users Badges Unanswered. Load csv file to mysql. Pimp Juice IT 1, 6 I can load the data using 2. I ran into another problem.
I cant load the time into mysql.
Please see the second part of the above question. Yes, the date and time is on separate columns.