CLAS12 R1 S6 QA
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)