I have a text file of male first names and I also have a text file of female first names.
I have several million data records in a MySQL database and each record row has 15 colums (fields of information).
All the rows have the first name of the person which is the second column of the 15 columns per record.? Many of the rows are missing the GENDER column .
The goal is to run the female text file against the MySQL data base and when there is a row that does not have a value for the gender place a "F" in the gender column.
We then look to match the MALE text file against the? MySQL database and insert an "M" in the gender column.
We need a script to do this.
We have gone through the two first name text files and tried to delete any where it could be both male and female.
We just need a script to do this and we will give you the format that the files are already in as you will need to know the column number that the gender column is of the 15 columns.
This script is very valuable to many companies and you can market to whoever else you like, as we do not care for sole ownership.