patternsqlMinor
MySQL database naming convention?
Viewed 0 times
databasemysqlconventionnaming
Problem
Is there any convention for database names in MySQL/MariaDB? I've searched Google and this Stack Exchange and haven't been able to find anything. Not even a "Nope, there's no official convention." Is there a standard, or is this something that's decided on a case-by-case basis?
Thank you.
Thank you.
Solution
Database names are completely up to the person creating them. Having said that, it makes sense to use some kind of sane naming convention.
Don't use reserved keywords, don't put spaces in the name, etc. Essentially, follow the MySQL Documentation for identifiers, and add a little common sense that applies to your environment.
Don't use reserved keywords, don't put spaces in the name, etc. Essentially, follow the MySQL Documentation for identifiers, and add a little common sense that applies to your environment.
Context
StackExchange Database Administrators Q#207864, answer score: 6
Revisions (0)
No revisions yet.