mysql 记录一下

[root@eyougate ~]# mysql -h localhost -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 235399 to server version: 4.0.20

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

mysql> show databases;
+--------------+
| Database     |
+--------------+
| filter       |
| gw_queue     |
| gw_statistic |
| gw_user_list |
| mail_logs    |
| mysql        |
| test         |
+--------------+
7 rows in set (0.00 sec)

mysql> use filter;
Database changed
mysql> show tables;
+--------------------+
| Tables_in_filter   |
+--------------------+
| admininfo          |
| antivirus          |
| bad_url            |
| bj_attachment_item |
| bj_keyword_item    |
| bj_match_log       |
| bj_rule_group      |
| bj_size_item       |
| custom_list_node   |
| default_domain     |
| ignore_url         |
| infod_config       |
| item_type          |
| list_domainip      |
| list_domainname    |
| list_node          |
| log_node           |
| openrelay_ip       |
| rbl                |
| relay_domain       |
| run_white_detail   |
| run_white_list     |
| smtp_config        |
| stat_rule          |
| stat_user          |
| stat_virus         |
| syslist_node       |
| system_config      |
| tmp_list_node      |
+--------------------+
29 rows in set (0.00 sec)

mysql> select * from admininfo;
+----------+----------------------------------+------------+---------------+----------------+------------+
| admin_id | admin_pass                       | admin_type | admin_purview | admin_name     | admin_desc |
+----------+----------------------------------+------------+---------------+----------------+------------+
| admin    | bccff15ee35af4474b93510644800ccd | 0          |             0 | 系统管理员     | NULL       |
| eyougw   | acd6aa0b20d8a0031a030d00c0125ca5 | 0          |             1 | 系统管理员     |            |
| eyouuser | 846fdd353b83b551b020a44c6d8c8b5e | 11         |             1 | 日志队列管理员 |            |
+----------+----------------------------------+------------+---------------+----------------+------------+
3 rows in set (0.00 sec)

mysql> desc admininfo
    -> ;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| admin_id      | varchar(64)  |      | PRI |         |       |
| admin_pass    | varchar(64)  | YES  |     | NULL    |       |
| admin_type    | varchar(11)  |      |     |         |       |
| admin_purview | bigint(16)   |      |     | 0       |       |
| admin_name    | varchar(16)  | YES  |     | NULL    |       |
| admin_desc    | varchar(128) | YES  |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> update admininfo set admin_pass='21232f297a57a5a743894a0e4a801fc3' where admin_id='admin';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from admininfo;
+----------+----------------------------------+------------+---------------+----------------+------------+
| admin_id | admin_pass                       | admin_type | admin_purview | admin_name     | admin_desc |
+----------+----------------------------------+------------+---------------+----------------+------------+
| admin    | 21232f297a57a5a743894a0e4a801fc3 | 0          |             0 | 系统管理员     | NULL       |
| eyougw   | acd6aa0b20d8a0031a030d00c0125ca5 | 0          |             1 | 系统管理员     |            |
| eyouuser | 846fdd353b83b551b020a44c6d8c8b5e | 11         |             1 | 日志队列管理员 |            |
+----------+----------------------------------+------------+---------------+----------------+------------+
3 rows in set (0.00 sec)

mysql>