check and update single column in mysql database...

Completado Publicado Mar 26, 2006 Pagado a la entrega
Completado Pagado a la entrega

I have a mysql database that contains a list of orders placed on a website. Unfortunately, one of the columns that maintains affiliate information is not accurate for a number of months and needs to be updated. I have an excel spreadsheet that *is* accurate regarding the affiliate column, and would like to use the data from the spreadsheet to update the database. I've created a user that has select access to the db, and update access to the specific column in question. Basically, I want someone to go through the excel spreadsheet, and for every numbered order that has an affiliate number listed, make sure that the db has the same number listed. There are 2,000+ entries with affiliate numbers in the excel spreadsheet, but I'm only expecting a few hundred in the earlier months to require updating. My estimate is that there should be about 400 or so records that need updating. I don't care if you do it by hand or with a script, but it must be completely accurate. I'd like this done tomorrow if possible... Edit-- Access to the db will be given via phpmyadmin

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

mysql, excel

Ingeniería MySQL PHP Arquitectura de software Verificación de software

Nº del proyecto: #3382128

Sobre el proyecto

25 propuestas Proyecto remoto Activo Mar 26, 2006

Adjudicado a:

mjbeaumont

See private message.

$17 USD en 2 días
(44 comentarios)
4.4

25 freelancers están ofertando un promedio de $58 por este trabajo

rattanisoft

See private message.

$59.5 USD en 2 días
(315 comentarios)
7.5
hutech

See private message.

$25.5 USD en 2 días
(35 comentarios)
6.7
zubairuddin

See private message.

$425 USD en 2 días
(62 comentarios)
6.3
liviussl

See private message.

$42.5 USD en 2 días
(225 comentarios)
6.0
kaldragon

See private message.

$25.5 USD en 2 días
(59 comentarios)
5.8
mickey1vw

See private message.

$21.25 USD en 2 días
(145 comentarios)
5.5
boyangeorgiev

See private message.

$85 USD en 2 días
(14 comentarios)
5.0
skywriter14

See private message.

$10.2 USD en 2 días
(22 comentarios)
4.9
eilyasoft

See private message.

$12.75 USD en 2 días
(61 comentarios)
4.8
hiteksolutionsvw

See private message.

$85 USD en 2 días
(50 comentarios)
4.7
CodingCops

See private message.

$59.5 USD en 2 días
(46 comentarios)
4.6
fortunaticasales

See private message.

$17 USD en 2 días
(53 comentarios)
4.4
gefcoder

See private message.

$12.75 USD en 2 días
(13 comentarios)
4.4
acebh

See private message.

$42.5 USD en 2 días
(9 comentarios)
4.1
look

See private message.

$102 USD en 2 días
(11 comentarios)
3.9
expertwebcoder

See private message.

$25.5 USD en 2 días
(8 comentarios)
3.4
maux

See private message.

$51 USD en 2 días
(17 comentarios)
2.9
sessionbean

See private message.

$34 USD en 2 días
(14 comentarios)
2.9
arsSQL

See private message.

$14.07 USD en 2 días
(9 comentarios)
2.7
kartikDonga

See private message.

$34 USD en 2 días
(0 comentarios)
0.0