Is there a naming convention for tables in MySQL?

No, MySQL does not have a preferred naming convention standard. If the name we have chosen is logical and consistent then it would be ok.

Two major points need to be remembered, one is that no two tales/databases can have the same name and second we can choose any of the reserved words as the name of table/database.