CREATE
`keyword we can create different database objects.
Creates database university
CREATE DATABASE university
Creates table:CREATE TABLE students (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
first_name VARCHAR(100) NOT NULL,
last_name VARCHAR(100) NOT NULL,
email VARCHAR(50)
)
Creates database user1
which will have password some-pass
CREATE USER 'user1'@'localhost' IDENTIFIED BY 'some-pass';