In MySQL, the ICU_VERSION() function returns the version of the International Components for Unicode (ICU) library used to support regular expression operations.
The ICU_VERSION() function is primarily intended for use in test cases.
what is
How CURRENT_ROLE() Works in MySQL
In MySQL, CURRENT_ROLE() is a built-in function that returns the current active roles for the current session, separated by commas, or NONE if there are none. The current role determines our access privileges.
MySQL COERCIBILITY() Explained
In MySQL, the COERCIBILITY() returns the collation coercibility value of its string argument.
The COERCIBILITY() function defines how collations will be converted in the case of collation conflict. In such conflicts, an expression with a higher coercibility is converted to the collation of an expression with a lower coercibility.
How CONNECTION_ID() Works in MySQL
The MySQL CONNECTION_ID() function returns the connection ID (thread ID) for the connection.
In MySQL, every connection has an ID that is unique among the set of currently connected clients. We can use the CONNECTION_ID() function to return that ID.
How SETVAL() Works in PostgreSQL
In PostgreSQL, we can use the setval() function to set a sequence’s value.
We specify the value when we call the function. We also have the option of setting its is_called flag.
SQL Server FOR XML Explained
In SQL Server, the FOR XML clause allows us to return the results of a query as an XML document.
When we use this clause, we have various options for how we want to shape the resulting XML document.
Below is an explanation of how the FOR XML clause works, including the basic options we have when using it.
How CURRVAL() Works in PostgreSQL
In PostgreSQL, the currval() function returns the value most recently returned by nextval() for the specified sequence in the current session.
The currval() function is very similar to the lastval() function, except that lastval() doesn’t require the name of a sequence like currval() does. That’s because lastval() doesn’t report on any particular sequence – it reports on the last time nextval() was used in the current session, regardless of which sequence was used. The currval() on the other hand, only reports on the specified sequence.
How LASTVAL() Works in PostgreSQL
In PostgreSQL, the lastval() function returns the value most recently returned by nextval() in the current session.
The lastval() function is very similar to the currval() function, except that lastval() doesn’t require the name of a sequence like currval() does. That’s because lastval() doesn’t report on any particular sequence – it reports on the last time nextval() was used in the current session, regardless of which sequence was used.
How NEXTVAL() Works in PostgreSQL
In PostgreSQL, the nextval() function is used to advance sequence objects to their next value and return that value. We pass the name of the sequence when we call the function. This assumes that the sequence object exists.
@@ROWCOUNT vs ROWCOUNT_BIG() in SQL Server
SQL Server provides us with both a @@ROWCOUNT and a ROWCOUNT_BIG() function. You may be wondering what the difference is between these two functions?
Let’s find out.