Foreign Keys with Non-Alphanumeric Characters in the Database or Table Name Blocks All Inserts and Updates in Child Table: Cannot Add or Update a Child Row: a Foreign Key Constraint Fails
(Doc ID 2011308.1)
Last updated on MARCH 21, 2019
MySQL Server - Version 5.6 to 5.7 [Release 5.6 to 5.7] Information in this document applies to any platform.
When attempting to insert into a table with a foreign key constraint referencing a table with a non-alphanumeric character in the database or table name, the following error occurs:
The foreign key was added with an ALTER TABLE statement.