SCHEMA() - Synonym for DATABASE()

SCHEMA() - Synonym for DATABASE()

Q

What's the difference between SCHEMA() and DATABASE() functions?

✍: FYIcenter.com

A

SCHEMA() is a synonym for the DATABASE() function.

Related MySQL functions:

⇒ SESSION_USER() - Synonym for USER()

⇐ ROW_COUNT() - Affected Rows from Last DML Statement

⇑ MySQL Functions on System Information

⇑⇑ MySQL Function References

2025-02-16, 3494🔥, 0💬

Popular Posts:

Generating CREATE TA...

How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...

Drop an Index in Ora...

How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...

Assign Debug Privile...

How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...

FOUND_ROWS() - Row C...

How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function?...

Looping through Quer...

How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...