Naming
Generic
Do
-
Use meaningful names.
-
Use lower_case_underscores.
-
The length of db name should be less than 42
-
The length of table name should be less than 48
-
The length of username should be less than 32
-
Avoid MySQL reserved keywords as a column‘s name
-
e.g., keyword or reserved words , like: name, status, type, data, description, level, host, port……
-
dangerous words ,like : rm, truncate ,delete……
-
confusion words , like : master, slave ,( which is a MySQL Replication role.)
