Færdiggjort

MySQL fields to be filled in

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.

Evner: C programmering, Javascript, Perl, PHP

Se mere: mysql data files, mysql data base, male column, rows insert, mysql else insert, php delete mysql row, missing columns data, market data mysql, mysql record, insert text file database, match columns perl script, script delete row php, php match text number, male names, female base, filled fields php, male female names database, perl script data mysql, insert data database mysql, mysql php insert script

Om arbejdsgiveren:
( 424 bedømmelser ) North Caldwell, United States

Projekt ID: #3319960

Tildelt til:

CristianNicoara

See private message.

$25.5 USD in 21 dage
(10 bedømmelser)
3.9

21 freelancere byder i gennemsnit $52 på dette job

nextGenSol2002

See private message.

$127.5 USD in 21 dage
(118 bedømmelser)
6.6
abhay78

See private message.

$17 USD in 21 dage
(91 bedømmelser)
6.4
s4234

See private message.

$29.75 USD in 21 dage
(132 bedømmelser)
6.0
harisraheem

See private message.

$85 USD in 21 dage
(25 bedømmelser)
6.2
DrAKkareS

See private message.

$14.45 USD in 21 dage
(154 bedømmelser)
5.6
jonathan185

See private message.

$85 USD in 21 dage
(45 bedømmelser)
5.1
tawakalgeek

See private message.

$19.13 USD in 21 dage
(15 bedømmelser)
4.7
vw6809571vw

See private message.

$38.25 USD in 21 dage
(11 bedømmelser)
4.5
sumon4work

See private message.

$84.15 USD in 21 dage
(39 bedømmelser)
4.6
fredhoogstadvw

See private message.

$41.65 USD in 21 dage
(22 bedømmelser)
4.5
andreastpc

See private message.

$21.25 USD in 21 dage
(25 bedømmelser)
4.3
hiumair

See private message.

$32.73 USD in 21 dage
(28 bedømmelser)
4.0
alecn2002

See private message.

$212.5 USD in 21 dage
(21 bedømmelser)
4.3
drboom

See private message.

$20.4 USD in 21 dage
(30 bedømmelser)
4.2
jabedmorshed

See private message.

$38.25 USD in 21 dage
(58 bedømmelser)
3.9
aymaninho

See private message.

$17 USD in 21 dage
(16 bedømmelser)
3.0
lkshakya

See private message.

$17 USD in 21 dage
(16 bedømmelser)
3.2
hekata

See private message.

$51 USD in 21 dage
(4 bedømmelser)
2.0
leadingzero22

See private message.

$48.88 USD in 21 dage
(5 bedømmelser)
1.8
samtaylor159

See private message.

$63.75 USD in 21 dage
(0 bedømmelser)
0.0