Node.js + MySQL how to name tables, columns?

Question

MySQL

I write backend on node, database on mysql. To make everything look in the same style, I use camelCase on the front / backend / database. is this correct for db? It seems that snake_case is accepted in mysql. How to be?

Answer 1

There is no need to use camelCase or snake_case. But since mysql converts all names to lowercase (case insensitive), all capital letters in the base are lost. So it's better - snake_case - it will be clear.