MYSQL DATA MANIPULATION

QUẢN LÝ DỮ LIỆU MYSQL

• SELECT

• SELECT DISTINCT

• ORDER BY

• WHERE

• AND

• OR

• IN

• BETWEEN

• LIKE

• LIMIT

• IS NULL

• Table & Column Aliases

• Joins

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• Self Join

• CROSS JOIN

• GROUP BY

• HAVING

• ROLLUP

• Subquery

• Derived Tables

• EXISTS

• UNION

• MINUS

• INTERSECT

• INSERT

• INSERT INTO SELECT

• Insert On Duplicate Key Update

• INSERT IGNORE

• UPDATE

• UPDATE JOIN

• DELETE

• DELETE JOIN

• ON DELETE CASCADE

• REPLACE

MYSQL DATA DEFINITION

• Selecting Database

• CREATE DATABASE

• DROP DATABASE

• Managing Databases

• Storage Engines

• Data Types

• CREATE TABLE

• Primary Key

• Foreign Key

• UNIQUE Constraint

• CHECK Constraint Emulation

• NOT NULL

• Sequence

• ALTER TABLE

• ADD COLUMN

• DROP COLUMN

• RENAME TABLE

• DROP TABLE

• Temporary Tables

• TRUNCATE TABLE

MYSQL DATA TYPES

• BIT

• BOOLEAN

• CHAR

• DATE

• DATETIME

• DECIMAL

• ENUM

• INT

• JSON

• TIME

• TIMESTAMP

• VARCHAR

MYSQL GLOBALIZATION

• MySQL Character Set

• MySQL Collation

MYSQL IMPORT & EXPORT

• Import a CSV File Into a Table

• Export a Table to a CSV File