Site icon StudyGyaan

MySQL Database Cheatsheet

MySQL is one of the most popular relational database management systems, powering numerous web applications and services. Whether you’re a beginner or an experienced developer, having a cheatsheet handy can save time and make your interactions with the MySQL database more efficient. This cheatsheet provides a quick reference guide to common MySQL commands and operations.

Connecting to MySQL

Connect to MySQL Server

mysql -u username -p

Connect to a Specific Database

use database_name;

Show Databases

show databases;

Creating and Managing Databases

Create a Database

create database database_name;

Delete a Database

drop database database_name;

List Tables in a Database

show tables;

Managing Tables

Create a Table

create table table_name (
    column1 datatype,
    column2 datatype,

Delete a Table

drop table table_name;

Describe Table Structure

desc table_name;

Data Manipulation

Insert Data

insert into table_name (column1, column2, ...) values (value1, value2, ...);

Update Data

update table_name set column1 = value1 where condition;

Delete Data

delete from table_name where condition;

Select Data

select column1, column2, ... from table_name where condition;

Querying and Filtering

Simple SELECT Query

select * from table_name;

WHERE Clause

select * from table_name where column_name = value;


select * from table_name order by column_name;

LIMIT Clause

select * from table_name limit 10;

Advanced Features


select * from table1 join table2 on table1.column_name = table2.column_name;


create index index_name on table_name (column_name);


start transaction;
-- SQL statements


Create User

create user 'username'@'localhost' identified by 'password';

Grant Privileges

grant all privileges on database_name.* to 'username'@'localhost';

Revoke Privileges

revoke all privileges on database_name.* from 'username'@'localhost';

This MySQL cheatsheet provides a quick and handy reference for common database operations. Whether you’re creating tables, querying data, or managing users, these commands will help you navigate and manipulate your MySQL databases efficiently. Bookmark this cheatsheet for quick access, and enhance your productivity when working with MySQL.


1. What is MySQL?

MySQL is an open-source relational database management system (RDBMS) that allows users to store, manage, and retrieve data. It is widely used in web development for powering dynamic websites and applications.

2. How do I connect to a MySQL database?

To connect to a MySQL database, use the following command:
mysql -u username -p
Replace “username” with your MySQL username, and you’ll be prompted to enter your password.

3. How can I create a new table in MySQL?

To create a table, use the CREATE TABLE statement. Here’s a simple example:

4. What is the purpose of the WHERE clause in MySQL?

The WHERE clause is used in MySQL queries to filter results based on a specified condition. For example:
SELECT * FROM users WHERE age > 25;
This query retrieves all records from the “users” table where the age is greater than 25.

5. How do I secure my MySQL database?

To enhance security, create a dedicated user and grant specific privileges. Here’s an example:
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
Replace “username,” “password,” and “database_name” with your preferred values. This limits access to the specified user and enhances overall database security.

Exit mobile version