Databases Reference
In-Depth Information
Usage of the LOCAL modiier in LOAD DATA LOCAL INFILE must be allowed by the
MySQL server and MySQL's client library used by PHP.
Both the LOAD methods are available from the phpMyAdmin LOAD interface, which
tries to choose the best possible default option.
Using the LOAD DATA interface
We select Import from the author table menu. Choosing CSV using LOAD DATA
option brings up the following dialog:
The available options have already been covered
in the CSV section.
In the File to import section, we choose our author.csv ile.
Finally, we can choose the LOAD method, as discussed earlier, by selecting the Use
LOCAL keyword option. We then click on Go .
 
Search WWH ::




Custom Search