Difference between revisions of "CLAS12 R1 S6 QA"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=Pre-Potting Tension Error= | =Pre-Potting Tension Error= | ||
| − | + | [[File:SL1S6_Sense_PrePot.png| 200 px]][[File:SL2S6_Sense_PrePot.png| 200 px]] | |
| − | |||
| + | [[File:SL1S6_Field_PrePot.png| 200 px]][[File:SL2S6_Field_PrePot.png| 200 px]] | ||
=MYSQL commands= | =MYSQL commands= | ||
Revision as of 02:20, 17 October 2012
Pre-Potting Tension Error
MYSQL commands
mysql> show databases;
+--------------------+ | Database | +--------------------+ | information_schema | | mysql | | region1 | | test | +--------------------+ 4 rows in set (0.02 sec)
mysql> use region1;
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed
mysql> show tables;
+-------------------------------+ | Tables_in_region1 | +-------------------------------+ | R1S1_Tension_Trend_Test_Field | | R1S1_Tension_Trend_Test_Sense | | R1S4_Tension_Trend_Test_Field | | R1S4_Tension_Trend_Test_Sense | | R1S5_Tension_Trend_Test_Field | | R1S6_Tension_Trend_Test_Field | | R1S6_Tension_Trend_Test_Sense | | R1_SL1_S1_Field | | R1_SL1_S1_Sense | | R1_SL1_S4_Field | | R1_SL1_S4_Sense | | R1_SL1_S5_Field | | R1_SL1_S6_Field | | R1_SL1_S6_Sense | | R1_SL2_S1_Field | | R1_SL2_S1_Sense | | R1_SL2_S4_Field | | R1_SL2_S4_Sense | | R1_SL2_S5_Field | | R1_SL2_S6_Field | | R1_SL2_S6_Sense | | R1_particleCounts | | R1_work_log | +-------------------------------+ 23 rows in set (0.00 sec)
mysql> describe R1_SL1_S6_Sense;
+------------------+-------------+------+-----+-------------------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-------------+------+-----+-------------------+-------+ | iCol | int(11) | NO | | NULL | | | iRow | int(11) | NO | | NULL | | | PeriodMeasured | float | YES | | NULL | | | Result | varchar(32) | YES | | NULL | | | TensionMeasured | float | YES | | NULL | | | CalculatedPeriod | float | YES | | NULL | | | SuperLayer | int(11) | NO | | NULL | | | Length | float | YES | | NULL | | | FreqMeasured | float | YES | | NULL | | | TensionError | float | YES | | NULL | | | TestLogic | int(11) | NO | | NULL | | | CalcFreq | float | YES | | NULL | | | HighCut | float | YES | | NULL | | | LowCut | float | YES | | NULL | | | Sector | int(11) | NO | | NULL | | | Date | varchar(32) | YES | | NULL | | | Mod_time | timestamp | NO | | CURRENT_TIMESTAMP | | +------------------+-------------+------+-----+-------------------+-------+ 17 rows in set (0.04 sec)
mysql> select TensionError from R1_SL1_S6_Sense INTO OUTFILE '/tmp/R1SL1S6Sense.dat';