{"id":584,"date":"2009-12-27T14:13:36","date_gmt":"2009-12-27T14:13:36","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=584"},"modified":"2024-01-20T02:36:33","modified_gmt":"2024-01-20T09:36:33","slug":"mysql-cheat-sheet","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/","title":{"rendered":"MySQL Cheat Sheet"},"content":{"rendered":"\n

The MySQL cheat sheet<\/strong> provides you with one page that contains the most commonly used MySQL commands and statements that help you work with MySQL more effectively.<\/p>\n\n\n\n

MySQL command-line client Commands<\/h2>\n\n\n\n

Connect to MySQL server<\/a> using mysql  command-line client with a username and password (MySQL will prompt for a password):<\/p>\n\n\n

mysql -u [username] -p<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Connect to MySQL Server with a specified database using a username and password:<\/p>\n\n\n
mysql -u [username] -p [database]<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Exit mysql command-line client:<\/p>\n\n\n
exit<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
mysqldump -u [username] -p [database] > data_backup.sql<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
To clear the MySQL screen the console on Linux, you use the following command:<\/p>\n\n\n
mysql> system clear;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Currently, there is no command available on Windows for clearing the MySQL screen console window.<\/p>\n\n\n\n
Working with databases<\/h2>\n\n\n\n
Create a database<\/a> with a specified name if it does not exist in the database server<\/p>\n\n\n
CREATE<\/span> DATABASE<\/span> [IF<\/span> NOT<\/span> EXISTS<\/span>] database_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Use a database or change the current database to another database that you are working with:<\/p>\n\n\n
USE<\/span> database_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Drop a database with a specified name permanently. All physical files associated with the database will be deleted.<\/p>\n\n\n
DROP<\/span> DATABASE<\/span> [IF<\/span> EXISTS<\/span>] database_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Show all available databases in the current MySQL database server<\/p>\n\n\n
SHOW<\/span> DATABASES<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Working with tables<\/h2>\n\n\n\n
Show all tables in a current database.<\/p>\n\n\n
SHOW<\/span> TABLES<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
CREATE<\/span> TABLE<\/span> [IF<\/span> NOT<\/span> EXISTS<\/span>] table_name(\n  column_list\n);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
ALTER<\/span> TABLE<\/span> table<\/span> \nADD<\/span> [COLUMN<\/span>] column_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
ALTER<\/span> TABLE<\/span> table_name\nDROP<\/span> [COLUMN<\/span>] column_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Add an index with a specific name to a table on a column:<\/p>\n\n\n
ALTER<\/span> TABLE<\/span> table<\/span> \nADD<\/span> INDEX<\/span> [name<\/span>](column<\/span>, ...);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
ALTER TABLE table_name \nADD PRIMARY KEY (column_name,...);<\/code><\/span><\/pre>\n\n\n
Remove the primary key of a table:<\/p>\n\n\n
ALTER TABLE table_name\nDROP PRIMARY KEY;<\/code><\/span><\/pre>\n\n\n
Drop a table<\/a>:<\/p>\n\n\n
DROP<\/span> TABLE<\/span> [IF<\/span> EXISTS<\/span>] table_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
DESCRIBE<\/span> table_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Show the information of a column in a table:<\/p>\n\n\n
DESCRIBE<\/span> table_name column_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Working with indexes<\/h2>\n\n\n\n
Creating an index<\/a> with the specified name on a table:<\/p>\n\n\n
CREATE<\/span> INDEX<\/span> index_name\nON<\/span> table_name (column<\/span>,...);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
DROP<\/span> INDEX<\/span> index_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
CREATE<\/span> UNIQUE<\/span> INDEX<\/span> index_name \nON<\/span> table_name (column<\/span>,...);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Working with views<\/h2>\n\n\n\n
Create a new view:<\/p>\n\n\n
CREATE<\/span> VIEW<\/span> [IF<\/span> NOT<\/span> EXISTS<\/span>] view_name \nAS<\/span> \n  select_statement;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Create a new view using the WITH CHECK OPTION<\/code>:<\/p>\n\n\n
CREATE<\/span> VIEW<\/span> [IF<\/span> NOT<\/span> EXISTS<\/span>] view_name \nAS<\/span> \nselect_statement\nWITH<\/span> CHECK<\/span> OPTION<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Create or replace a view:<\/p>\n\n\n
CREATE<\/span> OR<\/span> REPLACE<\/span> view_name \nAS<\/span> \nselect_statement;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Drop a view:<\/p>\n\n\n
DROP<\/span> VIEW<\/span> [IF<\/span> EXISTS<\/span>] view_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Drop multiple views:<\/p>\n\n\n
DROP<\/span> VIEW<\/span> [IF<\/span> EXISTS<\/span>] view1, view2, ...;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Rename a view:<\/p>\n\n\n
RENAME<\/span> TABLE<\/span> view_name\nTO<\/span> new_view_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Show views from a database:<\/p>\n\n\n
SHOW<\/span> FULL<\/span> TABLES<\/span>\n[{FROM<\/span> | IN<\/span> } database_name]\nWHERE<\/span> table_type = 'VIEW'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Working with triggers<\/h2>\n\n\n\n
Create a new trigger<\/a>:<\/p>\n\n\n
CREATE<\/span> TRIGGER<\/span> trigger_name\n{BEFORE<\/span> | AFTER<\/span>} {INSERT<\/span> | UPDATE<\/span>| DELETE<\/span> }\nON<\/span> table_name FOR<\/span> EACH<\/span> ROW<\/span>\ntrigger_body;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
DROP<\/span> TRIGGER<\/span> [IF<\/span> EXISTS<\/span>] trigger_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Show triggers in a database:<\/p>\n\n\n
SHOW<\/span> TRIGGERS<\/span>\n[{FROM<\/span> | IN<\/span>} database_name]\n[LIKE<\/span> 'pattern'<\/span> | WHERE<\/span> search_condition];<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Working with stored procedures<\/h2>\n\n\n\n
Create a stored procedure:<\/p>\n\n\n
DELIMITER $$\n\nCREATE<\/span> PROCEDURE<\/span> procedure_name(parameter_list)\nBEGIN<\/span>\n   body<\/span>;\nEND<\/span> $$\n\nDELIMITER ;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Drop a stored procedure:<\/p>\n\n\n
DROP<\/span> PROCEDURE<\/span> [IF<\/span> EXISTS<\/span>] procedure_name;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Show stored procedures:<\/p>\n\n\n
SHOW<\/span> PROCEDURE<\/span> STATUS<\/span> \n[LIKE<\/span> 'pattern'<\/span> | WHERE<\/span> search_condition];<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Working with stored functions<\/h2>\n\n\n\n
Create a new stored function:<\/p>\n\n\n
DELIMITER $$\n \nCREATE<\/span> FUNCTION<\/span> function_name(parameter_list)\nRETURNS<\/span> datatype\n[NOT<\/span>] DETERMINISTIC<\/span>\nBEGIN<\/span>\n -- statements<\/span>\nEND<\/span> $$\n \nDELIMITER ;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Drop a stored function:<\/p>\n\n\n
DROP<\/span> FUNCTION<\/span> [IF<\/span> EXISTS<\/span>] function_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Show stored functions:<\/p>\n\n\n
SHOW<\/span> FUNCTION<\/span> STATUS<\/span> \n[LIKE<\/span> 'pattern'<\/span> | WHERE<\/span> search_condition];<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Querying data from tables<\/h2>\n\n\n\n
Query all data<\/a> from a table:<\/p>\n\n\n
SELECT<\/span> * FROM<\/span> table_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Query data from one or more columns of a table:<\/p>\n\n\n
SELECT<\/span> \n    column1, column2, ...\nFROM<\/span> \n    table_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Remove duplicate rows from the result of a query:<\/p>\n\n\n
SELECT<\/span> \n    DISTINCT<\/span> (column<\/span>)\nFROM<\/span> \n   table_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> select_list\nFROM<\/span> table_name\nWHERE<\/span> condition;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> \n    column1 AS<\/span> alias_name,\n    expression AS<\/span> alias<\/span>,\n    ...\nFROM<\/span> \n    table_name;\n<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> select_list\nFROM<\/span> table1\nINNER<\/span> JOIN<\/span> table2 ON<\/span> condition;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> select_list\nFROM<\/span> table1 \nLEFT<\/span> JOIN<\/span> table2 ON<\/span> condition;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> select_list \nFROM<\/span> table1 \nRIGHT<\/span> JOIN<\/span> table2 ON<\/span> condition;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Make a Cartesian product of rows:<\/p>\n\n\n
SELECT<\/span> select_list\nFROM<\/span> table1\nCROSS<\/span> JOIN<\/span> table2;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> COUNT<\/span>(*)\nFROM<\/span> table_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Sorting a result set:<\/p>\n\n\n
SELECT<\/span> \n    select_list\nFROM<\/span> \n    table_name\nORDER<\/span> BY<\/span> \n    column1 ASC<\/span> [DESC<\/span>], \n    column2 ASC<\/span> [DESC<\/span>];<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> select_list\nFROM<\/span> table_name\nGROUP<\/span> BY<\/span> column_1, column_2, ...;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> select_list\nFROM<\/span> table_name\nGROUP<\/span> BY<\/span> column1\nHAVING<\/span> condition;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Modifying data in tables<\/h2>\n\n\n\n
Insert a new row<\/a> into a table:<\/p>\n\n\n
INSERT<\/span> INTO<\/span> table_name(column_list)\nVALUES<\/span>(value_list);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
INSERT<\/span> INTO<\/span> table_name(column_list)\nVALUES<\/span>(value_list1),\n      (value_list2),\n      (value_list3),\n      ...;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
UPDATE<\/span> table_name\nSET<\/span> column1 = value1,\n    ...;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Update data for a set of rows specified by a condition in WHERE<\/code> clause.<\/p>\n\n\n
UPDATE<\/span> table_name\nSET<\/span> column_1 = value_1,\n    ...\nWHERE<\/span> condition<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
UPDATE<\/span> \n    table1, \n    table2\nINNER<\/span> JOIN<\/span> table1 ON<\/span> table1.column1 = table2.column2\nSET<\/span> column1 = value1,\nWHERE<\/span> condition;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
DELETE<\/span> FROM<\/span> table_name;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Delete rows specified by a condition:<\/p>\n\n\n
DELETE<\/span> FROM<\/span> table_name\nWHERE<\/span> condition;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
DELETE<\/span> table1, table2\nFROM<\/span> table1\nINNER<\/span> JOIN<\/span> table2\n    ON<\/span> table1.column1 = table2.column2\nWHERE<\/span> condition;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Searching<\/h2>\n\n\n\n
Search for data using the LIKE<\/a><\/code> operator:<\/p>\n\n\n
SELECT<\/span> select_list\nFROM<\/span> table_name\nWHERE<\/span> column<\/span> LIKE<\/span> '%pattern%'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
SELECT<\/span> select_list\nFROM<\/span> table_name\nWHERE<\/span> column<\/span> RLIKE<\/span> 'regular_expression'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>","protected":false},"excerpt":{"rendered":"
MySQL cheat sheet provides you with the on-page that contains the most commonly used statements that help you practice with MySQL more effectively.<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":29,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-584","page","type-page","status-publish","hentry"],"yoast_head":"\nMySQL Cheat Sheet<\/title>\n<meta name=\"description\" content=\"MySQL cheat sheet provides you with the on-page that contains the most commonly used statements that help you practice with MySQL more effectively.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Cheat Sheet\" \/>\n<meta property=\"og:description\" content=\"MySQL cheat sheet provides you with the on-page that contains the most commonly used statements that help you practice with MySQL more effectively.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"MySQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-20T09:36:33+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-cheat-sheet\\\/\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-cheat-sheet\\\/\",\"name\":\"MySQL Cheat Sheet\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\"},\"datePublished\":\"2009-12-27T14:13:36+00:00\",\"dateModified\":\"2024-01-20T09:36:33+00:00\",\"description\":\"MySQL cheat sheet provides you with the on-page that contains the most commonly used statements that help you practice with MySQL more effectively.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-cheat-sheet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-cheat-sheet\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-cheat-sheet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Cheat Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\",\"name\":\"MySQL Tutorial\",\"description\":\"A comprehensive MySQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mysqltutorial.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL Cheat Sheet","description":"MySQL cheat sheet provides you with the on-page that contains the most commonly used statements that help you practice with MySQL more effectively.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Cheat Sheet","og_description":"MySQL cheat sheet provides you with the on-page that contains the most commonly used statements that help you practice with MySQL more effectively.","og_url":"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/","og_site_name":"MySQL Tutorial","article_modified_time":"2024-01-20T09:36:33+00:00","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/","url":"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/","name":"MySQL Cheat Sheet","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"datePublished":"2009-12-27T14:13:36+00:00","dateModified":"2024-01-20T09:36:33+00:00","description":"MySQL cheat sheet provides you with the on-page that contains the most commonly used statements that help you practice with MySQL more effectively.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-cheat-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL Cheat Sheet"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/comments?post=584"}],"version-history":[{"count":1,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/584\/revisions"}],"predecessor-version":[{"id":14585,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/584\/revisions\/14585"}],"wp:attachment":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media?parent=584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Text search using a regular expression<\/a> with RLIKE<\/code> operator.<\/p>\n\n\n
Delete with join<\/a><\/p>\n\n\n
Delete all rows in a table<\/a><\/p>\n\n\n
Update with join<\/a><\/p>\n\n\n
Update<\/a> all rows in a table:<\/p>\n\n\n
Insert multiple rows<\/a> into a table:<\/p>\n\n\n
Filter group using the HAVING<\/a><\/code> clause:<\/p>\n\n\n
Group rows using the GROUP BY<\/code><\/a> clause.<\/p>\n\n\n
Counting rows<\/a> in a table.<\/p>\n\n\n
Query data from multiple tables using right join<\/a>:<\/p>\n\n\n
Query data from multiple tables using left join<\/a>:<\/p>\n\n\n
Query data from multiple tables using inner join<\/a>:<\/p>\n\n\n
Change the output of the column name using the column alias<\/a>:<\/p>\n\n\n
Query data with a filter using a WHERE<\/a><\/code> clause:<\/p>\n\n\n
Drop a trigger<\/a>:<\/p>\n\n\n
Create a unique index<\/a>:<\/p>\n\n\n
Drop an index<\/a>:<\/p>\n\n\n
Show the columns<\/a> of a table:<\/p>\n\n\n
Add primary key<\/a> into a table:<\/p>\n\n\n
Drop a column<\/a> from a table:<\/p>\n\n\n
Add a new column<\/a> to a table:<\/p>\n\n\n
Create a new table<\/a><\/p>\n\n\n
Export data using mysqldump tool<\/a><\/p>\n\n\n