Difference: MysqlSampleSession (1 vs. 2)

Revision 22011-04-22 - PeterWinter

Line: 1 to 1
 
META TOPICPARENT name="LinuxPK"
Changed:
<
<
zero,~> mysql -h mysql -u musun -p
Enter password: (hint mu+p -> n +nu )
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 197696
Server version: 5.0.51a-3ubuntu5.8 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mu2e |
| musun |
| test |
+--------------------+
4 rows in set (0.00 sec)

mysql> use musun
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_musun |
+-------------------------+
| run1 |
| run1_Beamline |
| run1_history_new |
| run2 |
| run3 |
| run3_Beamline |
| run3_BeamlineElements |
| run3_history_new |
| run3_online_jobs |
| run3_online_jobs_config |
+-------------------------+
10 rows in set (0.00 sec)

mysql> describe run3;
+------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| run | int(11) | NO | PRI | 0 | |
| starttime | datetime | YES | | NULL | |
| comment | text | YES | | NULL | |
| shift | varchar(32) | YES | | NULL | |
| quality | varchar(32) | YES | | NULL | |
| condition | varchar(32) | YES | | NULL | |
| target | varchar(32) | YES | | NULL | |
| tpc_hv | int(11) | YES | | NULL | |
| mupc1_hv | int(11) | YES | | NULL | |
| magnet | int(11) | YES | | NULL | |
| beam_pscale | varchar(32) | YES | | NULL | |
| slit3 | varchar(32) | YES | | NULL | |
| kicker | varchar(32) | YES | | NULL | |
| kicker_hv_top | float | YES | | NULL | |
| kicker_hv_bottom | float | YES | | NULL | |
| separator_hv | int(11) | YES | | NULL | |
| epc1_hv | int(11) | YES | | NULL | |
| epc2_hv | int(11) | YES | | NULL | |
| stoptime | datetime | YES | | NULL | |
| nblock | double | YES | | NULL | |
| size | double | YES | | NULL | |
| tapesize | float | YES | | NULL | |
| tape | varchar(32) | YES | | NULL | |
| archive_size | double | YES | | NULL | |
| analysis_host | varchar(32) | YES | | NULL | |
| analysis_status | varchar(32) | YES | | NULL | |
+------------------+-------------+------+-----+---------+-------+
26 rows in set (0.00 sec)

mysql> select run, starttime, quality, nblock, size, beam_pscale from run3 where run >= 26120 and run <= 26129 ;
+-------+---------------------+---------+--------+------------+-------------+
| run | starttime | quality | nblock | size | beam_pscale |
+-------+---------------------+---------+--------+------------+-------------+
| 26120 | 2010-11-11 21:24:37 | Y | 1674 | 1611780000 | -1.443 |
| 26121 | 2010-11-11 21:28:20 | Y | 1666 | 1612300000 | -1.443 |
| 26122 | 2010-11-11 21:32:00 | Y | 1673 | 1612110000 | -1.443 |
| 26123 | 2010-11-11 21:35:40 | Y | 1651 | 1611780000 | -1.443 |
| 26124 | 2010-11-11 21:39:24 | Y | 1660 | 1612390000 | -1.443 |
| 26125 | 2010-11-11 21:43:06 | Y | 1678 | 1612240000 | -1.443 |
| 26126 | 2010-11-11 21:46:48 | Y | 1668 | 1612330000 | -1.443 |
| 26127 | 2010-11-11 21:50:27 | Y | 1668 | 1612200000 | -1.443 |
| 26128 | 2010-11-11 21:54:09 | Y | 1674 | 1611480000 | -1.443 |
| 26129 | 2010-11-11 21:57:50 | Y | 1665 | 1612290000 | -1.443 |
+-------+---------------------+---------+--------+------------+-------------+
10 rows in set (0.00 sec)

mysql> exit
Bye
zero,~>
>
>
Please go to https://muon.npl.washington.edu/twiki/bin/view/Main/MysqlSampleSession
 \ No newline at end of file

Revision 12011-01-06 - PeterKammel

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="LinuxPK"
zero,~> mysql -h mysql -u musun -p
Enter password: (hint mu+p -> n +nu )
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 197696
Server version: 5.0.51a-3ubuntu5.8 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mu2e |
| musun |
| test |
+--------------------+
4 rows in set (0.00 sec)

mysql> use musun
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_musun |
+-------------------------+
| run1 |
| run1_Beamline |
| run1_history_new |
| run2 |
| run3 |
| run3_Beamline |
| run3_BeamlineElements |
| run3_history_new |
| run3_online_jobs |
| run3_online_jobs_config |
+-------------------------+
10 rows in set (0.00 sec)

mysql> describe run3;
+------------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-------------+------+-----+---------+-------+
| run | int(11) | NO | PRI | 0 | |
| starttime | datetime | YES | | NULL | |
| comment | text | YES | | NULL | |
| shift | varchar(32) | YES | | NULL | |
| quality | varchar(32) | YES | | NULL | |
| condition | varchar(32) | YES | | NULL | |
| target | varchar(32) | YES | | NULL | |
| tpc_hv | int(11) | YES | | NULL | |
| mupc1_hv | int(11) | YES | | NULL | |
| magnet | int(11) | YES | | NULL | |
| beam_pscale | varchar(32) | YES | | NULL | |
| slit3 | varchar(32) | YES | | NULL | |
| kicker | varchar(32) | YES | | NULL | |
| kicker_hv_top | float | YES | | NULL | |
| kicker_hv_bottom | float | YES | | NULL | |
| separator_hv | int(11) | YES | | NULL | |
| epc1_hv | int(11) | YES | | NULL | |
| epc2_hv | int(11) | YES | | NULL | |
| stoptime | datetime | YES | | NULL | |
| nblock | double | YES | | NULL | |
| size | double | YES | | NULL | |
| tapesize | float | YES | | NULL | |
| tape | varchar(32) | YES | | NULL | |
| archive_size | double | YES | | NULL | |
| analysis_host | varchar(32) | YES | | NULL | |
| analysis_status | varchar(32) | YES | | NULL | |
+------------------+-------------+------+-----+---------+-------+
26 rows in set (0.00 sec)

mysql> select run, starttime, quality, nblock, size, beam_pscale from run3 where run >= 26120 and run <= 26129 ;
+-------+---------------------+---------+--------+------------+-------------+
| run | starttime | quality | nblock | size | beam_pscale |
+-------+---------------------+---------+--------+------------+-------------+
| 26120 | 2010-11-11 21:24:37 | Y | 1674 | 1611780000 | -1.443 |
| 26121 | 2010-11-11 21:28:20 | Y | 1666 | 1612300000 | -1.443 |
| 26122 | 2010-11-11 21:32:00 | Y | 1673 | 1612110000 | -1.443 |
| 26123 | 2010-11-11 21:35:40 | Y | 1651 | 1611780000 | -1.443 |
| 26124 | 2010-11-11 21:39:24 | Y | 1660 | 1612390000 | -1.443 |
| 26125 | 2010-11-11 21:43:06 | Y | 1678 | 1612240000 | -1.443 |
| 26126 | 2010-11-11 21:46:48 | Y | 1668 | 1612330000 | -1.443 |
| 26127 | 2010-11-11 21:50:27 | Y | 1668 | 1612200000 | -1.443 |
| 26128 | 2010-11-11 21:54:09 | Y | 1674 | 1611480000 | -1.443 |
| 26129 | 2010-11-11 21:57:50 | Y | 1665 | 1612290000 | -1.443 |
+-------+---------------------+---------+--------+------------+-------------+
10 rows in set (0.00 sec)

mysql> exit
Bye
zero,~>
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback