SQL from Zero to Pro #3: Create, Delete and Rename a Database
In this chapter, we learn to manage databases: create them, delete them, rename them and switch from one to another. What you'll learn Connect to MySQL from the command line Create, delete, list and select a database Rename a database (there’s no command for that!) Pick the right encoding from the start The two basic commands -- Create a database CREATE DATABASE database_name; -- Delete a database DROP DATABASE database_name; You can do the same with a GUI (phpMyAdmin, Workbench…). Here, though, we use the command line: the terminal on Linux, the Command Prompt (CMD) on Windows. ...