SQL – MySQL CONNECTION_ID() Function
June 3, 2023
The MySQL CONNECTION_ID() function returns the unique connection ID for the current connection.
SQL – MySQL CONV() Function
June 4, 2023
The MySQL CONV() function converts a number from one numeric base system to another, and returns the result as a string value.
SQL – MySQL CONVERT() Function
June 5, 2023
The MySQL CONVERT() function converts a value into the specified datatype or character set.
SQL – MySQL COT() Function
March 17, 2023
The MySQL COT() function returns the cotangent of a number.
SQL – MySQL COUNT() Function
June 27, 2023
The MySQL COUNT() function returns the number of records returned by a select query. NULL values are not counted.
SQL – MySQL CURDATE() Function
April 14, 2023
The MySQL CURDATE() function returns the current date as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
SQL – MySQL CURRENT_DATE() Function
April 14, 2023
The MySQL CURRENT_DATE() function returns the current date as “YYYY-MM-DD” (string) or as YYYYMMDD (numeric).
SQL – MySQL CURRENT_TIME() Function
April 15, 2023
The MySQL CURRENT_TIME() function returns the current time as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
SQL – MySQL CURRENT_TIMESTAMP() Function
April 16, 2023
The MySQL CURRENT_TIMESTAMP() function returns the current date and time as “YYYY-MM-DD HH-MM-SS” (string) or as YYYYMMDDHHMMSS.uuuuuu (numeric).
SQL – MySQL CURRENT_USER() Function
June 6, 2023
The MySQL CURRENT_USER() function returns the user name and host name for the MySQL account that the server used to authenticate the current client.
SQL – MySQL CURTIME() Function
April 17, 2023
The MySQL CURTIME() function returns the current time as “HH-MM-SS” (string) or as HHMMSS.uuuuuu (numeric).
SQL – MySQL DATABASE() Function
June 7, 2023
The MySQL DATABASE() function returns the name of the current database. If there is no current database, this function returns NULL or “”.
SQL – MySQL DATE() Function
April 18, 2023
The MySQL DATE() function extracts the date part from a datetime expression.
SQL – MySQL DATEDIFF() Function
April 19, 2023
The MySQL DATEDIFF() function returns the number of days between two date values.
SQL – MySQL DATE_ADD() Function
April 22, 2023
The MySQL DATE_ADD() function adds a time/date interval to a date and then returns the date.
SQL – MySQL DATE_FORMAT() Function
April 25, 2023
The MySQL DATE_FORMAT() function formats a date as specified.
SQL – MySQL DATE_SUB() Function
April 22, 2023
The MySQL DATE_SUB() function subtracts a time/date interval from a date and then returns the date.
SQL – MySQL DAY() Function
April 22, 2023
The MySQL DAY() function returns the day of the month for a given date (a number from 1 to 31).
SQL – MySQL DAYNAME() Function
April 23, 2023
The MySQL DAYNAME() function returns the weekday name for a given date.
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!
