Author Archives: user

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 […]

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 – ROLLUP Table of content The MySQL ROLLUP Clause The MySQL ROLLUP Clause is an extension of the GROUP BY Clause. It is used with aggregate functions in MySQL to find the grand total or a summary of a column”s values (also known as super-aggregate of a column), in an extra row within a […]