Are MySQL database and table names case-sensitive?

Actually, the case sensitivity of database and table name depends a lot on the case sensitivity of the underlying operating system. Hence, we can say that such names are not case sensitive in Windows but are case sensitive in most varieties of Unix.

Monica Mona

Published on 19-Feb-2018 06:58:35

• Related Questions & Answers
• How to achieve case sensitive uniqueness and case insensitive search in MySQL?
• How MySQL can perform case-sensitive string comparison?
• How to retrieve table names from a database in MySQL?
• Case-sensitive sort in JavaScript
• Lower case column names with MySQL SELECT?
• Is JavaScript a case sensitive language?
• Case sensitive string comparison in Java.
• How to make SQL case sensitive string comparison in MySQL?
• How do you force MySQL LIKE to be case sensitive?
• Convert the column to a case-sensitive collation in MySQL?
• MySQL Quoted table/field names vs unquoted names?
• MySQL select for exact case sensitive match with hyphen in records
• Display MySQL Database, Table, and Column Information
• Check how many rows are in a MySQL database table?
• How to do case-sensitive string comparison in JavaScript?