MySQL – Statements Reference Table of content Here is the list of all important MySQL statements. Each statement has been explained along with suitable example. Data Definition Statements − This statement is used to change the characteristics of an existing database. − This statement is used to change the characteristics of an existing event. − […]
Category Archives: mysql
MySQL – Wildcards Table of content The MySQL wildcards The MySQL wildcards are special characters used in combination with the LIKE operator to search for text patterns in a table column. MySQL provides two wildcards: percent (%) and underscore (_). The following table mentions the use case of the two wildcards in MySQL − S.NO […]
MySQL – EXPLAIN Table of content The MySQL EXPLAIN Statement The MySQL EXPLAIN statement is used to provide the execution plan of a query. This statement works similar to the DESCRIBE query; while the DESCRIBE query provides the structure plan of a table, the EXPLAIN statement describes how a query is being executed. You can […]