mysql基础学习（0）

MySQL基础学习(-)终端基本操作

1.在Mac终端登陆 mysql -u root -p(我使用root用户登陆）

~ ⌚ 10:46:54
$ mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.11 MySQL Community Server - GPL

Copyright (c) 2000, 2018, 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>

2.MySQL常用的命令

1.查看当前所有的数据库 showt databases;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> 

2.打开指定的数据库名 use 库名

mysql> use sys
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

3.查看当前的库的所有表
show tables;

mysql> show tables;
+-----------------------------------------------+
| Tables_in_sys                                 |
+-----------------------------------------------+
| host_summary                                  |
| host_summary_by_file_io                       |
| host_summary_by_file_io_type                  |
| host_summary_by_stages                        |
| host_summary_by_statement_latency             |
| host_summary_by_statement_type                |
| innodb_buffer_stats_by_schema                 |
| innodb_buffer_stats_by_table                  |
| innodb_lock_waits                             |
| ....
  .....
  

4.查看其他库的表 show tables from 库名；

mysql> show tables from mysql;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| component                 |
| db                        |
| default_roles             |
| engine_cost               |
| func                      |
| general_log               |
| global_grants             |
 ...
 ...
 ...

5.创建数据库create database 库名；

#创建一个男朋友的数据库，哈哈哈。。。
mysql> create database myBoyFriends;

Query OK, 1 row affected (0.52 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| myBoyFriends       |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

6.创建表
create table 表名（
列名 列类型，
列名 列类型，
...
);

mysql> use myBoyFriends;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+------------------------+
| Tables_in_myboyfriends |
+------------------------+
| bfInfo                 |
+------------------------+
1 row in set (0.00 sec)

mysql> 

7.查看表结构 desc 表名

mysql> desc bfInfo;
+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| bf_name  | varchar(20) | YES  |     | NULL    |       |
| bf_phone | int(12)     | YES  |     | NULL    |       |
+----------+-------------+------+-----+---------+-------+
2 rows in set (0.12 sec)

mysql> 

8.往表里插入一条数据

mysql> select * from bfInfo;
Empty set (0.00 sec)

mysql> insert into bfInfo values('keen',1234567);
Query OK, 1 row affected (0.12 sec)

mysql> select * from bfInfo;
+---------+----------+
| bf_name | bf_phone |
+---------+----------+
| keen    |  1234567 |
+---------+----------+
1 row in set (0.00 sec)

7.查看mysql 服务器的版本

• 方式一：登陆mysql 服务端
• select version();

mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.11    |
+-----------+
1 row in set (0.00 sec)

退出mysql

mysql> quit
Bye

• 方式二：没有登陆到MySQL

  • mysql --version;

  $ mysql --version;
   mysql  Ver 14.14 Distrib 5.7.22, for 
   osx10.13 (x86_64) using  EditLine wrapper
  
  

MySQL的语法规范

1.不区分大小写,但建议关键字大写，表名、列名小写
2.每条命令最好用分号结尾
3.每条命令根据需要，可以进行缩进 或换行
4.注释
    单行注释：#注释文字
    单行注释：-- 注释文字
    多行注释：/* 注释文字  */

注：这是本人的学习笔记，如果有错误的地方希望大小伙伴们能指出，谢谢！