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