UNIX for Dummies Questions & Answers

I have hundreds of small files in csv format. I want to read them one at a time, insert the data into a table and then delete it.

data1 to data999.txt files needs to be read and data to be added to a table.

mysql -e"LOAD DATA INFILE 'data1.txt' INTO TABLE my_table;"
if echo $? = 0 then rm data1.txt
LOAD DATA INFILE 'data2.txt' INTO TABLE my_table;
if echo $? = 0 then rm data2.txt
LOAD DATA INFILE 'data999.txt' INTO TABLE my_table;
if echo $? = 0 then rm data999.txt

Is it possible?

this won't work..

Code:

if echo $? = 0 then rm data2.txt

try it in this way..

Code:

if [ $? -eq 0 ];then
rm data2.txt
fi