CREATE keyword
Using
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';
by Valeri Tandilashvili
4 years ago
MySQL
2
Pro tip: use ```triple backticks around text``` to write in code fences