Results in an equivalent non-Nullable value for a Nullable type. In case the original value is NULL the result is undetermined.
Checks from left to right whether NULL arguments were passed and returns the first non-NULL argument.
The exists condition is used in combination with a subquery and is considered "to be met" if the subquery returns at least one row.
Returns a readable number.
Returns the readable size with a suffix(KiB, MiB, etc).
By using insert ignore statement, the rows with invalid data that cause the error are ignored and the rows with valid data are inserted into the table.
Converts the argument type to Nullable.
TYPEOF function is used to return the name of a data type.