MySQL Command Reference
MySQL database: CRUD operations, index optimization, user management, backup/restore, and performance tuning
Command List
- mysql MySQL,, and socket
- CREATE DATABASE New, and
- CREATE TABLE ,, and
- SELECT ,, and
- INSERT , and
- UPDATE New, New, JOIN New and New
- DELETE / TRUNCATE , TRUNCATE and
- INDEX , and, EXPLAIN
- , and
- mysqldump,
- ALTER TABLE ,, and
- , BEGIN, COMMIT, ROLLBACK and Level
- VIEW , and,
- , and,
- MySQL, EXPLAIN and
Common Scenarios
- MySQL ? SQL, and
- and MySQL ? ,
- MySQL ? MySQL Connection refused Access denied,
Comparisons
- MySQL vs PostgreSQL: ? MySQL, PostgreSQL,