In SQL, a database is a container that holds all your data in structured formats like tables, views, procedures, etc. It is the starting point for organizing and working with data.
To create a new database in SQL, use the CREATE DATABASE
statement:
CREATE DATABASE school;
Once created, you can start using your database with the USE
command:
USE school;
To view all databases available on your server:
SHOW DATABASES;
💡 Pro Tip: Database names should be unique and descriptive. Avoid using spaces or special characters in names.
Help others discover Technorank Learning by sharing your honest experience.
Your support inspires us to keep building!