start->programs->mysql->mysql server 5.0->mysql command line client输入密码,进入之后就可以用了use yourDatabase; 。
C:\Documents and Settings\daqun>cd\C:\>cd C:\Program Files\MySQL\MySQL Server 5.0\binC:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -p密码 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 476 to server version: 5.0.16-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> mysql> use test2; Database changed mysql> select * from test2; +------+------+------------+ | id | name | num | +------+------+------------+ | 1 | a | 001 | | 2 | b | 002 | | 3 | d | 003 | | 4 | d | 00003 | | 5 | d | 001003 | | 6 | d | 0010000000 | +------+------+------------+ 6 rows in set (0.05 sec)mysql>
。
C:\Documents and Settings\daqun>cd\C:\>cd C:\Program Files\MySQL\MySQL Server 5.0\binC:\Program Files\MySQL\MySQL Server 5.0\bin>mysql -uroot -p密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 476 to server version: 5.0.16-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>
mysql> use test2;
Database changed
mysql> select * from test2;
+------+------+------------+
| id | name | num |
+------+------+------------+
| 1 | a | 001 |
| 2 | b | 002 |
| 3 | d | 003 |
| 4 | d | 00003 |
| 5 | d | 001003 |
| 6 | d | 0010000000 |
+------+------+------------+
6 rows in set (0.05 sec)mysql>