×
Night mode
Sign up
Login
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
5 years ago
MySQL
2
Pro tip: use ```triple backticks around text``` to write in code fences