Difference between revisions of "CLAS12 R1 S6 QA"
Jump to navigation
Jump to search
(Created page with "=MYSQL commands= mysql> show databases; <pre> +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | region1 …") |
|||
| Line 59: | Line 59: | ||
+-------------------------------+ | +-------------------------------+ | ||
23 rows in set (0.00 sec) | 23 rows in set (0.00 sec) | ||
| + | |||
| + | </pre> | ||
| + | |||
| + | mysql> describe R1_SL1_S6_Sense; | ||
| + | |||
| + | <pre> | ||
| + | +------------------+-------------+------+-----+-------------------+-------+ | ||
| + | | 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) | ||
</pre> | </pre> | ||
Revision as of 21:01, 16 October 2012
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)