Leetcode Second Highest Salary

Write the first Leetcode database of the topic, this is really a god pit, leetcode the case to distinguish the problem, this serious record:

MySQL under Linux:

1. The database name and table name are strictly size-sensitive.

2. The alias of the table is also strictly case-sensitive.

3. The names of the columns and the aliases of the columns are ignored and case-insensitive in all cases.

4. Variable names are also strictly case-sensitive.

Windows is so moral integrity, it's just, it's an operating system. The table name is not case-sensitive, so I do not know the situation of the crazy change.

So in different operating systems in order to make the program and database can work properly, the best way is to be in the design of the time to lowercase, but if the design has been normalized case, then in the Windows environment as long as the configuration of the database to make changes to the line, the specific operation is as follows:

Add a line in the MySQL configuration file My.ini [mysqld]

Lower_case_table_names = 1

Parameter explanation:

0: Case Sensitive

1: Case insensitive

Leetcode Second Highest Salary