[Ritesh]

Hello

The table structure ( or History log ) provided by you doesnt convey much information. Can you send me SQL script of the whole database with information of the columns on which you want to create relationships. You can mail them to [email protected] and I am sure I will come up with an answer 🙂

HTH

[Ritesh]

Hello

After you select a Connection from the dropdown window, the Save button will get activated after you change any of the details 🙄

After changing the details, press Save button and the details will be saved. So next time when you select the connection from the dropdown you will get the correct details for that connection 😀

HTH

[Ritesh]

Hello

First you have to change the table handler to InnoDB and create proper indexes.

You can find more help on MySQL/InnoDB can be found at InnoDB Website

Probably this thread will help you –

Manage Relationship #1

HTH

[Ritesh]

You have to save your connection info by pressing Save button in the connection window 😀

HTH

[Ritesh]

Thanks 😀

[Ritesh]

Yup! 😀

The next version of SQLyog – SQLyog Max would support a number of addional platforms like Mac and Linux

[Ritesh]

Hello

1.) Make sure that both the tables are InnoDB. You can execute

show table status from 'dbname' to know that.

2.) You have proper indexes on the columns which will participate in the FK Relationship.

It will be very helpful if you could post the Create Table statement… of both the tables and the SQL generated by

SQLyog for creating the relationship. You can get the SQL from the History Tab.

HTH

[Ritesh]

Hello

I created a sample table as shown in the images. The create table statement is given as –

Code:

CREATE TABLE `test` (                                                                                                                          
        `id` int(11) NOT NULL default '0',                                                                                                    
        `name` char(20) default NULL,                                                                                                        
        `date_nasc` date default NULL,                                                                                                      
        PRIMARY KEY  (`id`)) TYPE=MyISAM

Using the Insert/Update window of SQLyog, the following SQL scripts are generated –

Code:

insert into `test`.`test` ( `id`, `name`, `date_nasc` ) values (  '1',  'Luciano',  NULL );

update `test`.`test` set  `id`='2',  `name`='Pitto',  `date_nasc`=NULL where id='1';

This is what I expect. Please check the create table stmt. of your table. To set a columns value NULL, set the

focus on the column and press Alt+N.

BTW, which version of SQLyog you are using?

[Ritesh]

Thanks chr .

We will look into this matter 😀

[Ritesh]

You can download one of the following binaries and try it out –

SQLyog 2.51

SQLyog 3.0

SQLyog 3.01

SQLyog 3.02

SQLyog 3.03

HTH

[Ritesh]

Hmmmmmmmmmm…..

Thanks for the idea 😀

I have added it in the TO-DO list

[Ritesh]

Do you have an earlier version of SQLyog. If not tell me, I will send you the binary file. Uninstall SQLyog 3.1 and work with the earlier version of SQLyog and see if the same thing happens.

Please inform me with the details 😮

BTW, Which version of MySQL you are using?

HTH

[Ritesh]

Bewildering 😮 This should work

MySQL client uses the same C API which SQLyog uses to connect to a MySQL server :huh:

Let me check out with my development team and I will post back in a day or two

[Ritesh]

In the MySQL Host Field of Connection Window, give the server address of the machine on which MySQL is installed 😀

[Ritesh]

We will inform you when SQLyog 3.11 comes up 😀

[Author]

Posts