Re: Foreign key constraints missing from SHOW CREATE TABLE output

[tom worster]

This is very confusing.

SQL_MODE was set to 'ANSI_QUOTES' when I was experimenting and when I generated the examples quoted in the OP.

Today the constraints are included in the SHOW CREATE TABLE output. This is true whether I have SQL_MODE set to 'ANSI_QUOTES' or to ''.

That's the only thing I remember changing in SQL_MODE.

The only other thing I can imagine is that PHPMyAdmin generated an SQL_MODE setting in its export output and I used that. While I haven't done that for some time, it's possible that a setting might have been hanging around and then, when I restarted mysqld today after a system crash, it got cleared.