先来看下MySQL找个参数的含义：

• lower_case_table_names=0 表名存储为给定的大小和比较是区分大小写的
• lower_case_table_names = 1 表名存储在磁盘是小写的，但是比较的时候是不区分大小写
• lower_case_table_names=2 表名存储为给定的大小写但是比较的时候是小写的
  unix,linux下lower_case_table_names默认值为 0 .Windows下默认值是 1 .Mac OS X下默认值是 2

1开启表示忽略大小写，即大写与小写没区别

mysql> show variables like '%table_names%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 1     |
+------------------------+-------+
1 row in set (0.00 sec)

mysql> create table haha (id int);
Query OK, 0 rows affected (0.04 sec)

mysql> create table HAHA (id int);
ERROR 1050 (42S01): Table 'haha' already exists
mysql> select * from HAha;
Empty set (0.00 sec)

LightDB中开启改参数

该参数不支持动态修改

test@mysql_test=# show %table_names%;
                 name                 | setting |                                 description                                  
--------------------------------------+---------+------------------------------------------------------------------------------
 lightdb_mysql_lower_case_table_names | on      | Show the lower case status in MySQL compatibility mode for current database.
(1 row)
test@mysql_test=# create table haha (id int);
CREATE TABLE
test@mysql_test=# create table HAHA (id int);
ERROR:  relation "haha" already exists

test@mysql_test=# set lightdb_mysql_lower_case_table_names = off;
ERROR:  parameter "lightdb_mysql_lower_case_table_names" cannot be changed

创建库的时候指定为off

lightdb@postgres=# create database mysqltest lightdb_syntax_compatible_type mysql lightdb_mysql_lower_case_table_names 0;
CREATE DATABASE
lightdb@postgres=# create database mysqltest1 lightdb_syntax_compatible_type mysql lightdb_mysql_lower_case_table_names=0; 
CREATE DATABASE
lightdb@postgres=# create database mysqltest2 lightdb_syntax_compatible_type=mysql lightdb_mysql_lower_case_table_names=0; 
CREATE DATABASE

详情参考
https://blog.csdn.net/yunmu666/article/details/132283370?spm=1001.2014.3001.5501