O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

Connect to the MySQL server:

shell> mysql -u root -pEnter Password:mysql> CREATE DATABASE company;mysql> CREATE DATABASE `my.contacts`;

The back tick character (`) is used to quote identifiers, such as database and table names. You need to use it when the database name contains special characters, such as dot (.).

You can switch between databases:

mysql> USE companymysql> USE `my.contacts`

Instead of switching, you can directly connect to the database you want by specifying it in the command line:

shell> mysql -u root -p company

To find which database you are connected to, use the following:

mysql> SELECT DATABASE();+------------+| DATABASE() |+------------+| company    |+------------+1 row in set (0.00 sec)

To find all the databases ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required