[sqldave]

Thank you for your response.

So, I made sure that, for all 25 tables in my db, the LIMIT was UNCHECKED.

I repeatedly checked all tables to see if they kept the setting. YES, they did.

I then exited Sqlyog, and restarted it. Did each table in the db keep the setting? YES, they did.

I can now certify that this feature, unlike myself, works as intended!

Thanks, I'm now an expert on the LIMT ROWS checkbox! 😎

[sqldave]

Thanks for your reply. I am using 8.7RC.

I have all the control settings AFAIK. The MySQL setup is on my desktop computer and I am the administrator…

Let me give you an example of the behavior I am referring to: In preferences, “Enable autopaging” is checked. “Remember setting for each query” is checked. My setting is “999999” rows.

OK. I go to the object pane, and click open a table. When the table opens, “Limit rows” is checked and the number of rows is set to 100. The table has about 7000 rows.

Why are not all 7000 rows shown?

My goal is to see ALL rows from ANY table ANY time I view the table in Sqlyog.

Thanks.

[sqldave]

Thank you for the update.

I used to use MS FoxPro. It kept a running text file of all keyboard activity, which it opened with each startup. That's the “model” I was thinking of. It was great for referring to “the query I ran last week.”

Yes, I know I could save the daily activity manually, but I have a very good reason for not doing so: I'm lazy 🙂

[sqldave]

Well, I'll be doggone! There it is! Thank you for pointing it out. I should have asked earlier! 😀

[sqldave]

Appreciation for the quick response and action. Also, don't forget my favorite issue:

#544 🙂

Being able to set the color in the Object Browser now (v8.5+) is very nice.

Thanks!

[sqldave]

'peterlaursen' wrote on '11:

Actually scrolling has been improved over the last 1-2 years.  What is the version you are using? 

Hi, and thanks for the quick reply.

I'm using the most recent version: 8.53. The table in question has 613 columns. I know that is a lot of columns,

but it is from an externally-produced text file. 🙄

[sqldave]

Thank you for your reply and for looking into this.

Dave

[sqldave]

navyashree.r wrote on Jul 1 2009, 01:16 AM:

Hi,

Issue confirmed. Added in our tracker,

http://code.google.com/p/sqlyog/issues/detail?id=1110

Regards,

Navya

Thank you very much for looking into this! I think this is why SQLyog is such a great product.

[sqldave]

peterlaursen wrote on Jun 30 2009, 12:43 PM:

It did capture as far as I can see. Formatting a little will show.

UPDATE `students`

SET `tag`='x',`last_name`='Onion',`first_name`='Suzy',`teacher`='Crabtree'

WHERE `tag`='x' AND `last_name`='Onion' AND `first_name`='Suzy' AND `teacher`='';

In the SET clause (new data) it reads …`teacher`='Crabtree'

In the WHERE clause (old data) it reads …`teacher`=''

… so the `teacher` column should change from '' (empty string) to 'Crabtree'

What am I missing?

In my original post, did you follow the steps and attempt to duplicate my activity? If you did, I think you will see what I mean. When I follow those sets, the data is not saved.

I just verified this once again on my computer.

I don't know how I can state the case any more plainly. It should be easy to reproduce the behavior.

Now, either I'm expecting something to happen that isn't meant to happen in SQLyog — OR — there seems to be an issue in the program. I just want to know which.

Thanks!

[sqldave]

peterlaursen wrote on Jun 30 2009, 11:55 AM:

Of course it should make no difference how you enter data into a cell.

1)

Are you telling that with 'paste from clipboard' you get another behavior as compared to 'type with keyboard'?

2)

Is this UDATE statement correct (what you did)

Code:

UPDATE `students` SET `tag`='x',`last_name`='Onion',`first_name`='Suzy',`teacher`='Crabtree' WHERE `tag`='x' AND `last_name`='Onion' AND `first_name`='Suzy' AND `teacher`='';

.. changed `teacher` from '' (empty string) to 'Crabtree'?

(I still do not understand why you do not add an auto_increment PK to your tables. You will get lots of issues (example: no protection against duplicate rows) and bad performance!)

Thanks for your help.

1. Yes, this seems to be the case in my example.

2. Yes. As you can see, the UPDATE statement did not “capture” my pasted data (using CONTROL-V to paste teacher “Crabtree”).

3. So far, I am the sole user of MySQL for my projects. Because I get most of my data from a big state-wide database (operated by many professional DBAs), I don't have to worry about duplicate data. My biggest table is only about 50,000 rows and my longest MySQL “program” is about 1700 lines and takes only 8 minutes to run, which is fine for me. A nice coffee break.

Thanks!

[sqldave]

Sorry about wasting your time. I'm not a DBA or a MySQL professional. Just a customer. I will try to learn from this.

[sqldave]

peterlaursen wrote on Jun 28 2009, 12:01 PM:

'codebox' is there, but I do not understand what columns d,e,f, and g are.

The only thing that really matters is what SQL is sent to the server. Please check that in HISTORY tab. But I do not exclude the possibilty that there was a bug that we failed to document in 8.12. However you will need to describe a a reprodcuable way .. *step by step*

I see what you mean. By columns d, e,…etc., I only meant any random columns on any simple MySQL table.

The previous codebox contains an actual example. I apologize for the confusion.

I have the history for version 8.13b and for version 8.05. Here it is.

[codebox]Version 8.13b…

/*[12:14:25 PM][ 422 ms]*/ DROP TABLE IF EXISTS students ;

/*[12:14:25 PM][ 32 ms]*/ CREATE TABLE `students` ( `last_name` CHAR(20) NOT NULL, `first_name` CHAR(15) NOT NULL, `grade` CHAR(2) NOT NULL, `ethnic` CHAR(1) NOT NULL, `sex` CHAR(1) NOT NULL ) ENGINE=INNODB DEFAULT CHARSET=latin1 ;

/*[12:14:25 PM][ 0 ms]*/ INSERT INTO students ( last_name,first_name,grade,ethnic,sex ) VALUES ( “Doe”,”John”,”12″,”B”,”M” ) , ( “Smith”,”Bob”,””,””,”” ) , ( “Que”,”Suzy”,””,””,”” ) ;

/*[12:14:25 PM][ 0 ms]*/ SELECT * FROM students ORDER BY last_name , first_name ;

/*[12:14:25 PM][ 0 ms]*/ — v 8.05: Create table students, etc. — Perform query. — Set “Read Only” to “students”. — Enter manually for Suzy: “11”,”W”,”F”. — Move cursor to next row. — Data for Suzy is SAVED. ;

/*[12:14:32 PM][ 0 ms]*/ SHOW FULL FIELDS FROM `students`;

/*[12:14:32 PM][ 0 ms]*/ SHOW KEYS FROM `students`;

/*[12:14:48 PM][ 0 ms]*/ SELECT COUNT(*) FROM `students` WHERE `last_name`='Que' AND `first_name`='Suzy' AND `grade`='11' AND `ethnic`='W' AND `sex`='';

/*[12:14:48 PM][ 0 ms]*/ UPDATE `students` SET `last_name`='Que',`first_name`='Suzy',`grade`='11',`ethnic`='W',`sex`='F' WHERE `last_name`='Que' AND `first_name`='Suzy' AND `grade`='11' AND `ethnic`='W' AND `sex`='';

NOTE: NEW DATA WAS NOT SAVED using 8.13b.

Version 8.05…

/*[12:16:17 PM][ 0 ms]*/ SET NAMES 'utf8';

/*[12:16:17 PM][ 0 ms]*/ SET sql_mode='';

/*[12:16:17 PM][ 16 ms]*/ SHOW DATABASES;

/*[12:16:26 PM][ 0 ms]*/ USE `proj_sap`;

/*[12:16:55 PM][ 453 ms]*/ DROP TABLE IF EXISTS students ;

/*[12:16:55 PM][ 47 ms]*/ CREATE TABLE `students` ( `last_name` CHAR(20) NOT NULL, `first_name` CHAR(15) NOT NULL, `grade` CHAR(2) NOT NULL, `ethnic` CHAR(1) NOT NULL, `sex` CHAR(1) NOT NULL ) ENGINE=INNODB DEFAULT CHARSET=latin1 ;

