树莓派——mysql的学习（1）

最近打算重新学习一下mysql数据库，手上正好有一个树莓派，正好那它来练手。
在这里树莓派的连接工具是Xshell 5。
mysql数据库的连接工具是：Navicate Premium

这个界面是XShell的界面

Xshell 5 (Build 0964)
Copyright (c) 2002-2016 NetSarang Computer, Inc. All rights reserved.

Type `help' to learn how to use Xshell prompt.
[c:\~]$ 

这个是连接到树莓派之后的界面

Connecting to 192.168.1.103:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Wed Nov 16 16:19:44 2016
pi@raspberrypi:~ $ 

1. 连接与断开服务器

登陆mysql，并查看mysql的版本

pi@raspberrypi:~ $ mysql -u zhang -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 42
Server version: 5.5.52-0+deb8u1 (Raspbian)

Copyright (c) 2000, 2016, 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> select version();
+-----------------+
| version()       |
+-----------------+
| 5.5.52-0+deb8u1 |
+-----------------+
1 row in set (0.00 sec)

mysql> 

退出mysql数据库

mysql> quit
Bye

，

mysql> exit
Bye

或者是按 Ctrl+D

2. 输入查询

mysql> select version(),current_date;
+-----------------+--------------+
| version()       | current_date |
+-----------------+--------------+
| 5.5.52-0+deb8u1 | 2016-11-19   |
+-----------------+--------------+
1 row in set (0.00 sec)

mysql> select version(),current_date,host,user();
ERROR 1054 (42S22): Unknown column 'host' in 'field list'
mysql> select version(),current_date,user();
+-----------------+--------------+-----------------+
| version()       | current_date | user()          |
+-----------------+--------------+-----------------+
| 5.5.52-0+deb8u1 | 2016-11-19   | zhang@localhost |
+-----------------+--------------+-----------------+
1 row in set (0.00 sec)

mysql> -- 如果你输入命令包含错误，可以用\c进行取消
mysql> select user()
    -> \c
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

mysql> -- 创建并使用数据库
mysql> -- 查看当前服务器上已经存在的数据库
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

mysql> -- 使用数据库
mysql> use test;
Database changed
mysql> -- 查看当前使用过的数据库
mysql> select database();
+------------+
| database() |
+------------+
| test       |
+------------+
1 row in set (0.00 sec)

mysql> -- 创建并选择数据库
mysql> create database menagerie;
Query OK, 1 row affected (0.00 sec)

mysql> use menageries;
ERROR 1049 (42000): Unknown database 'menageries'
mysql> use menagerie;
Database changed
mysql> -- 也可以在连接数据库的时候指定数据库
mysql>