SQL – MySQL DAYOFMONTH() Function
April 24, 2023
The MySQL DAYOFMONTH() function returns the day of the month for a given date (a number from 1 to 31).
SQL – MySQL DAYOFWEEK() Function
April 26, 2023
The MySQL DAYOFWEEK() function returns the weekday index for a given date (a number from 1 – Sunday to 7 – Saturday).
SQL – MySQL DAYOFYEAR() Function
April 27, 2023
The MySQL DAYOFYEAR() function returns the day of the year for a given date (a number from 1 to 366).
SQL – MySQL DEGREES() Function
March 19, 2023
The MySQL DEGREES() function converts a value in radians to degrees.
SQL – MySQL DIV Function
March 20, 2023
The MySQL DIV function is used for integer division (x is divided by y).
SQL – MySQL EXP() Function
March 21, 2023
The MySQL EXP() function returns the natural logarithm e (2.718281…) raised to the power of the specified number.
SQL – MySQL EXTRACT() Function
April 28, 2023
The MySQL EXTRACT() function extracts a part from a given date.
SQL – MySQL FIELD() Function
June 13, 2023
The MySQL FIELD() function returns the index position of a case-insensitive value in a list of values.
SQL – MySQL FIND_IN_SET() Function
June 13, 2023
The MySQL FIND_IN_SET() function returns the position of a string within a list of strings.
SQL – MySQL FLOOR() Function
April 6, 2023
The MySQL FLOOR() function returns the largest integer value that is smaller than or equal to a number.
SQL – MySQL FORMAT() Function
June 13, 2023
The MySQL FORMAT() function formats a number to a format like “#,###,###.##”, rounded to a specified number of decimal places, and returns it as a string.
SQL – MySQL FROM_DAYS() Function
April 29, 2023
The MySQL FROM_DAYS() function returns a date from a numeric datevalue.
SQL – MySQL GREATEST() Function
March 23, 2023
The MySQL GREATEST() function returns the greatest value of the list of arguments.
SQL – MySQL HOUR() Function
April 30, 2023
The MySQL HOUR() function returns the hour part for a given date (from 0 to 838).
SQL – MySQL IF() Function
June 8, 2023
The MySQL IF() function returns a value if a condition is TRUE, or another value if a condition is FALSE.
SQL – MySQL IFNULL() Function
June 9, 2023
The MySQL IFNULL() function returns a specified value if the expression is NULL.
SQL – MySQL INSERT() Function
June 13, 2023
The MySQL INSERT() function inserts a string within a string at the specified position and for a certain number of characters.
SQL – MySQL INSTR() Function
June 13, 2023
The MySQL INSTR() function returns the position of the first occurrence of a case-insensitive string in another string.
SQL – MySQL ISNULL() Function
June 10, 2023
The MySQL ISNULL() function returns 1 (null) or 0 (not null) depending on whether an expression is NULL.
SQL – MySQL LAST_INSERT_ID() Function
June 11, 2023
The MySQL LAST_INSERT_ID() function returns the AUTO_INCREMENT id of the last row that has been inserted or updated in a table.
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
HTML
CSS
JavaScript
jQuery
PHP
SQL
WordPress
Why 1SMARTchicken?
This site was built and is maintained to benefit my autistic son.
See More →
See More →
Thanks for your support!
Books
All are affiliate links. Thank you for your support!
