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

The Shares Amount is 0

The cusip is 021090204
NOT OLD

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

update current13Fpositions set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '9753164'
update current13Fpositions set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' , percentOut = '0' where entryId = '130223648'
End Function

Retrive Rows from Table:
select * from archive13F where cusip = '021090204'
Number of Rows :41

update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '69863412'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '70906020'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '71153767'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73785962'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73741130'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '73308867'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '75044375'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76972526'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '76810773'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '78835342'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '79592363'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '81170074'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '82232373'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '84848246'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '87178891'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '85978398'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '89272514'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '89830426'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '91824743'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '91144213'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '93275890'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94809469'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '94892994'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96851593'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '96890897'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '99909188'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '99346195'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '100266858'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '102176501'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '102081893'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '103197675'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '104144801'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '106948804'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '109214160'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '112941923'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '115036820'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '117712177'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '119838683'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '122566591'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '125702170'
update archive13F set compid = '145468', sectorNum = '999999', sectorDes = 'N/A', issuerCik = '' where entryId = '127931198'
End Function
The Script is complete, exiting....