MySQL 5.7 command line client指令总结

MySQL 5.7 command line client 每条命令结束时要有结束符，可以是分号。

 

1.输入密码，连接数据库

******（初始密码为安装过程中设置的密码）

 

2.修改root密码

set password for'root'@'localhost'=password('123456');（假设修改的密码为：123456）

 

3.显示数据库

show databases;

 

4.对数据库操作之前要输入如下命令

use databasename;

 

5.显示数据库中的表

show tables;

 

6.创建一个表

例如：

create table user(

                      ->int id,

                      ->name varchar(30),

                      ->pass varchar(30)

                      ->);

user为表名。

 

7.查看表字段

desc user;

 

8.向表中插入数据

insert into user(id,name,pass)values(1,"LiMing","123456");

 

9.查询表数据

select *from user;

 

10.删除表

drop table user;

 

MySQL 基础篇（总结）

一、数据库操作

1.查看数据库  show databases;

2.创建数据库  create database y1;

3.切换数据库  use y1;

4.删除数据库  drop database y1;

 

二、表操作

1.查看表     show tables;

2.创建表     create table user....;

3.修改表

4.删除表     drop table user;

5.查看表字段  desc user;

6.查看表数据  select *from user;

7.修改表名   rename table user to user1;

 

例题：

mysql> create table t1(    -> id int not null auto_increment primary key,            //创建查询主键id    -> name varchar(30),    -> url varchar(30),    -> alexa int,    -> country varchar(30)    -> );Query OK, 0 rows affected (0.09 sec)mysql> desc t1;+---------+-------------+------+-----+---------+----------------+| Field   | Type        | Null | Key | Default | Extra          |+---------+-------------+------+-----+---------+----------------+| id      | int(11)     | NO   | PRI | NULL    | auto_increment || name    | varchar(30) | YES  |     | NULL    |                || url     | varchar(30) | YES  |     | NULL    |                || alexa   | int(11)     | YES  |     | NULL    |                || country | varchar(30) | YES  |     | NULL    |                |+---------+-------------+------+-----+---------+----------------+5 rows in set (0.01 sec)mysql> insert into t1(name,url,alexa,country) values('菜鸟教程','https://www.runoob.com/',4689,'CN')Query OK, 1 row affected (0.00 sec)mysql> insert into t1(name,url,alexa,country) values('微博','https://www.weibo.com/',20,'CN');Query OK, 1 row affected (0.00 sec)mysql> insert into t1(name,url,alexa,country) values('Facebook','https://www.facebook.com/',3,'USA')Query OK, 1 row affected (0.00 sec)mysql> select *from t1;+----+--------------+---------------------------+-------+---------+| id | name         | url                       | alexa | country |+----+--------------+---------------------------+-------+---------+|  1 | Ggoogle      | https://www.google.cm/    |     1 | USA     ||  2 | 淘宝         | https://www.taobao.com/   |    13 | CN      ||  3 | 菜鸟教程     | https://www.runoob.com/   |  4689 | CN      ||  4 | 微博         | https://www.weibo.com/    |    20 | CN      ||  5 | Facebook     | https://www.facebook.com/ |     3 | USA     |+----+--------------+---------------------------+-------+---------+5 rows in set (0.00 sec)