mysql - How to change sql database name using sql query?

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65915605/how-to-change-sql-database-name-using-sql-query

Answer 1

MS SQL Server: ALTER DATABASE "old_name" MODIFY NAME = "new_name"

MySQL: While there used to exist a simple RENAME DATABASE command in older versions of MySQL which was intended to perform this task, RENAME DATABASE has since been removed from all newer versions to avoid security risks.

Your option is either to dump and reimport the database or to create a new one and move the tables.

There are other options for MySQL and other types too.
Please do a search.