I recently made my debut with Amazon web service RDS.So I tried MySQL, but I couldn't insert it into a table with a foreign key because it was a constraint violation.I changed the version, but it didn't change.Does anyone know?
I have confirmed that the insertion, which defines a simple external constraint, works well locally, and that it also works with RDS, so I thought there might be something specific to RDS.
mysql sql aws
Is it local to Windows or Mac OSX?
If so, change the SQL query to match the actual table name because RDS is case sensitive.
For example, if CREATE TABLE says MyTable but mytable says mytable in SQL, you get an error.
Another workaround is to change the value of lower_case_table_names to 1 from the RDS parameter group.However, according to the RDS document, the DB instance needs to be recreated.
© 2024 OneMinuteCode. All rights reserved.