If you check out the various forum postings that discuss connectivity issues around the LOAD DATA statement, you’ll find that in many cases, people responding to a post suggest the use of the LOCAL option as a simple workaround to the various challenges. Not only are the MySQL connectivity requirements more complicated without it, but they are also not well documented, adding to the frustration should you run into any glitches. Connectivity is typically much easier to establish when you use the LOCAL option.įor the examples in this article, I have used the LOCAL option. The LOCAL option also works if the client and MySQL are on the same machine, which is the approach I’ve taken for this article. The client reads the file and sends the content to the server, where it is stored in a temporary file until it is loaded into the target table for processing.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |