[peterlaursen]

Reproduced with MySQL 5.0.28.

if you do as you describe SQLyog generates the query:

Code:

update `gageball` set `GB_Name`='adarsh',`GB_Tolerance`='0.003000',`GB_Slope_1`='1.000000',`GB_Slope_2`='0.961500',
`GB_Slope_3`='0.980400',`GB_Slope_4`='1.020400',`GB_Slope_5`='0.980400',`GB_Slope_6`='1.041700',
`GB_Slope_7`='0.961500',`GB_Slope_8`='1.020400',`GB_Slope_9`='0.961500',`GB_Slope_10`='1.000000',
`GB_Min_Size`='1.674670',`GB_Max_Size`='1.685770',`GB_Zero_Size`='1.680220',`GB_Calibration_Range`='0.006000',
`GB_Offset_1`='1.679466',`GB_Offset_2`='1.680230',`GB_Offset_3`='1.680833',`GB_Offset_4`='1.679626',
`GB_Offset_5`='1.680400' where `GB_Name`='Master' and `GB_Tolerance`='0.003000' and `GB_Slope_1`='1.000000' and `GB_Slope_2`='0.961500' and `GB_Slope_3`='0.980400' and `GB_Slope_4`='1.020400' and `GB_Slope_5`='0.980400' and `GB_Slope_6`='1.041700' and `GB_Slope_7`='0.961500' and `GB_Slope_8`='1.020400' and `GB_Slope_9`='0.961500' and `GB_Slope_10`='1.000000' and `GB_Min_Size`='1.674670' and `GB_Max_Size`='1.685770' and `GB_Zero_Size`='1.680220' and `GB_Calibration_Range`='0.006000' and `GB_Offset_1`='1.679466' and `GB_Offset_2`='1.680230' and `GB_Offset_3`='1.680833' and `GB_Offset_4`='1.679626' and `GB_Offset_5`='1.680400'

now try

Code:

select * from `gageball`
where `GB_Name`='Master' and `GB_Tolerance`='0.003000' and `GB_Slope_1`='1.000000' and `GB_Slope_2`='0.961500' and `GB_Slope_3`='0.980400' and `GB_Slope_4`='1.020400' and `GB_Slope_5`='0.980400' and `GB_Slope_6`='1.041700' and `GB_Slope_7`='0.961500' and `GB_Slope_8`='1.020400' and `GB_Slope_9`='0.961500' and `GB_Slope_10`='1.000000' and `GB_Min_Size`='1.674670' and `GB_Max_Size`='1.685770' and `GB_Zero_Size`='1.680220' and `GB_Calibration_Range`='0.006000' and `GB_Offset_1`='1.679466' and `GB_Offset_2`='1.680230' and `GB_Offset_3`='1.680833' and `GB_Offset_4`='1.679626' and `GB_Offset_5`='1.680400'

and nothing is returned!

If you add a primary key to the table SQLyog will generate a where-clause like

Code:

WHERE `the_pk` = 'the pk_value'

.. and it works too!!

This is a bug with the DECIMAL implementation with MySQL 5.0.27-28  

It is known that this will occur with FLOAT and DOUBLE types as they are not exact.

It should not be the situation with DECIMALS. But it was!

I think it is a coincidence that you upgraded MySQL at about the same time as you upgraded SQLyog to version 5.22.

Just upgrade your MySQL server to 5.0.37!

But still: having a primary key in a table is always recommended – and you should!

And whenever you have such problem try to understand the SQL in the HISTORY tab!

[peterlaursen]

We do not reply to emails.  We reply in the Forums itself.  That is the idea with a Forum!

To create a Foreign Key you will first have to

1) create the' parent' and the 'child table'

2) next select 'manage foreign keys' in the child table context menu and select the column in the parent table that shall be the FK of the child column

3) Note that with older MySQL versions you will first need to create indexes manually on the two columns

Please refer to the program help file.  Everything is explained here.

[peterlaursen]

I am not sure that I understand “dropdown list of items from a table”

