📄️ EXISTS
The exists condition is used in combination with a subquery and is considered "to be met" if the subquery returns at least one row.
Other Functions
📄️ HUMANIZE_NUMBER
Returns a readable number.
📄️ HUMANIZE_SIZE
Returns the readable size with a suffix(KiB, MiB, etc).
📄️ IGNORE
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.
📄️ TYPEOF
TYPEOF function is used to return the name of a data type.