In MySQL, COLLATION() is a built in function that returns the collation of its string argument.
We provide the string when we call the function.
Continue readingTag: functions
CHARSET() Function in MySQL
In MySQL, CHARSET() is a built in function that returns the character set of its string argument.
We provide the string when we call the function.
Continue readingHow CONVERT() Works in MySQL
In MySQL, CONVERT() is a built in function that converts a value to another data type. It takes a value of one type and returns a value of the specified type.
We provide the value as an argument when we call the function, as well as the type that we want it converted to.
The CONVERT() function is similar to the CAST() function, which also converts between data types.
MySQL ROW_COUNT() Explained
In MySQL, ROW_COUNT() is a built-in function that returns the number of rows updated, inserted, or deleted by the preceding statement.
The value returned by ROW_COUNT() is often the same as the row count that the mysql client displays following statement execution, as well as the value from the mysql_affected_rows() C API function.
SQLite CHANGES() Function
The SQLite changes() function returns the number of database rows that were changed, inserted or deleted by the most recently completed INSERT, DELETE, or UPDATE statement, exclusive of statements in lower-level triggers.
Basically, it allows us to see how many rows are affected when we run any of those statements.
Continue readingFORMAT_BYTES() in MySQL
In MySQL, FORMAT_BYTES() is a built in function that converts a numeric byte count to a more human-readable format. It returns a string consisting of the value and a units indicator.
We provide the numeric byte count when we call the function.
Continue readingMySQL VERSION() Explained
In MySQL, VERSION() is a built-in function that returns the MySQL server version.
The result is a string that uses the utf8mb3 character set. A suffix may also be appended to the version number indicating server build or configuration information.
MySQL SESSION_USER() Explained
In MySQL, SESSION_USER() is a synonym for the USER() function. It returns the current MySQL user name and host name, given when connecting to MySQL.
MySQL SYSTEM_USER() Explained
In MySQL, SYSTEM_USER() is a synonym for the USER() function. It returns the current MySQL user name and host name, given when connecting to MySQL.
MySQL CURRENT_USER() Explained
In MySQL, CURRENT_USER() is a built-in function that returns the user name and host name combination for the MySQL account that the server used to authenticate the current client.