Learning MySQL
MySQL is an open source and free relational database management system. In the Web Development, MySQL is the most popular and widely used relational database. MySql has a community version and a commercial version. The community version is completely free and can almost meet all usage scenarios. Since MySQL is open source, we can also customize and develop our own specific version according to our own needs.
This tutorial includes MySQL introduction, SQL statements, MySQL data management and maintenance, MySQL database management, performance improvement and some other topics.
Start your MySQL First Lesson now!
-
MySQL Getting Started
-
MySQL Basics
-
MySQL Databases and Tables
- MySQL Create Databases
- MySQL Drop Databases
- MySQL Use Database
- MySQL Create Tables
- MySQL Drop Tables
- MySQL Alters Tables
- MySQL Truncate Tables
- MySQL Primary Keys
- MySQL Foreign Keys
- MySQL Lock Tables
- MySQL Drop Columns
- MySQL Add Columns
- MySQL Auto Increment Columns
- MySQL Check Constraints
- MySQL Rename Tables
- MySQL Generated Columns
- MySQL Unique Keys
- MySQL NOT NULL
- MySQL Charset and Collation
-
MySQL Data Types
-
MySQL Indexes
-
MySQL Administration
- MySQL Start/Stop
- MySQL Create User
- MySQL Drop User
- MySQL Rename User
- MySQL Change Password
- MySQL Show Users
- MySQL Lock Users
- MySQL Unlock Users
- MySQL GRANT
- MySQL Revoke Privileges
- MySQL Show Grants
- MySQL Role
- MySQL Show Databases
- MySQL Show Tables
- MySQL Show Columns
- MySQL DESC
- MySQL Maintain Tables
- MySQL Backup
- MySQL Restore
- MySQL Show Processlist