General Rules — Naming Conventions Using lowercase will help speed typing, avoid mistakes as MYSQL is case sensitive. Space replaced with Underscore — Using space between words is not advised. Numbers are not for names — While naming, it is essential that it contains only Alpha English alphabets.
- What are naming conventions in a database?
- What are naming conventions?
- What are the rules for naming a table in MySQL?
- Can MySQL table name be a number?
What are naming conventions in a database?
I've already stated it in the intro, but more generally, a naming convention is a set of rules you decide to go with before you start modeling your database. You'll apply these rules while naming anything inside the database – tables, columns, primary and foreign keys, stored procedures, functions, views, etc.
What are naming conventions?
A naming convention is a convention (generally agreed scheme) for naming things. Conventions differ in their intents, which may include to: Allow useful information to be deduced from the names based on regularities.
What are the rules for naming a table in MySQL?
MySQL Naming Rules
- Legal characters in names. Unquoted names can consist of any alphanumeric characters in the server's default character set, plus the characters '_' and '$'. ...
- Name length. Names for databases, tables, columns, and indexes can be up to 64 characters long. ...
- Name qualifiers. ...
- Server startup mode.
Can MySQL table name be a number?
The answer is yes, as given by karim79, as long as you take care to quote the table names. You could of course use a prefix with a numer, eg. mytable1, mytable2, ... ; that would work without quoting.