MYSQL CHEAT SHEET WITH EXAMPLES CODE
MYSQL CHEAT SHEET WITH EXAMPLES PASSWORD
MYSQL CHEAT SHEET WITH EXAMPLES WINDOWS

ON table_name ( column.) Code language: SQL (Structured Query Language) ( sql )ĭrop an index: DROP INDEX index_name Code language: SQL (Structured Query Language) ( sql )Ĭreate a unique index: CREATE UNIQUE INDEX index_name

Show the information of a column in a table: DESCRIBE table_name column_name Code language: SQL (Structured Query Language) ( sql ) Working with indexesĬreating an index with the specified name on a table: CREATE INDEX index_name Show the columns of a table: DESCRIBE table_name Code language: SQL (Structured Query Language) ( sql ) Remove the primary key of a table: ALTER TABLE table_nameĭrop a table: DROP TABLE table_name Code language: SQL (Structured Query Language) ( sql ) ) Code language: SQL (Structured Query Language) ( sql )Īdd primary key into a table: ALTER TABLE table_name ) Code language: SQL (Structured Query Language) ( sql )Īdd a new column into a table: ALTER TABLE table ADD column_name Code language: SQL (Structured Query Language) ( sql )ĭrop a column from a table: ALTER TABLE table_nameĭROP column_name Code language: SQL (Structured Query Language) ( sql )Īdd index with a specific name to a table on a column: ALTER TABLE table ADD INDEX ( column. SHOW TABLES Code language: SQL (Structured Query Language) ( sql )Ĭreate a new table CREATE TABLE table_name( Show all available databases in the current MySQL database server SHOW DATABASE Code language: SQL (Structured Query Language) ( sql ) Working with tables DROP DATABASE database_name Code language: SQL (Structured Query Language) ( sql ) All physical files associated with the database will be deleted. Use a database or change the current database to another database that you are working with: USE database_name Code language: SQL (Structured Query Language) ( sql )ĭrop a database with a specified name permanently. Working with databasesĬreate a database with a specified name if it does not exist in the database server CREATE DATABASE database_name Code language: SQL (Structured Query Language) ( sql )

MYSQL CHEAT SHEET WITH EXAMPLES WINDOWS

To clear MySQL screen console window on Linux, you use the following command: mysql> system clear Ĭode language: SQL (Structured Query Language) ( sql )Ĭurrently, there is no command available on Windows OS for clearing MySQL screen console window.

MYSQL CHEAT SHEET WITH EXAMPLES PASSWORD

MySQL command-line client CommandsĬonnect to MySQL server using mysql command-line client with a username and password (MySQL will prompt for a password): mysql -u -p Code language: SQL (Structured Query Language) ( sql )Ĭonnect to MySQL Server with a specified database using a username and password: mysql -u -p Code language: SQL (Structured Query Language) ( sql )Įxit mysql command-line client: exit Code language: SQL (Structured Query Language) ( sql )Įxport data using mysqldump tool mysqldump -u -p > data_backup.sql Code language: SQL (Structured Query Language) ( sql ) In the next tutorial section, we will discuss the Right Join.MySQL cheat sheet provides you with one-page that contains the most commonly used MySQL commands and statements that help you work with MySQL more effectively.

This brings us to the end of this LEFT JOIN in SQL tutorial section Go ahead and link the tables from your database to get a better insight into your data. Once the query is executed, a message appears like ‘Commands completed successfully Let’s apply LEFT JOIN to two tables, the employee table, and the department table Select employee.e_name, employee.e_dept, department.d_name, department.d_location from employeeĪfter writing the query, click on the execute button to check for errors. Stay up-to-date on the latest SQL Join features! SQL LEFT JOIN Example Where SELECT, LEFT JOIN, and ON are the keywords, columns are the list of columns, table1 is the first table and table2 is the second table, and column_x and column_y are the columns for performing the LEFT JOIN, followed by a semicolon. Wish to get certified in SQL! Learn SQL from top SQL experts and excel in your career with Intellipaat’s Microsoft SQL certification course. When LEFT JOIN is applied on these two tables, all records from Table A and only the matched records from Table B will be displayed. For example, let’s say, we have two tables, Table A and Table B. The LEFT JOIN in SQL basically returns all records from the left table and the matched records from the right tables.

Mysql cheat sheet with examples