固緯- 目前車站使用者的 MySQL查詢
BL06
root@localhost$ mysql ApolloDB
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 153354
Server version: 5.0.41-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from UserProfile;
+--------+---------+------------+----------+-----------+
| UserID | Name | Password | Disabled | GroupType |
+--------+---------+------------+----------+-----------+
| 1 | admin | av04735004 | N | 0 |
| 2 | manager | matrivideo | N | 1 |
| 3 | trtcocc | 3051 | N | 0 |
| 4 | cd3351 | 3351 | N | 1 |
| 10 | od01 | od01 | N | 1 |
| 6 | od02 | od02 | N | 2 |
| 17 | od03 | od03 | N | 2 |
| 8 | trtc | bl06 | N | 2 |
| 11 | od04 | od04 | N | 1 |
| 15 | dino | 21754 | N | 1 |
| 16 | cd315 | 3151 | N | 0 |
| 18 | occ | @occ2347 | N | 1 |
+--------+---------+------------+----------+-----------+
12 rows in set (0.02 sec)
mysql>
login as: root
root@10.252.107.101's password:
[Oct12 Tue][16:28][~]
root@localhost$ mysql ApolloDB
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 625233
Server version: 5.0.41-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from UserProfile;
+--------+---------+------------+----------+-----------+
| UserID | Name | Password | Disabled | GroupType |
+--------+---------+------------+----------+-----------+
| 1 | admin | av04735004 | N | 0 |
| 2 | manager | matrivideo | N | 1 |
| 3 | od06 | od06 | N | 1 |
| 4 | od01 | od01 | N | 2 |
| 5 | od02 | od02 | N | 2 |
| 6 | od03 | od03 | N | 2 |
| 7 | trtcocc | 3051 | N | 0 |
| 8 | cd3351 | 3351 | N | 1 |
| 9 | trtc | bl07 | N | 2 |
| 10 | occ | @occ2347 | N | 1 |
+--------+---------+------------+----------+-----------+
10 rows in set (0.00 sec)
mysql>
BL12
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4479776
Server version: 5.0.41-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from UserProfile;
+--------+---------+------------+----------+-----------+
| UserID | Name | Password | Disabled | GroupType |
+--------+---------+------------+----------+-----------+
| 1 | admin | av04735004 | N | 0 |
| 2 | manager | matrivideo | N | 1 |
| 3 | trtcocc | 3051 | N | 0 |
| 4 | cd3351 | 3351 | N | 1 |
| 5 | od06 | od06 | N | 1 |
| 6 | od01 | od01 | N | 2 |
| 7 | od02 | od02 | N | 2 |
| 8 | od03 | od03 | N | 2 |
| 9 | trtc | bl12 | N | 2 |
| 10 | occ | @occ2347 | N | 1 |
+--------+---------+------------+----------+-----------+
10 rows in set (0.02 sec)
mysql>
BL13
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5092442
Server version: 5.0.41-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from UserProfile;
+--------+---------+------------+----------+-----------+
| UserID | Name | Password | Disabled | GroupType |
+--------+---------+------------+----------+-----------+
| 1 | admin | av04735004 | N | 0 |
| 2 | manager | matrivideo | N | 1 |
| 3 | od06 | od06 | N | 1 |
| 4 | od01 | od01 | N | 2 |
| 5 | trtc | bl13 | N | 2 |
| 6 | trtcocc | 3051 | N | 0 |
| 7 | cd3351 | 3351 | N | 1 |
| 8 | od02 | od02 | N | 2 |
| 9 | od03 | od03 | N | 2 |
| 10 | occ | @occ2347 | N | 1 |
+--------+---------+------------+----------+-----------+
10 rows in set (0.03 sec)
mysql>
login as: root
root@10.252.117.101's password:
[Oct12 Tue][16:31][~]
root@localhost$ mysql ApolloDB
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 133643
Server version: 5.0.51a-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from UserProfile;
+--------+---------+------------+----------+-----------+
| UserID | Name | Password | Disabled | GroupType |
+--------+---------+------------+----------+-----------+
| 1 | admin | id | N | 0 |
| 2 | manager | matrivideo | N | 1 |
| 3 | od06 | od06 | N | 1 |
| 4 | od01 | od01 | N | 2 |
| 5 | trtcocc | 3051 | N | 0 |
| 6 | bl17pao | bl17 | N | 1 |
| 7 | cd3351 | 3351 | N | 0 |
| 8 | 123 | 321 | N | 0 |
| 9 | cd315 | 3151 | N | 0 |
| 10 | occ | @occ2347 | N | 1 |
+--------+---------+------------+----------+-----------+
10 rows in set (0.00 sec)
login as: root
root@10.95.2.11's password:
Last login: Sun Oct 10 13:16:29 2010 from 172.20.252.62
[root@localhost ~]# mysql ApolloDB
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 331788 to server version: 5.0.18-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from UserProfile;
+--------+----------+------------+----------+-----------+
| UserID | Name | Password | Disabled | GroupType |
+--------+----------+------------+----------+-----------+
| 1 | admin | id | N | 0 |
| 2 | manager | matrivideo | N | 1 |
| 3 | 0d06 | od06 | N | 1 |
| 4 | od01 | od01 | N | 1 |
| 11 | OPERATOR | or | N | 1 |
| 6 | NKD | 8400 | N | 2 |
| 7 | e01167 | e01167 | N | 2 |
| 8 | 00162 | ctt5216 | N | 2 |
| 9 | trtc | 8411 | N | 2 |
| 10 | e01276 | 0530 | N | 1 |
| 12 | od06 | od06 | N | 2 |
| 13 | trtcocc | 3051 | N | 0 |
| 14 | occ | @occ2347 | N | 1 |
+--------+----------+------------+----------+-----------+
13 rows in set (0.06 sec)
mysql>
login as: root
root@10.252.111.201's password:
[Oct12 Tue][16:34][~]
root@localhost$ mysql ApolloDB
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1844478
Server version: 5.0.41-community MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from UserProfile;
+--------+-----------+------------+----------+-----------+
| UserID | Name | Password | Disabled | GroupType |
+--------+-----------+------------+----------+-----------+
| 1 | admin | av04735004 | N | 0 |
| 2 | manager | matrivideo | N | 1 |
| 4 | trtc | trtc | N | 2 |
| 5 | trtcbl10m | trtcbl10m | N | 1 |
| 6 | BDC | 1234567 | N | 1 |
| 7 | od01 | od01 | N | 2 |
| 8 | od01 | od01 | N | 1 |
| 9 | od06 | od06 | N | 1 |
| 11 | trtcocc | 3051 | N | 0 |
| 12 | occ | @occ2347 | N | 1 |
+--------+-----------+------------+----------+-----------+
10 rows in set (0.01 sec)
mysql>
留言列表
蕭碧燕 (1)
