Difference between revisions of "Mysql database"
From Hall A Wiki
m |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
Tables and structure for run management | Tables and structure for run management | ||
| − | mysql> describe runtable; | + | mysql> describe runtable; |
| − | +---------------+---------------+------+-----+---------+-------+ | + | +---------------+---------------+------+-----+---------+-------+ |
| − | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
| − | +---------------+---------------+------+-----+---------+-------+ | + | +---------------+---------------+------+-----+---------+-------+ |
| − | | run | int(11) | YES | | NULL | | | + | | run | int(11) | YES | | NULL | | |
| − | | runtype | varchar(50) | YES | | NULL | | | + | | runtype | varchar(50) | YES | | NULL | | |
| − | | side | varchar(5) | YES | | NULL | | | + | | side | varchar(5) | YES | | NULL | | |
| − | | target | varchar(30) | YES | | NULL | | | + | | target | varchar(30) | YES | | NULL | | |
| − | | epicstarget | varchar(30) | YES | | NULL | | | + | | epicstarget | varchar(30) | YES | | NULL | | |
| − | | targetencoder | int(11) | YES | | NULL | | | + | | targetencoder | int(11) | YES | | NULL | | |
| − | | raster | char(3) | YES | | NULL | | | + | | raster | char(3) | YES | | NULL | | |
| − | | mom | float | YES | | NULL | | | + | | mom | float | YES | | NULL | | |
| − | | momepics | float | YES | | NULL | | | + | | momepics | float | YES | | NULL | | |
| − | | angle | float | YES | | NULL | | | + | | angle | float | YES | | NULL | | |
| − | | angleepics | float | YES | | NULL | | | + | | angleepics | float | YES | | NULL | | |
| − | | dipcur | float | YES | | NULL | | | + | | dipcur | float | YES | | NULL | | |
| − | | anastart | int(11) | YES | | NULL | | | + | | anastart | int(11) | YES | | NULL | | |
| − | | anadone | int(11) | YES | | NULL | | | + | | anadone | int(11) | YES | | NULL | | |
| − | | comment | varchar(100) | YES | | NULL | | | + | | comment | varchar(100) | YES | | NULL | | |
| − | | time | timestamp(14) | YES | | NULL | | | + | | time | timestamp(14) | YES | | NULL | | |
| − | +---------------+---------------+------+-----+---------+-------+ | + | +---------------+---------------+------+-----+---------+-------+ |
| − | Scripts located | + | Scripts located |
| − | a-onl account scripts/mysql | + | a-onl account scripts/mysql |
| + | |||
| + | echo "select run from runtable where anadone=1 and run <20000;" | mysql -hadaqh1 -uadaq adaq | gawk '{print "rm onlana_full_"$0".root"}' | ||
Latest revision as of 22:13, 15 April 2008
Tables and structure for run management
mysql> describe runtable;
+---------------+---------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------+------+-----+---------+-------+ | run | int(11) | YES | | NULL | | | runtype | varchar(50) | YES | | NULL | | | side | varchar(5) | YES | | NULL | | | target | varchar(30) | YES | | NULL | | | epicstarget | varchar(30) | YES | | NULL | | | targetencoder | int(11) | YES | | NULL | | | raster | char(3) | YES | | NULL | | | mom | float | YES | | NULL | | | momepics | float | YES | | NULL | | | angle | float | YES | | NULL | | | angleepics | float | YES | | NULL | | | dipcur | float | YES | | NULL | | | anastart | int(11) | YES | | NULL | | | anadone | int(11) | YES | | NULL | | | comment | varchar(100) | YES | | NULL | | | time | timestamp(14) | YES | | NULL | | +---------------+---------------+------+-----+---------+-------+
Scripts located
a-onl account scripts/mysql
echo "select run from runtable where anadone=1 and run <20000;" | mysql -hadaqh1 -uadaq adaq | gawk '{print "rm onlana_full_"$0".root"}'
