Many of my programmers usually use phpmyadmin to import data or directly package the database in the directory, while phpmyadmin cannot import too much data. If SQL is not standard, it will not work.
Many of my programmers usually use phpmyadmin to import data or directly package the database in the directory, while phpmyadmin cannot import too much data. If SQL is not standard, it will not work.
Source cannot be used for importing SQL files that are too large and not in the standard format during Database Import.
The csdn data format is: User name # password # Each mailbox data is separated #
The SQL import statement is as follows:
| The Code is as follows: |
|
Mysql-> load data infile 'www.csdn.net.txt 'into table csdn-> fields terminated '#';
|
The username and password are separated by spaces.
Import Statement:
| The Code is as follows: |
|
Mysql-> load data infile 'renren.txt 'into table csdn-> fields terminated by 'T ';
|
The imported data may have spaces for reuse.
| The Code is as follows: |
|
Mysql-> update csdn set name = trim (name), passwd = trim (passwd), email = trim (email );
|
Remove Spaces