checking tpcAnodeHVavg table entries in the DB
Connect to the DB:
mysql -h dbx.star.bnl.gov --port=3316 -u "" -p"" StarDb
See list of databases:
show databases;
Select one you need:
use Calibrations_tpc;
List tables:
show tables;
Explain entries for table you need:
explain tpcAnodeHVavg;
Select entries from the table:
select entryTime,beginTime,voltage,sector,socket,deactive from tpcAnodeHVavg where unix_timestamp(beginTime)=1275568198 and sector=24 and socket in (9,10,18);
Groups:
- mnaglis's blog
- Login or register to post comments