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

The Shares Amount is 28723000

The cusip is 020936100
NOT OLD

Retrive Rows from Table:
select * from current13Fpositions where cusip = '020936100'
Number of Rows :4

update current13Fpositions set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.35' where entryId = '78504052'
update current13Fpositions set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.04' where entryId = '129838754'
update current13Fpositions set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '132577008'
update current13Fpositions set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '130733314'
End Function

Retrive Rows from Table:
select * from archive13F where cusip = '020936100'
Number of Rows :82

update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '67526064'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '65081112'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '67019590'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '65660002'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '65984801'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '67695966'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '67053383'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '68522186'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '65370274'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '65283856'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '63476301'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '63465904'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '64880234'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '64024025'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '68523143'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '68486556'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '68713820'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '68891023'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '69108633'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '71668695'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '70510410'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '70138929'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '70427315'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '72446430'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '72175058'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73111623'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73959090'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '74754023'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76612170'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '77471078'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '77828475'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79816571'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81721731'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '83632896'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '83765494'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '85295827'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '85966345'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86606577'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87680190'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87890355'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87941600'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '89437469'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90813070'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90333286'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90265671'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '91787295'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93779969'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93510276'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '92567976'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94332972'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94370552'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96070470'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96557286'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '98784660'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100814463'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '98732232'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103534788'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '102398969'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '102643070'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103291348'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '104813060'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '105628626'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '106798196'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '110103945'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '112620209'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '114722399'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116680137'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120270563'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120272672'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '119570062'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120540821'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120265429'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '123893278'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '123905391'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '123674580'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '124101051'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '125285510'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '126805329'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '126571981'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '126934271'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '127702349'
update archive13F set compid = '145517', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '129579523'
End Function
The Script is complete, exiting....