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

The Shares Amount is 1110000000

The cusip is 00109C103
NOT OLD

Retrive Rows from Table:
select * from current13Fpositions where cusip = '00109C103'
Number of Rows :2

update current13Fpositions set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0.13' where entryId = '86389606'
update current13Fpositions set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '132595651'
End Function

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

update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '75821928'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76313654'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '75854859'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76972449'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '78331088'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '77874379'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '77680856'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '78046187'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '78835267'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79937381'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79689498'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79758148'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79698122'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79715473'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81169998'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '80999611'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '82108310'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81850476'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81985842'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81879558'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '82232298'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '82615520'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '83413568'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '83879426'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '83872993'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '83775719'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '84059463'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '84649714'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '84848171'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '85278488'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87678388'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86112577'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86606429'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86637417'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '86918055'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87178810'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '85979209'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87978324'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87941452'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '89272433'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '89830596'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '88569012'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90812866'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '90055877'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '91824692'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '91826286'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '91144136'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '92567767'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93782932'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93275812'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93864834'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94370328'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94892917'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96557050'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '97440031'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96890820'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '98784411'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '99937745'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100304971'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100266775'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100814207'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '102387615'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103197794'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '102643018'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103292254'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '104647319'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '105530285'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '107981128'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '107549492'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '110348268'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '109781480'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '113373817'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '113510200'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '114658144'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '116041335'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '117207218'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120393472'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '120308893'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '121938120'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '123232951'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '124593672'
update archive13F set compid = '145490', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '127681028'
End Function
The Script is complete, exiting....