2

Showing full MySQL foreign key errors

 3 years ago
source link: https://stitcher.io/blog/mysql-show-foreign-key-errors
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
Showing full MySQL foreign key errors

Scout APM helps PHP developers pinpoint N+1 queries, memory leaks & more so you can troubleshoot fast & get back to coding faster. Start your free 14-day trial today.

« back — written by Brent on February 13, 2018

Showing full MySQL foreign key errors

In case of a foreign key error when creating or altering a table, MySQL doesn't show the full message.

You can read the full message by executing the following query and inspecting the Status column.

show engine innodb status;
------------------------
LATEST FOREIGN KEY ERROR
------------------------
2018-02-13 11:12:26 0x70000b776000 Error in foreign key constraint of table table/#sql-7fa_247a:
 foreign key (`my_foreing_key`) references `table` (`id`)
   on delete cascade:
Cannot resolve table name close to:
 (`id`)
   on delete cascade

Next up:  MySQL query logging

Follow me: Twitter — RSS — Newsletter — Patreon — GitHub

© 2021 stitcher.io — Cookies & Privacy


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK