[root@dogood pycode]# mysql -uroot -p |
Enter password : |
Welcome to the MySQL monitor. Commands end with ; or \g. |
Your MySQL connection id is 1 |
Server version: 5.1.66-log MySQL Community Server (GPL) |
Copyright (c) 2000, 2012, Oracle and / or its affiliates. All rights reserved. |
Oracle is a registered trademark of Oracle Corporation and / or its |
affiliates. Other names may be trademarks of their respective |
owners. |
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. |
mysql> show databases; #显示有什么数据库 |
+ --------------------+ |
| Database | |
+ --------------------+ |
| information_schema | |
| crashcourse | |
| mysql | |
| test | |
+ --------------------+ |
4 rows in set (0.07 sec) |
mysql> use crashcourse; #使用哪个数据库 |
Database changed |
mysql> SELECT vend_id FROM products; |
+ ---------+ |
| vend_id | |
+ ---------+ |
| 1001 | |
| 1001 | |
| 1001 | |
| 1002 | |
| 1002 | |
| 1003 | |
| 1003 | |
| 1003 | |
| 1003 | |
| 1003 | |
| 1003 | |
| 1003 | |
| 1005 | |
| 1005 | |
+ ---------+ |
14 rows in set (0.00 sec) |
mysql> |