How to import data from text to MySQL

Access allows you to easily import data in text into tables. MySQL is not that easy to use, but it is also very easy to use.
First, separate data records by line to use specific characters, for example, ",".
The record format is as follows:
Aaa, BBB, CCC, DDD, eee
Fff, ggg, hhh, III, jjj, KKK
Create loaddate. php.
<? PHP
$ Hostname = "localhost ";
$ Username = "yourname ";
$ Password = "yourpwd ";
$ Dbname = "yourdb ";
Mysql_connect ($ hostname, $ username, $ password );
Mysql_select_db ("$ dbname ");
$ Mydate = file ("yourdate.txt ");
$ N = count ($ mydate );
For ($ I = 0; $ I <$ N; $ I ++ ){
$ Date = explode (",", $ mydate [$ I]);
$ STR = "insert into IP values ('$ date [0]', '$ date [1]', '$ date [2]', '$ date [3]', '$ date [4]') "; //
Mysql_query ($ Str );
}
Mysql_close ();
Echo "OK! ";
?>
Run loaddate.