If you mean restricting the column content to certain values the answer is only when the data type is ENUM or SET.

SQLyog does not store information obout the databases.  It queries the server.  If SQLyog did store some other client might change the data in the database and the information stored by SQLyog would become obsolete.

If you mean that the column `PLACES` itself shall be replaced with another column then the Query Builder that will sh

p sonn will be able to do this.

[peterlaursen]

please check (allow 10 minutes for upload) and report back:

http://www.webyog.com/downloads/betas/not_…;/SQLyog526.exe (community)

http://www.webyog.com/downloads/betas/not_…Lyog526Ent.exe (registered)

http://www.webyog.com/downloads/betas/not_…26EntTrial.exe (trial)

[peterlaursen]

moving your post to the SQLyog category!

[peterlaursen]

not reproducable here 'in first shot'.

With your example I can and for minutes.

With more data in the grid I can ,, and in any pattern also without problems.

What is your OS? Any other details you think could be useful?

[peterlaursen]

graphing is coming of course.

Currently we are implementing a database in the system. A background thread is inserting to the database and the browser will be 'fed' from the database (and not directly from the data stream form the MySQL databases(s) as now). After that we can display not only the latest set of data, but time-series of data – and that can be graphed. That was the idea all the time.

Also the Flash graph components are basically done – we only need to feed them with data – and then of course do whatever adjustments are required.

The database component will be funtional by beginning/mid next week and then give us about 2 weeks more and the first version with graphics included should be there.

[peterlaursen]

OK we discussed!

Please confirm that this is the issue!

create table `aaa` (

`a` double ,

`b` varchar (20));

insert into `aaa` (`a`, `b`) values('1','ada');

insert into `aaa` (`a`, `b`) values('2','dad');

insert into `aaa` (`a`, `b`) values('3','pel');

1) higlight the '1' in 1st column and first row of the grid.

2) right-click on the 2nd column of 1st row of the grid (showing 'ada') and SET to NULL.

3) save by pressing 'arrow down' or save button.

SQLyog sends the SQL (refer to HISTORY):

“UPDATE `aaa` SET `a`='1',`b`='1' WHERE `a`='1' AND `b`='ada'”

and the cell that displayed 'ada before displas '1' and not '(NULL)'

Was that it? Correctly understood this time?

This is a bug, sure!

Your example displaying the same row more than once confused me.

Please also create a simple and complete test case (with CREATE statement(s) and data) like this when you report an issue.

Chances that everybody understands 'in first shot' is bigger then.

[peterlaursen]

Please confirm if my test case is a description of the problem??

the same column is selected twice, right?

If not so then please explain more in details!

[peterlaursen]

No way as of now!

[peterlaursen]

We cannot import that XML file!

It says INSERT INTO … SELECT FROM something we do not have!

'Backup as SQL dump' from the table menu of SQLyog, please,

[peterlaursen]

MySQL supports both 'Primary Keys' and 'Unique Indexes' – and also SQLyog supports both.

In SQLyog you define the Primary Key from 'CREATE/ALTER table' – Unique Keys form 'Manage Indexes' from the table (context) menu.

A PK is unique.  There can only be one PK in a table.  There can be more unique indexes, however.  Often the PK is based on a autoincremented Integer column.  This is practical in a lot of situations but any unique (combination) of column(s) can be the PK.

There need not be a PK, but it is recommended.  SQLyog uses the PK efficiently when updating and deleting from the DATA and RESULT grids.  Also with SQLyog/SJA data synchronisation you will benefit from having a PK. 

[peterlaursen]

Please also read:

http://webyog.com/faq/8_147_en.html

[peterlaursen]

Was it possible that you gave a SQL-dump?

[peterlaursen]

Just follow the links on http://www.mysql.com and select a mirror.

Her is a link to MySQL 5.0.37 (32 bit – with the MSI installer) from a mirror in Denmark:

ftp://mirrors.dotsrc.org/mysql/Downloads/….0.37-win32.zip

[Author]

Posts