This is the first GA release in a new major branch of the SQLyog MySQL GUI.
This release introduces an easy way to look up proper values for values inserted to columns that have a Foreign Key CONSTRAINT. Foreign Key CONSTRAINTs can be difficult to handle for a human user because when updating a ‘child’ table valid values for columns that have such CONSTRAINTs in the ‘child’ table will often be ‘just a code’ ( an autoincrement integer or some very ‘compressed’ and ‘symbolic’ values (like item numbers, order numbers etc.).
This SQLyog release provides a direct way to look up …[Read more...]