All geek questions in one place

Sometimes a column header name will be converted to lowercase in MySQL windows?

Like accountId accountId

Has anyone encountered such a problem?

This does not happen every day.

+4
source share
2 answers

The homepage is a configuration parameter that is enabled by default for windows (and disabled on Linux). From the docs :

Therefore, case sensitivity the main operating system reproduces part of the case sensitivity of the database and tables. This means the names of the databases and tables are not cases sensitive in Windows, and the case sensitive in most varieties of Unix.

+3
source

What to do when starting SHOW VARIABLES

http://dev.mysql.com/doc/refman/5.1/en/show-variables.html ?

eg. lower_case_table_names?

+3
source

Source: https://habr.com/ru/post/1300296/

More articles:


All Articles