A database name in MySQL can be any valid string that follows the naming rules:
- It must start with a letter or an underscore, followed by letters, numbers, or underscores.
- It should be less than 64 characters long.
- It cannot contain spaces or special characters, except for underscores.
Examples of valid database names in MySQL:
- my_database_name
- customer_data
- uk_data_2023
- __my_private_data
In order to maintain brevity we have created a GIF that is demonstrative and will help to create a new database in MySql faster.
Leave a Reply