CLAS12 R1 S6 QA

From New IAC Wiki
Jump to navigation Jump to search

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';