List:General Discussion« Previous MessageNext Message »
From:hsv Date:January 7 2014 3:31pm
Subject:Re: Foreign-key reference
View as plain text  
>>>> 2014/01/06 14:24 -0500, Morgan Tocker >>>>
You might be hitting:

The inline REFERENCES specifications where the references are defined as part of the
column specification are silently ignored. MySQL only accepts REFERENCES clauses defined
as part of a separate FOREIGN KEY specification."

Ugh, that seems quite right. Now, why did they do that?

A separate specification is less convenient, and also less transparent.

Foreign-key referencehsv6 Jan
  • Re: Foreign-key referenceMorgan Tocker6 Jan
    • Re: Foreign-key referencehsv7 Jan
      • Re: Foreign-key referenceMorgan Tocker7 Jan
  • Re: Foreign-key referenceReindl Harald6 Jan