[root@samba1 /root]# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 76 to server version: 3.23.32

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> load data local infile "/root/dataload.txt" into table sales (seller,location,buyer,price,closing_date);
Query OK, 2 rows affected (0.03 sec)
Records: 2  Deleted: 0  Skipped: 0  Warnings: 0

mysql> 

Gregory	322 Blues Alley	Jim Smith	200000	2000-12-12
Grisham Fred	546 N. 7th St.	Al Jones	144000	2001-2-4