MySQL IN In MySQL, the IN condition filters the results obtained through the SELECT, INSERT, UPDATE, and DELETE statements to replace the use of multiple OR conditions. Syntax: WHERE expressions IN (value1, value2, …. value_n); Parameters: expressions: It is used to specify a column or a field. value_1, value_2… value_n: They are used to specify … Read more
MySQL LIKE In MySQL, the LIKE condition filters the results obtained through the SELECT, INSERT, UPDATE, and DELETE statements based on pattern matching. Syntax: WHERE expressions LIKE pattern [ ESCAPE ‘escape_character’ ] Parameters: expressions: It is used to specify a column or a field. pattern: It is used to specify the character expression for pattern … Read more
MySQL HAVING In MySQL, the HAVING condition is used with the GROUP BY clause to group the fetched data by one or more columns only when the condition is TRUE. Syntax: To group the rows by values in multiple columns. SELECT expressions FROM table_name GROUP BY columns HAVING having_conditions; Parameters: having_conditions: It is used to … Read more
MySQL GROUP BY In MySQL, the GROUP BY clause is used with the SELECT statement to group the fetched data by one or more columns. Syntax: To group the rows by values in multiple columns. SELECT expressions FROM table_name GROUP BY columns; Parameters: expressions: It is used to specify the columns or calculations to be … Read more
MySQL ORDER BY In MySQL, the ORDER BY clause is used with the SELECT statement to re-arrange the records of the result set in ascending or descending order. Syntax: SELECT expressions FROM table_name WHERE conditions; ORDER BY expression [ ASC | DESC ]; Parameters: expressions: It is used to specify the columns to be retrieved. … Read more
MySQL FROM In MySQL, the FROM clause is used with the MySQL SELECT statement to specify the table for the records to be retrieved. Syntax: To select all fields from a table. SELECT * FROM table_name; Example: Selecting all fields from a table. SELECT * FROM items; Output: ID NAME QUANTITY 1 Electronics 30 2 … Read more
MySQL DISTINCT In MySQL, the DISTINCT clause is used with the SELECT statement to retrieve the unique records from the result set. Syntax: SELECT DISTINCT expressions FROM tables WHERE conditions; Parameters: expressions: It is used to specify the columns to be selected. table_name: It is used to specify the name of the table from which … Read more
MySQL WHERE In MySQL, the WHERE clause is used to filter the results obtained through the SELECT, INSERT, UPDATE, and DELETE statements. Syntax: WHERE conditions; Parameters: conditions: It is used to specify the conditions to be strictly followed for selection. Example: Selecting specific fields from a table. Items table: ID NAME QUANTITY 1 Electronics 30 … Read more
MySQL SELECT In MySQL, the MySQL SELECT statement is used to fetch records from one or more tables stored in the MySQL database. Syntax: To select all fields from a table. SELECT * FROM table_name; Example: Selecting all fields from a table. SELECT * FROM items; Output: ID NAME QUANTITY 1 Electronics 30 2 Sports … Read more
MySQL DELETE: The MySQL DELETE statement is used to eliminate data records from a table. Syntax: DELETE FROM table_name WHERE conditions; Example: Items table before deletion: ID NAME QUANTITY 1 Electronics 30 2 Sports 45 3 Fashion 100 4 Grocery 90 5 Toys 50 DELETE FROM items WHERE id = 3; Explanation: The ‘items’ … Read more