by 永夜 · 2015/01/22
The SQL statement query failed, and the reason for the investigation is the problem of the upper and lower case of the table name!
By editing my.conf’s lower_case_table_names=1, set it to case insensitive
After restarting the mysql server, the sql statement can run normally, but it is generally recommended that the table name, etc. should be as small and lower as possible, and it is best to use all lowercase!
Linux Server Deployment & Operations Consulting
I have extensive experience working with Ubuntu, Debian, Docker, Nginx, and cloud servers in production environments. This includes server deployment, website migration, performance tuning, and long-term maintenance.
Ideal For:
✅ Linux migration projects
✅ Website deployment
✅ Docker-based environments
✅ Nginx optimization
✅ Server performance tuning
What I Offer:
✅ Linux Environment Setup
✅ Website Migration & Deployment
✅ Docker Configuration & Maintenance
✅ Nginx Optimization
✅ Long-Term Technical Support
Please contact me and mention: Linux Operations Consultation.
Contact Me:
Telegram: @shuijingwan
WeChat: 13980074657
Email: shuijingwanwq@gmail.com
Tags: lower_case_table_namesMySQL
![添加外键约束时报错： SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails 。](https://www.shuijingwanwq.com/wp-content/uploads/2022/01/1-11-520x245.png)