/*[12:16:55 PM][ 0 ms]*/ INSERT INTO students ( last_name,first_name,grade,ethnic,sex ) VALUES ( “Doe”,”John”,”12″,”B”,”M” ) , ( “Smith”,”Bob”,””,””,”” ) , ( “Que”,”Suzy”,””,””,”” ) ;

/*[12:16:55 PM][ 0 ms]*/ SELECT * FROM students ORDER BY last_name , first_name ;

/*[12:17:05 PM][ 0 ms]*/ SHOW FULL FIELDS FROM `students`;

/*[12:17:05 PM][ 0 ms]*/ SHOW KEYS FROM `students`;

/*[12:17:12 PM][ 0 ms]*/ SELECT COUNT(*) FROM `students` WHERE `last_name`='Que' AND `first_name`='Suzy' AND `grade`='' AND `ethnic`='' AND `sex`='';

/*[12:17:13 PM][ 422 ms]*/ UPDATE `students` SET `last_name`='Que',`first_name`='Suzy',`grade`='11',`ethnic`='W',`sex`='F' WHERE `last_name`='Que' AND `first_name`='Suzy' AND `grade`='' AND `ethnic`='' AND `sex`='';

NOTE: NEW DATA WAS SAVED using 8.05.[/codebox]

[sqldave]

peterlaursen wrote on Jun 28 2009, 11:41 AM:

1) you mentioned columns d,e,f, and g. But your table does not have such columns. How should we be able to reproduce or even understand exactly what you are doing?

2) I asked you to check in HISTORY tabe what SQL SQLyog sends to the server. You did not reply to this.

I have to request that you are more accurate and detailed when reporting issues! Explains things *step by step* in every detail so that we can reproduce it.

Thanks for your reply.

Yes, the “Automatically refresh…” is already set as you suggested.

Did you not receive the “codebox” that I sent? I think that illustrates the problem I'm having.

Thank you again. I will try the 8.13 beta, also.

[sqldave]

Hi, thanks for the reply —

Apache — 2.2.8

MySQL — 5.0.51.b

Here are specifics:

[codebox]DROP TABLE IF EXISTS students ;

CREATE TABLE `students`

(

`last_name` CHAR(20) NOT NULL,

`first_name` CHAR(15) NOT NULL,

`grade` CHAR(2) NOT NULL,

`ethnic` CHAR(1) NOT NULL,

`sex` CHAR(1) NOT NULL

) ENGINE=INNODB DEFAULT CHARSET=latin1 ;

INSERT INTO students

( last_name,first_name,grade,ethnic,sex )

VALUES ( “Doe”,”John”,”12″,”B”,”M” )

, ( “Smith”,”Bob”,””,””,”” )

, ( “Que”,”Suzy”,””,””,”” ) ;

SELECT *

FROM students

ORDER

BY last_name

, first_name ;

— v 8.05: Create table 'students', etc.

— Perform query.

— Set “Read Only” to “students”.

— Enter manually for Suzy: “11”,”W”,”F”.

— Move cursor to next row.

— Data for Suzy is SAVED.

— v 8.12: Create table 'students', etc.

— Perform query.

— Set “Read Only” to “students”.

— Enter manually for Suzy: “11”,”W”,”F”.

— Move cursor to next row.

— Data for Suzy is NOT SAVED. [/codebox]

[sqldave]

peterlaursen wrote on Jun 28 2009, 03:55 AM:

1) Please post the CREATE TABLE statement for that particular table. It is difficult for us to understand what “columns d,e,f, and g” are. It also matters what the Primary Key is and if there are any floating type data columns (FLOAT and DOUBLE types).

2) You can see what SQL SQLyog sends in the HISTORY tab – if it does send. Always check here, because that is what really matters!

3) If it does not save when you move the cursor down next row it looks like a bug. Does it save when you click the 'save' icon (the small diskette icon)?

4) Also tell what server version you are using.

5) And could you try 8.13 beta1 please?

[Author]

Posts