Do underscores in a MySQL table names cause issues?

Viewed 50982

Do underscores in table names affect performance or cause issues on some platforms?

For example, user_profiles

Would it be better to use userProfiles or is it just a matter of personal preference?

11 Answers

You can simply add grave accent (`) before and after column name. For example:

CREATE TABLE USERS(
   `PERSON_ID` NVARCHAR(100),
   `FNAME` NVARCHAR(255), 
   `LNAME` NVARCHAR(255),
   PRIMARY KEY (`PERSON_ID`)
);
Related