Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Foreign Key Constraint Post Import Check

forums › forums › SQLyog › Using SQLyog › Foreign Key Constraint Post Import Check

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • February 4, 2011 at 10:08 pm #31922
      peterlaursen
      Participant

      Please clarify: What exact SQLyog feature are you using? From this “I start SQLyog import ..” it is not quite clear to me if it is 'Data Sync' or 'Import external data'.

    • February 7, 2011 at 2:16 pm #31923
      vtest
      Member
      'peterlaursen' wrote:

      Please clarify: What exact SQLyog feature are you using? From this “I start SQLyog import ..” it is not quite clear to me if it is 'Data Sync' or 'Import external data'.

      Import External Data one. Thank you!

    • February 7, 2011 at 3:15 pm #31924
      peterlaursen
      Participant

      What I can come up with right from my head is something like

      Code:
      SELECT * FROM childtable WHERE childcolumn NOT IN (SELECT parentcolumn FROM parenttable);

      But the inner query will generate a temporary table in memory. It should be possible to write it as a JOIN using indexes (if proper indexes exist on the table)

    • February 8, 2011 at 5:18 am #31925
      vishal.pr
      Member

      Its because SET FOREIGN_KEY_CHECKS = 0;

      Read this http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.