check and update single column in mysql database...

已完成 已发布的 Mar 26, 2006 货到付款
已完成 货到付款

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

工程 MySQL PHP 软件构架 软件测试

项目ID: #3382128

关于项目

25个方案 远程项目 活跃的Mar 26, 2006

授予:

mjbeaumont

See private message.

$17 USD 在2天内
(44条评论)
4.4

有25名威客正在参与此工作的竞标,均价$58/小时

rattanisoft

See private message.

$59.5 USD 在2天内
(315条评论)
7.5
hutech

See private message.

$25.5 USD 在2天内
(35条评论)
6.7
zubairuddin

See private message.

$425 USD 在2天内
(62条评论)
6.3
liviussl

See private message.

$42.5 USD 在2天内
(225条评论)
6.0
kaldragon

See private message.

$25.5 USD 在2天内
(59条评论)
5.8
mickey1vw

See private message.

$21.25 USD 在2天内
(145条评论)
5.5
boyangeorgiev

See private message.

$85 USD 在2天内
(14条评论)
5.0
skywriter14

See private message.

$10.2 USD 在2天内
(22条评论)
4.9
eilyasoft

See private message.

$12.75 USD 在2天内
(61条评论)
4.8
hiteksolutionsvw

See private message.

$85 USD 在2天内
(50条评论)
4.7
CodingCops

See private message.

$59.5 USD 在2天内
(46条评论)
4.6
fortunaticasales

See private message.

$17 USD 在2天内
(53条评论)
4.4
gefcoder

See private message.

$12.75 USD 在2天内
(13条评论)
4.4
acebh

See private message.

$42.5 USD 在2天内
(9条评论)
4.1
look

See private message.

$102 USD 在2天内
(11条评论)
3.9
expertwebcoder

See private message.

$25.5 USD 在2天内
(8条评论)
3.4
maux

See private message.

$51 USD 在2天内
(17条评论)
2.9
sessionbean

See private message.

$34 USD 在2天内
(14条评论)
2.9
arsSQL

See private message.

$14.07 USD 在2天内
(9条评论)
2.7
kartikDonga

See private message.

$34 USD 在2天内
(0条评论)
0.0