MySQL COUNT In MySQL, the COUNT function is used to get the count of an expression. Syntax: SELECT COUNT (aggregate_expression) FROM table_name WHERE conditions; Parameters: Aggregate_expression: It is used to specify the column or expression to be utilized by the COUNT function. Example: Items table: ID NAME QUANTITY 1 Electronics 30 2 Sports 45 3 … Read more
MySQL SUM In MySQL, the SUM function is used to get the summed value of an expression. Syntax: SELECT SUM (aggregate_expression) FROM table_name WHERE conditions; Parameters: Aggregate_expression: It is used to specify the column or expression to be utilized by the SUM function. Example: Items table: ID NAME QUANTITY 1 Electronics 30 2 Sports 45 … Read more
MySQL JOINS In MySQL, the Join Query is used to fetch records from multiple tables. Types of Joins: There are three types of Joins that the MySQL database supports. These are: Inner or Simple Join Left Outer Join Right Outer Join INNER JOIN The INNER Join returns all the rows from multiple tables. Syntax: SELECT … Read more
MySQL BETWEEN In MySQL, the BETWEEN condition is used to get values within a specific range from an expression in the SELECT, INSERT, UPDATE, and DELETE statements. Syntax: WHERE expression BETWEEN value1 AND value2; Parameters: expression: It is used to specify the column or field. value1, value2: They are used to specify the range for … Read more
MySQL AND OR In MySQL, the AND and OR conditions are also used in combination to filter the results obtained through the SELECT, INSERT, UPDATE, and DELETE statements based on more than one condition. Syntax: WHERE condition_1 AND condition_2 .. OR condition_n; Parameters: condition_1, condition_2… condition_n: They specify the conditions to be strictly followed for … Read more
MySQL OR In MySQL, the OR condition filters the results obtained through the SELECT, INSERT, UPDATE, and DELETE statements based on multiple conditions. Syntax: WHERE condition_1 OR condition_2 OR condition_3 …. OR condition_n; Parameters: condition_1, condition_2… condition_n: They specify the conditions to be strictly followed for selection. Example: Items table: ID NAME QUANTITY 1 Electronics … Read more
MySQL AND In MySQL, the AND condition filters the results obtained through the SELECT, INSERT, UPDATE, and DELETE statements based on multiple conditions. Syntax: WHERE condition_1 AND condition_2 AND condition_3 …. AND condition_n; Parameters: condition_1, condition_2… condition_n: They specify the conditions to be strictly followed for selection. Example: Items table: ID NAME QUANTITY 1 Electronics … Read more
MySQL IS NOT NULL To filter the results, the MySQL IS NOT NULL condition is used with SELECT, INSERT, UPDATE, and DELETE statements to check for NOT NULL values. Syntax: WHERE expression IS NOT NULL; Parameters: expression: It is used to specify a column or a field to be tested. Example: Students table: ID NAME … Read more
MySQL IS NULL To filter the results, the MySQL IS NULL condition is used with SELECT, INSERT, UPDATE, and DELETE statements to check for a NULL value. Syntax: WHERE expression IS NULL; Parameters: expression: It is used to specify a column or a field to be tested. Example: Students table: ID NAME AGE 1 Joy … Read more
MySQL NOT In MySQL, the NOT condition is used to negate a condition in SELECT, INSERT, UPDATE, and DELETE statements. Syntax: NOT condition; Parameters: condition: It is used to specify the conditions to negate. Example 1: Using NOT with LIKE condition. Items table: ID NAME QUANTITY 1 Electronics 30 2 Sports 45 3 Fashion 100 … Read more