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: : 145465
SELECT companies.* , sectors.level3des FROM companies, sectors WHERE companies.sector = sectors.level3num and compid = '145465'

The Shares Amount is 765024000

The cusip is 007627102
NOT OLD

Retrive Rows from Table:
select * from current13Fpositions where cusip = '007627102'
Number of Rows :6

update current13Fpositions set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.04' where entryId = '9753033'
update current13Fpositions set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.23' where entryId = '11794077'
update current13Fpositions set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.26' where entryId = '13261915'
update current13Fpositions set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.02' where entryId = '111394449'
update current13Fpositions set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '130915713'
update current13Fpositions set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '130444950'
End Function

Retrive Rows from Table:
select * from archive13F where cusip = '007627102'
Number of Rows :42

update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '67501527'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '66624417'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '64866823'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '69863328'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '71153675'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73308777'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '75044282'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76972438'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '78835256'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81169988'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '82232288'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '84848161'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87178800'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '88469260'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '89272422'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90646685'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '91144125'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93275801'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94892906'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96591340'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96890808'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '98493705'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100266763'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '101137823'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103198009'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103385305'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '106038462'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '108543538'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '112081605'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '113510131'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '114424290'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116040231'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '117191977'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116913463'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120680753'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120872654'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '122260835'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '122625681'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '125735780'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '124829249'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '128234838'
update archive13F set compid = '145465', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '129863683'
End Function
The Script is complete, exiting....