Shell Programming and Scripting

$ 
$ # show the table "emp" in the MySQL database "test"
$ mysql -e "desc emp" -u test -ptest test
+-------+---------------+------+-----+---------+-------+
| Field | Type          | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| empno | decimal(10,0) | YES  |     | NULL    |       |
| ename | varchar(20)   | YES  |     | NULL    |       |
| sal   | decimal(7,2)  | YES  |     | NULL    |       |
+-------+---------------+------+-----+---------+-------+
$ 
$ # see if it's empty
$ mysql -e "select count(*) from emp" -u test -ptest test
+----------+
| count(*) |
+----------+
|        0 |
+----------+
$ 
$ # It is. Now show the contents of my csv file
$ cat /tmp/emp.dat
1000,SCOTT,7987.25
2000,JAMES,3489.00
3000,DAVID,5520.75
4000,PETER,6789.01
$ 
$ # Now use the sqlimport program to load data into the emp table
$ mysqlimport -u root -proot --fields-terminated-by="," test "/tmp/emp.dat"
test.emp: Records: 4  Deleted: 0  Skipped: 0  Warnings: 0
$ 
$ # Verify the successful load
$ mysql -e "select * from emp" -u test -ptest test
+-------+-------+---------+
| empno | ename | sal     |
+-------+-------+---------+
|  1000 | SCOTT | 7987.25 |
|  2000 | JAMES | 3489.00 |
|  3000 | DAVID | 5520.75 |
|  4000 | PETER | 6789.01 |
+-------+-------+---------+
$ 
$