List:General Discussion« Previous MessageNext Message »
From:Morgan Tocker Date:January 6 2014 7:24pm
Subject:Re: Foreign-key reference
View as plain text  
On 1/6/2014, 12:21 PM, hsv@stripped wrote:
> Are INNODB foreign-key references ignored in 5.6?

You might be hitting:

"Important
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."

See:
http://dev.mysql.com/doc/refman/5.6/en/alter-table.html

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