MySQL表名忽略大小写问题记录

发表于 2025-11-04 19:45:27 来源：全栈开发

名忽复制mysql> show tables; +-------------------------------------------+ | Tables_in_huan_db | +-------------------------------------------+ | advertisement | | message_queue | | message_sys_user | | message_user | | opHistory | | opHistory_queue | | opHistory_queue_result_log | | opHistory_queue_send_fail_log | +-------------------------------------------+ 8 rowsinset (0.00 sec) mysql> desc opHistory; ERROR 1146 (42S02): Tablehaun_db.opHistory doesnt exist mysql> desc opHistory_queue; ERROR 1146 (42S02): Tablehaun_db.opHistory_queue doesnt exist mysql> desc opHistory_queue_result_log; ERROR 1146 (42S02): Tablehaun_db.opHistory doesnt exist mysql> desc opHistory_queue_send_fail_log; ERROR 1146 (42S02): Tablehaun_db.opHistory_queue_send_fail_log doesnt exist 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.

喜欢86讨厌30

随机为您推荐