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

The Shares Amount is 0

The cusip is 465254209
NOT OLD

Retrive Rows from Table:
select * from current13Fpositions where cusip = '465254209'
Number of Rows :3

update current13Fpositions set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' , percentOut = '0' where entryId = '130009928'
update current13Fpositions set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' , percentOut = '0' where entryId = '130823948'
update current13Fpositions set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' , percentOut = '0' where entryId = '131800453'
End Function

Retrive Rows from Table:
select * from archive13F where cusip = '465254209'
Number of Rows :112

update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '68151529'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '67503294'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '66750715'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '66432366'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '65161592'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '66626190'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '63610018'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '64962770'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '64701926'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '64868598'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '69994881'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '69665457'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '69865052'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '70111223'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '70908194'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '71155504'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '72225277'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '73155228'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '73310624'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '74432476'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '74880445'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '75046137'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '76320984'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '76723976'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '76974257'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '76816514'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '77619364'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '78649774'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '78053221'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '78202652'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '78837122'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '79550097'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '79684988'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '80360933'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '79705632'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '81171828'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '81001992'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '81993572'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '81765271'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '81974227'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '82234152'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '82617765'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '83887052'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '84667666'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '84651966'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '84850027'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '85465946'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '86110940'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '87038952'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '85986869'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '86313262'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '86920327'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '87695719'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '87180667'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '87807178'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '87988075'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '89686093'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '89274298'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '89842093'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '88571217'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '88577559'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '90359004'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '90631666'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '91824856'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '91828491'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '91145975'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '90612983'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '92087387'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '92383117'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '93277640'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '93865091'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '93933418'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '94894752'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '94256165'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '96011693'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '97663063'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '98210734'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '96892683'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '98642026'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '98805753'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '100268668'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '100992159'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '103119630'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '103198049'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '103729076'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '103937282'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '108272133'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '107551558'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '106108886'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '112525416'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '110779868'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '109840666'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '110350436'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '111918925'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '113388673'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '113512343'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '113559624'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '114318768'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '116041792'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '116033962'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '116811266'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '119287450'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '121801121'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '122176312'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '125379106'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '124663781'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '124716977'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '125292618'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '127771106'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '129682290'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '127855891'
update archive13F set compid = '146429', sectorNum = '101005', sectorDes = 'Trucks & Other Vehicles', issuerCik = '' where entryId = '128792489'
End Function
The Script is complete, exiting....