SQL – MySQL UPPER() Function
The MySQL UPPER() function converts a string to upper case.
SQL – MySQL USER() Function
The MySQL USER() function returns the current user name and host name for the MySQL connection.
SQL – MySQL VERSION() Function
The MySQL VERSION() function returns the current version of the MySQL database, as a string.
SQL – MySQL WEEK() Function
The MySQL WEEK() function returns the week number for a given date (a number from 0 to 53).
SQL – MySQL WEEKDAY() Function
The MySQL WEEKDAY() function returns the weekday number for a given date.
SQL – MySQL WEEKOFYEAR() Function
The MySQL WEEKOFYEAR() function returns the week number for a given date (a number from 1 to 53).
SQL – MySQL YEAR() Function
The MySQL YEAR() function returns the year part for a given date (a number from 1000 to 9999).
SQL – MySQL YEARWEEK() Function
The MySQL YEARWEEK() function returns the year and week number (a number from 0 to 53) for a given date.
SQL – List of MySQL Advanced Functions
This is a quick reference list of MySQL advanced functions and how they are used to work with databases.
SQL – List of MySQL Date Functions
This is a quick reference list of MySQL date functions and how they are used to work with databases.
SQL – List of MySQL Numeric Functions
This is a quick reference list of MySQL numeric functions and how they are used to work with databases.
SQL – List of MySQL String Functions
This is a quick reference list of MySQL string functions and how they are used to work with databases.
SQL – Show all Databases on the Server
This shows all databases on the server, and is handy when looking for a specific database in the system or if you’re acclimating yourself to a new system.