Mysql

Syntax

Data Manipulation

Basic

• Select

SELECT columna, columnb FROM mytable;
SELECT columna as alias1, columnb as alias2 FROM mytable;

Special

• Dummy Table

SELECT 1+1;
SELECT 1+1 FROM DUAL;

• Concatenate

SELECT CONCAT(last_name,', ',first_name) AS full_name FROM mytable;

Data Definition

Basic

Create Database

CREATE DATABASE mydatabase;
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;

Create User

GRANT ALL PRIVILEGES ON mydatabase.* TO myuser@localhost IDENTIFIED BY 'myuser_password';