MYSQL Tutorial



CREATE & DROP DATABASE


MySQL: Create and Drop Database

Managing databases is a fundamental part of using MySQL. Here, you’ll learn how to create and delete databases with simple commands.

🔹 Creating a Database

Use the CREATE DATABASE command to make a new database.

CREATE DATABASE database_name;
  

Example: Create a database named myshop:

CREATE DATABASE myshop;
  

🔹 Dropping (Deleting) a Database

Use DROP DATABASE to permanently delete a database. Be careful — this removes all data inside!

DROP DATABASE database_name;
  

Example: Delete the database named myshop:

DROP DATABASE myshop;
  
Tip: Always double-check the database name before using DROP DATABASE to avoid accidental data loss!

🌟 Enjoyed Learning with Us?

Help others discover Technorank Learning by sharing your honest experience.
Your support inspires us to keep building!

Leave a Google Review