i have a text file that looks like this:
Vic B.
male
21
IT
Jane D.
female
25
John D.
male
23
CEO
about 50,000 records like this, and i need to put them in a mysql database from a text file. some recors have 1 more field that others. can this be done. if so how. i alread have a mysql database with the fields: name, sex, age, position. HELP!
Vic B.
male
21
IT
Jane D.
female
25
John D.
male
23
CEO
about 50,000 records like this, and i need to put them in a mysql database from a text file. some recors have 1 more field that others. can this be done. if so how. i alread have a mysql database with the fields: name, sex, age, position. HELP!