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: : 130540
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130540'
The Shares Amount is 13224000
The cusip is 522015106
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '522015106'
Number of Rows :23
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '15.85'
where entryId = '3730768'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '239.17'
where entryId = '5747368'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '6518208'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '18.95'
where entryId = '10240694'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '11115756'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '2.83'
where entryId = '12287726'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '106.09'
where entryId = '12987167'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '13818075'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '148.01'
where entryId = '14332861'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '247.95'
where entryId = '14603692'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '11.2'
where entryId = '14875696'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0.54'
where entryId = '17015608'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '17776315'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '27.22'
where entryId = '19684727'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '27.22'
where entryId = '19697792'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '23406635'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '24521164'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '41123427'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '42470759'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '365.83'
where entryId = '50096175'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '1.99'
where entryId = '51213003'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '11.6'
where entryId = '127100727'
update current13Fpositions set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037' ,
percentOut = '0'
where entryId = '131359875'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '522015106'
Number of Rows :72
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '66214105'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '64464819'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '67952162'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '58392184'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '71478107'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '73521212'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '75325269'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '77181163'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '79076326'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '79391954'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '79839950'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '81453878'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '81267570'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '83556778'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '81931753'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '83322830'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '83962372'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '85078365'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '87316439'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '86575641'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '89419528'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '90562559'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '91354435'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '92530624'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '93432247'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '94200867'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '51108292'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '95792942'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '96172035'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '97895505'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '98591800'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '100379519'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '100921232'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '102704712'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '105140122'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '103365833'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '108270038'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '107663601'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '109695823'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '110408812'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '111638165'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '113099940'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '113783496'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '115365844'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '116092970'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '118556106'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '118831564'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '121148760'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '121560555'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '123962124'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '124214140'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129636676'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129637397'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129638166'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129638974'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129639847'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129640784'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129641633'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129642485'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129643469'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129644637'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129645743'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129646812'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129647534'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129648292'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129649511'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129650771'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129651930'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129653036'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129654172'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129655378'
update archive13F set
compid = '130540',
sectorNum = '503003',
sectorDes = 'Education & Training Services',
issuerCik = '0001002037'
where entryId = '129656440'
End Function
The Script is complete, exiting....