控制台下MySQL的一些基本操作
环境:虚拟机Ubuntu 16.04
首先在shell中输入
mysql -u root -p
输入密码,以root权限进入mysql,之后可以输入status;查看mysql信息
mysql Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using readline 6.3
Connection id: 75
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.5.62-0ubuntu0.14.04.1 (Ubuntu)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 3 days 4 hours 41 min 7 sec
Threads: 1 Questions: 190 Slow queries: 0 Opens: 49 Flush tables: 1 Open tables: 42 Queries per second avg: 0.000
创建数据库
输入以下命令查看当前用户下所拥有的数据库:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
| websecurity |
+--------------------+
5 rows in set (0.08 sec)
使用create进行创建新的数据库并使用:
mysql> CREATE DATABASE websecurity;
Query OK, 1 row affected (0.07 sec)
mysql> use websecurity;
Database changed
创建一个teacher的表(not null表示不为空,id name sex addr都是变量,后面的char int代表了数据类型,primary key代表了id是一个键值,auto_increment表示id会自动增加)
(在有零填充的时候,int(4)显示0001,而int(11)显示00000000001,仅仅是显示上的区别,实际范围依然是 − 2 31