CODEWITHSUNDEEP
databasenumbersnamingconvention
rjmcb
rjmcb

Reputation: 3745

Numbers on table name

Is it okay that I use numbers for table names in my database

For example

 create table `tbl_love143`;

Is it a good naming convention?

Upvotes: 0

Views: 130

Answers (1)

ColinE
ColinE

Reputation: 70142

If your database engine permits numbers, I see no reason not to use them. However, given your example of tbl_love143, does this mean you have 142 other 'love' tables? if so, there is something seriously wrong with your database design!

In summary, numbers are fine, but having multiple tables that store the same 'type' of information is not.

Upvotes: 2

Related Questions