Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Use LOAD DATA to load a file into a database other than the current one, you can qualify the table name with the database na

mysql> LOAD DATA LOCAL 'mytbl.txt' INTO TABLE other_db.mytbl;