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

Foreign Keys And Myisam

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Foreign Keys And Myisam

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • October 31, 2005 at 5:34 am #9324
      peterlaursen
      Participant

      Foreign Keys/relationships:

      When will webyog finally present a sqlyog version that supports management of foreighn key/relationships for myisam? Most used table engine for mysql is MyISAM. Current Mysql dbms version provides foreign key support for a while now. It is a must.

    • October 31, 2005 at 5:38 am #19631
      CalEvans
      Member
      peterlaursen wrote on Oct 31 2005, 05:34 AM:
      Foreign Keys/relationships:

      When will webyog finally present a sqlyog version that supports management of foreighn key/relationships for myisam? Most used table engine for mysql is MyISAM. Current Mysql dbms version provides foreign key support for a while now. It is a must.

      [post=”7747″]<{POST_SNAPBACK}>[/post]

      Unless things have changed in MySQL 5.0 MyISAM does not support foreign key constraints. Yes, they are necessary that's why I never yse MyISAM tables for anything other than trival tables.

      Next time do a little research before blaming SQLYog. SQLyog can't support a feature that does not exist in MySQL.

      =C=

    • October 31, 2005 at 5:41 am #19632
      peterlaursen
      Participant

      That's impossible as of now!

      The MySQL server can't operate Foreign Keys with MyISAM tables.

      So SQLyog can't possible save such thing to the database.

      However I believe I read at the mySQL webiste that MySQL version 5.1 will allow for Foreing Keys (of some sort). The storage engines for 5.1 are being totally rewritten and a lot of code is moved from the server binaries to the storage engine code. Undoubtedly SQLyog will support it when it becomes possible.

      The first pre-alpha version of 5.1 in out in a source distribution for Linux/Unix only and I have not had a chance to look at it. But I don't think it is there yet. The main 'trick' with mySQL 5.1 is database partitions. The other details come later …

      It typically takes about two years for a new 'main versions' toreach its final stage from the time of the first alpha (and we have only seen a pre-alpha!)

    • October 31, 2005 at 5:51 am #19633
      peterlaursen
      Participant

      Sorry Call .. did not see you.

      Time for cowboys to go to bed! 😀

    • October 31, 2005 at 6:50 am #19634
      peterlaursen
      Participant

      Here is the (little) information about what is new in MySQL 5.1

      http://dev.mysql.com/doc/refman/5.1/en/roadmap.html

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