After installing MySQL in the MySQL command line, we can create a database with the following command, with the name of the database after it:
Every command must be ended by a semicolon; otherwise, MySQL will wait until the command is actually finished.
You can see all available databases with this command:
We can specify which database we want to use with the following command:
If we wish to delete a database, we can do so with the following command:
drop database database_name
Here is the MySQL command line:
Let's practice managing databases. We can create a database ...