loading data from a textfile into MySQL database

Greetings, I have a datafile called 'salary.txt', and it's a tab delimited file, the structure is like this: employee_namesalary employee_namesalary ... I have a table called 'salary', and it has the same structure as the 'salary.txt' --- employee_name & salary as the columns; I use the command

Newbie Q: loading data from a textfile into MySQL database

Greetings, I have a datafile called 'salary.txt', and it's a tab delimited file, the structure is like this: employee_namesalary employee_namesalary ... I have a table called 'salary', and it has the same structure as the 'salary.txt' --- employee_name & salary as the columns; I use the command