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

The Shares Amount is 3041000

The cusip is G39320117
NOT OLD

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

update current13Fpositions set compid = '140067', sectorNum = '102001', sectorDes = 'Appliances', issuerCik = '0001057708' , percentOut = '423.47' where entryId = '42239354'
update current13Fpositions set compid = '140067', sectorNum = '102001', sectorDes = 'Appliances', issuerCik = '0001057708' , percentOut = '8.75' where entryId = '51211354'
End Function

Retrive Rows from Table:
select * from archive13F where cusip = 'G39320117'
Number of Rows :2

update archive13F set compid = '140067', sectorNum = '102001', sectorDes = 'Appliances', issuerCik = '0001057708' where entryId = '51037267'
update archive13F set compid = '140067', sectorNum = '102001', sectorDes = 'Appliances', issuerCik = '0001057708' where entryId = '96632815'
End Function
The Script is complete, exiting....