ADDTIME() FUNCTION The MySQL ADDTIME function gets a time value after adding a certain time interval. The various versions of MySQL support the ADDTIME function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0 and MySQL 4.1.1. Syntax: ADDTIME( start_value, time ) Parameters: start_value: It is used to specify the time to which … Read more
DATE() FUNCTION The MySQL DATE function is used to extract the date value from a date or datetime expression. The various versions of MySQL support the DATE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0 and MySQL 4.1.1. Syntax: DATE( expression ) Parameters: expression: It is used to specify the date … Read more
ADDDATE() FUNCTION The MySQL ADDDATE function gets a date value after adding a certain time/date interval. The various versions of MySQL support the ADDDATE function, namely, MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, and MySQL 3.23. Syntax: ADDDATE( date, INTERVAL value unit ) OR ADDDATE( date, days ) … Read more
Below is a comparative study of PostgreSQL and MySQL. PostgreSQL MySQL More densely featured database system. Known for its fast speed and ease of use. Unified database server having a single storage engine. Multi-layer structure having a set of storage engines. Provides reliability, data integrity, and developers-friendly features. Generally used with PHP to deal with … Read more
Below is a comparative study of MariaDB and MySQL. MariaDB MySQL Purely open-source and vibrant development environment. Uses a dual licensing model. Less popular comparatively. More popular. Less reliable and less trusted database comparatively. More reliable and trusted database. Developed by a small company. Developed by the Oracle corporation. Released under GPL, LGPL, or BSD. … Read more
MySQL LAST To get the last value of a column, the MySQL LAST function is used. Syntax: SELECT column, FROM table_name ORDER BY column_name DESC LIMIT 1; Example 1: Students Table: ID NAME AGE 1 Joy 10 2 Smiley 13 3 Happy 11 4 James 13 5 Bond 10 Query: SELECT name FROM … Read more
MySQL FIRST The MySQL FIRST function is used to get the first value of a column. Syntax: SELECT column, FROM table_name LIMIT num_rows; Parameters: num_rows: It is used to specify the number of rows to be displayed from the first row of the selected column. Example 1: Students Table: ID NAME AGE 1 Joy 10 … Read more
MySQL MAX In MySQL, the MAX function is used to get the maximum value of an expression. Syntax: SELECT MAX (aggregate_expression) FROM table_name WHERE conditions; Parameters: Aggregate_expression: It is used to specify the column or expression to be utilized by the MAX function. Example: Items table: ID NAME QUANTITY 1 Electronics 30 2 Sports 45 … Read more
MySQL MIN In MySQL, the MIN function is used to get the minimum value of an expression. Syntax: SELECT MIN (aggregate_expression) FROM table_name WHERE conditions; Parameters: Aggregate_expression: It is used to specify the column or expression to be utilized by the MIN function. Example: Items table: ID NAME QUANTITY 1 Electronics 30 2 Sports 45 … Read more
MySQL AVG In MySQL, the AVG function is used to get the average value of an expression. Syntax: SELECT AVG (aggregate_expression) FROM table_name WHERE conditions; Parameters: Aggregate_expression: It is used to specify the column or expression to be utilized by the AVG function. Example: Items table: ID NAME QUANTITY 1 Electronics 30 2 Sports 45 … Read more