Are column and table name case sensitive in MySQL?

mysql collation case-sensitive
shin picture shin · Jan 5, 2010 · Viewed 37.2k times · Source

If I have a column names called category_id and Category_Id, are they different?

And if I have table called category and Category, are they different?

Answer

Seva Alekseyev picture Seva Alekseyev · Jan 5, 2010

On Unix, table names are case sensitive. On Windows, they are not. Fun, isn't it? Kinda like their respective file systems. Do you think it's a coincidence?

In other words, if you are planning on deploying on a Linux machine, better test your SQL against a Linux-based MySQL too, or be prepared for mysterious "table not found" errors at prod time. VMs are cheap these days.

Field (column) names are case-insensitive regardless.

EDIT: we're talking about the operating system on the MySQL server machine, not client.

Related questions

how to search for exact string in mysql

I'm trying to search for an exact match of a string in mysql. The string is 'nrew'. But when I do the queries below, I still get a result: SELECT UserID FROM sys_users WHERE UserID='NREW' SELECT UserID FROM …

Read More
How do I see what character set a MySQL database / table / column is?

What is the (default) charset for: MySQL database MySQL table MySQL column

Read More
What is the best collation to use for MySQL with PHP?

I'm wondering if there is a "best" choice for collation in MySQL for a general website where you aren't 100% sure of what will be entered? I understand that all the encodings should be the same, such as MySQL, Apache, the …

Read More