首先在开始菜单上点击mysql command line client,然后按提示输入密码,正确的话就会出现如下界面:
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.12-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>
跟着输入命令:选择该记录所在的数据库,再在该记录所在的表查询就行了.下面我举个例.
我在数据库test下,有个表a;mysql> use test;
Database changed
mysql> select * from a;
+----+---------+
| id | name |
+----+---------+
| 1 | eee |
| 2 | bbb |
| 3 | ccc |
| 4 | ddd |
| 5 | adb\dbd |
+----+---------+
5 rows in set (0.05 sec)
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.12-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql>
跟着输入命令:选择该记录所在的数据库,再在该记录所在的表查询就行了.下面我举个例.
我在数据库test下,有个表a;mysql> use test;
Database changed
mysql> select * from a;
+----+---------+
| id | name |
+----+---------+
| 1 | eee |
| 2 | bbb |
| 3 | ccc |
| 4 | ddd |
| 5 | adb\dbd |
+----+---------+
5 rows in set (0.05 sec)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货