To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.

This script actual updates 13F current table as well as both archive13F tables.

We got coming in compid: : 145510
SELECT companies.* , sectors.level3des FROM companies, sectors WHERE companies.sector = sectors.level3num and compid = '145510'

The Shares Amount is 1220000000

The cusip is 049255805
NOT OLD

Retrive Rows from Table:
select * from current13Fpositions where cusip = '049255805'
Number of Rows :10

update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.03' where entryId = '9753390'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '17104014'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '18657856'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '42266801'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '2.13' where entryId = '129943307'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.02' where entryId = '111394582'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.06' where entryId = '131087211'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '130008583'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '130915866'
update current13Fpositions set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.22' where entryId = '130401764'
End Function

Retrive Rows from Table:
select * from archive13F where cusip = '049255805'
Number of Rows :137

update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '67501786'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '66715444'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '66624675'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '65196715'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '63447830'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '63626750'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '64867077'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '68454678'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '69863579'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '70196090'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '71153949'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '72112274'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73785910'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73309056'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73828913'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73812307'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '74061647'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '75044568'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '75761293'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '75816945'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76611747'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76723014'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76972718'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76811003'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '78142332'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '77680987'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '78201669'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '78835540'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79592215'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79680519'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '80360412'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79816389'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81170266'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '80930262'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81968008'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '82101604'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81959104'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '82232567'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '83636531'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '83947852'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '85738911'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '84848437'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '85465006'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86606720'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86543609'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86659412'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86835765'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87179087'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '88061152'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '89687807'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87941735'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '89272711'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90813254'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90539379'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90615749'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '91144408'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '92568165'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93730477'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '92965324'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93276074'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93328294'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94370756'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '95032908'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '95166481'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94893182'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '95612429'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96591486'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96557503'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96461367'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96891089'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '97826922'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '98784889'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '98493842'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100305003'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '99754672'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100267050'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100814701'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '101137968'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103056889'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '102399031'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103198061'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '102643051'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103268709'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103292034'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103385452'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '104512032'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '104812904'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '105530320'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '105672532'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '106038606'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '106359791'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '106694822'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '106225182'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '107549530'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '108311334'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '108543677'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '110348306'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '110001601'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '109899774'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '110502896'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '112339554'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '110930376'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '111761627'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '111654080'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '113510241'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '114200812'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '113774043'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '113941569'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '114633595'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116040994'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116402723'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116185622'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116398136'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '117192007'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116913605'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '121183691'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120680783'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '119493075'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '119577305'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120308877'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120871673'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '121910170'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '122315108'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '122260864'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '122767914'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '122624590'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '123232961'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '124204434'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '124883291'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '124940876'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '125126857'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '125735898'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '127095348'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '127769830'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '127715762'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '128094846'
update archive13F set compid = '145510', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '129863833'
End Function
The Script is complete, exiting....