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: : 167135
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167135'
The Shares Amount is 9000000
The cusip is 15130G113
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '15130G113'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '15130G113'
Number of Rows :139
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '68141733'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '67700843'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '68058065'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '68024041'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '69613876'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '69977686'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '69967172'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '71710886'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '71288405'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '71607034'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '70995881'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '73671218'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '73599255'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '73192857'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '74795961'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '75455263'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '75187672'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '75060858'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '74924977'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '75981879'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '76870216'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '77295161'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '77510368'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '77127435'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '77296120'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '77927169'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '79047132'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '79193795'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '79194635'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '79411802'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '79623271'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '79017817'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '80169583'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '81465337'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '80683048'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '81128238'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '81037315'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '81332251'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '81333139'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '81390406'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '82071291'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '82582680'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '82735420'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '82815550'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '83106868'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '83384920'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '83385722'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '84440803'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '84751222'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '84860824'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '85037327'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '85434375'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '85653170'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '85654331'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '86030445'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '86788832'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '87321681'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '86668994'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '87010883'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '87444648'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '87445770'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '87538477'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '87870318'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '89283252'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '88487229'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '89538291'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '89539288'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '89205748'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '89918972'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '90162299'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '91669409'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '91262024'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '91490000'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '91906332'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '91572085'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '92120386'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '93054049'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '92232789'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '93147008'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '93190586'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '93340841'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '93877335'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '93309020'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '93526717'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '93871303'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '92526064'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '94174431'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '95272601'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '95246857'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '95122431'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '95321952'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '95591369'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '95723256'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '95864838'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '96025668'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '96391915'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '96221329'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '96879428'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '97448726'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '97687388'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '98157094'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '97982946'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '98371714'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '98704124'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '100479604'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '99952637'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '100454296'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '100456543'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '99254109'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '100077593'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '100172868'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '101052037'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '103200645'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '102136812'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '101999012'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '101904295'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '101906702'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '102181081'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '103120985'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '103823580'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '104048370'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '104670607'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '105004319'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '105277537'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '105279968'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '104798011'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '105823655'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '106447185'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '108077244'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '108216868'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '107454790'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '107805303'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '108312842'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '108581048'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '110117267'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '110725658'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '109986325'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '110777030'
update archive13F set
compid = '167135',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006480'
where entryId = '110756100'
End Function
The Script is complete, exiting....