> For the complete documentation index, see [llms.txt](https://learnsql.gitbook.io/lernmysql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learnsql.gitbook.io/lernmysql/mysql-tutorial-full/mysql-data-manipulation.md).

# MYSQL DATA MANIPULATION

QUẢN LÝ DỮ LIỆU MYSQL

* [SELECT](http://www.mysqltutorial.org/mysql-select-statement-query-data.aspx)
* [SELECT DISTINCT](http://www.mysqltutorial.org/mysql-distinct.aspx)
* [ORDER BY](http://www.mysqltutorial.org/mysql-order-by/)
* [WHERE](http://www.mysqltutorial.org/mysql-where/)
* [AND](http://www.mysqltutorial.org/mysql-and/)
* [OR](http://www.mysqltutorial.org/mysql-or/)
* [IN](http://www.mysqltutorial.org/sql-in.aspx)
* [BETWEEN](http://www.mysqltutorial.org/mysql-between)
* [LIKE](http://www.mysqltutorial.org/mysql-like/)
* [LIMIT](http://www.mysqltutorial.org/mysql-limit.aspx)
* [IS NULL](http://www.mysqltutorial.org/mysql-is-null/)
* [Table & Column Aliases](http://www.mysqltutorial.org/mysql-alias/)
* [Joins](http://www.mysqltutorial.org/mysql-join/)
* [INNER JOIN](http://www.mysqltutorial.org/mysql-inner-join.aspx)
* [LEFT JOIN](http://www.mysqltutorial.org/mysql-left-join.aspx)
* [RIGHT JOIN](http://www.mysqltutorial.org/mysql-right-join/)
* [Self Join](http://www.mysqltutorial.org/mysql-self-join/)
* [CROSS JOIN](http://www.mysqltutorial.org/mysql-cross-join/)
* [GROUP BY](http://www.mysqltutorial.org/mysql-group-by.aspx)
* [HAVING](http://www.mysqltutorial.org/mysql-having.aspx)
* [ROLLUP](http://www.mysqltutorial.org/mysql-rollup/)
* [Subquery](http://www.mysqltutorial.org/mysql-subquery/)
* [Derived Tables](http://www.mysqltutorial.org/mysql-derived-table/)
* [EXISTS](http://www.mysqltutorial.org/mysql-exists/)
* [UNION](http://www.mysqltutorial.org/sql-union-mysql.aspx)
* [MINUS](http://www.mysqltutorial.org/mysql-minus/)
* [INTERSECT](http://www.mysqltutorial.org/mysql-intersect/)
* [INSERT](http://www.mysqltutorial.org/mysql-insert-statement.aspx)
* [INSERT INTO SELECT](http://www.mysqltutorial.org/mysql-insert-into-select/)
* [Insert On Duplicate Key Update](http://www.mysqltutorial.org/mysql-insert-or-update-on-duplicate-key-update/)
* [INSERT IGNORE](http://www.mysqltutorial.org/mysql-insert-ignore/)
* [UPDATE](http://www.mysqltutorial.org/mysql-update-data.aspx)
* [UPDATE JOIN](http://www.mysqltutorial.org/mysql-update-join/)
* [DELETE](http://www.mysqltutorial.org/mysql-delete-statement.aspx)
* [DELETE JOIN](http://www.mysqltutorial.org/mysql-delete-join/)
* [ON DELETE CASCADE](http://www.mysqltutorial.org/mysql-on-delete-cascade/)
* [REPLACE](http://www.mysqltutorial.org/mysql-replace.aspx)

**MYSQL DATA DEFINITION**

* [Selecting Database](http://www.mysqltutorial.org/mysql-select-database/)
* [CREATE DATABASE](http://www.mysqltutorial.org/mysql-create-database/)
* [DROP DATABASE](http://www.mysqltutorial.org/mysql-drop-database/)
* [Managing Databases](http://www.mysqltutorial.org/mysql-create-drop-database.aspx)
* [Storage Engines](http://www.mysqltutorial.org/understand-mysql-table-types-innodb-myisam.aspx)
* [Data Types](http://www.mysqltutorial.org/mysql-data-types.aspx)
* [CREATE TABLE](http://www.mysqltutorial.org/mysql-create-table/)
* [Primary Key](http://www.mysqltutorial.org/mysql-primary-key/)
* [Foreign Key](http://www.mysqltutorial.org/mysql-foreign-key/)
* [UNIQUE Constraint](http://www.mysqltutorial.org/mysql-unique-constraint/)
* [CHECK Constraint Emulation](http://www.mysqltutorial.org/mysql-check-constraint/)
* [NOT NULL](http://www.mysqltutorial.org/mysql-not-null-constraint/)
* [Sequence](http://www.mysqltutorial.org/mysql-sequence/)
* [ALTER TABLE](http://www.mysqltutorial.org/mysql-alter-table.aspx)
* [ADD COLUMN](http://www.mysqltutorial.org/mysql-add-column/)
* [DROP COLUMN](http://www.mysqltutorial.org/mysql-drop-column/)
* [RENAME TABLE](http://www.mysqltutorial.org/mysql-rename-table/)
* [DROP TABLE](http://www.mysqltutorial.org/mysql-drop-table)
* [Temporary Tables](http://www.mysqltutorial.org/mysql-temporary-table/)
* [TRUNCATE TABLE](http://www.mysqltutorial.org/mysql-truncate-table/)

**MYSQL DATA TYPES**

* [BIT](http://www.mysqltutorial.org/mysql-bit/)
* [BOOLEAN](http://www.mysqltutorial.org/mysql-boolean/)
* [CHAR](http://www.mysqltutorial.org/mysql-char-data-type/)
* [DATE](http://www.mysqltutorial.org/mysql-date/)
* [DATETIME](http://www.mysqltutorial.org/mysql-datetime/)
* [DECIMAL](http://www.mysqltutorial.org/mysql-decimal/)
* [ENUM](http://www.mysqltutorial.org/mysql-enum/)
* [INT](http://www.mysqltutorial.org/mysql-int/)
* [JSON](http://www.mysqltutorial.org/mysql-json/)
* [TIME](http://www.mysqltutorial.org/mysql-time/)
* [TIMESTAMP](http://www.mysqltutorial.org/mysql-timestamp.aspx)
* [VARCHAR](http://www.mysqltutorial.org/mysql-varchar/)

**MYSQL GLOBALIZATION**

* [MySQL Character Set](http://www.mysqltutorial.org/mysql-character-set/)
* [MySQL Collation](http://www.mysqltutorial.org/mysql-collation/)

**MYSQL IMPORT & EXPORT**

* [Import a CSV File Into a Table](http://www.mysqltutorial.org/import-csv-file-mysql-table/)
* [Export a Table to a CSV File](http://www.mysqltutorial.org/mysql-export-table-to-csv/)