Collections:
Function Name Case Insensitive
Are MySQL function names case sensitive?
✍: FYIcenter.com
No. MySQL function names are not case sensitive. You can write function names in upper case or lower case. For example:
SELECT PI(), pi(), Pi(); -- +----------+----------+----------+ -- | PI() | pi() | Pi() | -- +----------+----------+----------+ -- | 3.141593 | 3.141593 | 3.141593 | -- +----------+----------+----------+
Function argument modifiers are also not case sensitive. For example:
SET @str = 'Yahooo'; SELECT TRIM(BOTH 'o' FROM @str), trim(both 'o' from @str); -- +--------------------------+--------------------------+ -- | TRIM(BOTH 'o' FROM @str) | trim(both 'o' from @str) | -- +--------------------------+--------------------------+ -- | Yah | Yah | -- +--------------------------+--------------------------+
⇐ Calling MySQL Built-in Functions
2023-11-15, 257🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...