Основные команды для работы с mysql в терминале

01

Просмотр баз, таблиц и их структуры

bash: 

	yo@yo-Lenovo-G510:~$ mysql -u root -p
	Enter password:
	Welcome to the MySQL monitor.  Commands end with ; or \g.
	Your MySQL connection id is 6
	Server version: 5.7.25-0ubuntu0.16.04.2 (Ubuntu)

	Copyright (c) 2000, 2019, 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 |
	| mysql              |
	| performance_schema |
	| phpmyadmin         |
	| symfony            |
	| symfony_git        |
	| sys                |
	| yii2_a1            |
	| yii2_advanced2     |
	| yii2basic          |
	+--------------------+
	10 rows in set (0,10 sec)

	mysql> use database symfony; 
	ERROR 1049 (42000): Unknown database 'database'
	mysql> use symfony; 
	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_symfony |
	+-------------------+
	| post              |
	+-------------------+
	1 row in set (0,00 sec)

	mysql> describe post; 
	+-------------+--------------+------+-----+---------+----------------+
	| Field       | Type         | Null | Key | Default | Extra          |
	+-------------+--------------+------+-----+---------+----------------+
	| id          | int(11)      | NO   | PRI | NULL    | auto_increment |
	| title       | varchar(255) | NO   |     | NULL    |                |
	| description | longtext     | NO   |     | NULL    |                |
	| content     | longtext     | NO   |     | NULL    |                |
	| createdDate | datetime     | NO   |     | NULL    |                |
	| editDate    | datetime     | NO   |     | NULL    |                |
	| author      | varchar(255) | NO   |     | NULL    |                |
	| source      | varchar(255) | YES  |     | NULL    |                |
	| linkSource  | varchar(255) | YES  |     | NULL    |                |
	+-------------+--------------+------+-----+---------+----------------+
	9 rows in set (0,00 sec)

	mysql>
	

02

Создание и удаление

03

Просмотр баз, таблиц и их структуры

bash: 

	vagrant@homestead:~$ mysql
	Welcome to the MySQL monitor.  Commands end with ; or \g.
	Your MySQL connection id is 10
	Server version: 5.7.24-0ubuntu0.18.04.1 (Ubuntu)

	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> show databases; 
	+--------------------+
	| Database           |
	+--------------------+
	| information_schema |
	| homestead          |
	| mysql              |
	| performance_schema |
	| socket_wrench      |
	| sys                |
	+--------------------+
	6 rows in set (0.07 sec)

	mysql> use homestead; 
	Database changed
	mysql> show tables; 

	mysql> exit 
	Bye
	vagrant@homestead:~$