For creating Shirts table in Mysql i am using some important commands.
- CREATE DATABASE — creates a new database.
- USE — selects a simple database and then performs operations on it using the in-built commands.
- CREATE TABLE — creates a new table.
- SELECT — extracts data from a database.
- INSERT INTO — inserts new data into a database.
- WHERE — filtering records in a table.
- UPDATE — modify the existing records in a table.
- DELETE — deletes existing records in a table