数据库操作

Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.41-community-nt MySQL Community Edition (GPL)

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

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

mysql> use hibernate_test;
Database changed
mysql> show tables
    -> ;
+--------------------------+
| Tables_in_hibernate_test |
+--------------------------+
| t_user                   |
+--------------------------+
1 row in set (0.00 sec)

mysql> select * from t_user;
+----------------------------------+--------+----------+---------------------+---------------------+
| id                               | name   | password | createTime          | expireTime          |
+----------------------------------+--------+----------+---------------------+---------------------+
| 402881e53efdd7d5013efdd7d65a0001 | 姹熷崡   | jnty     | 2013-06-01 11:46:20 | 2013-06-01 11:46:20 |
+----------------------------------+--------+----------+---------------------+---------------------+
1 row in set (0.00 sec)

mysql> show variables like 'character%';
+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | utf8                                                    |
| character_set_connection | utf8                                                    |
| character_set_database   | utf8                                                    |
| character_set_filesystem | binary                                                  |
| character_set_results    | utf8                                                    |
| character_set_server     | utf8                                                    |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)

mysql> status;
--------------
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe  Ver 14.12 Distrib 5.0.41, for Win32 (ia32)

Connection id:          5
Current database:       hibernate_test
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.0.41-community-nt MySQL Community Edition (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 2 hours 34 min 2 sec

Threads: 1  Questions: 50  Slow queries: 0  Opens: 14  Flush tables: 1  Open tables: 0  Queries per seco
nd avg: 0.005
--------------

mysql>