[ashwin]

Hi,

Please confirm whether you are doing One-way sync or Two-way sync? Because Insert from Target to source happens only in Two-way sync.

Regards,

Ashwin

[ashwin]

Hi,

Could you please tell:

1) SQLyog version (Help->About)?

2) Check whether in Tools->Preferences->Others->'Prompt if multiple rows are getting updated in the Data display/editing' is checked or not. If checked then SQLyog will warn you and ask for confirmation when editing data results in multiple rows getting updated.

Please check the screen-shots.

Regards,

Ashwin

[ashwin]

Added in our wish-list here: http://code.google.com/p/sqlyog/issues/detail?id=1886

We will prioritize and take this up.

Thank you for your request!

[ashwin]

We have fixed and released v10.41. Refer: http://blog.webyog.com/2012/11/21/sqlyog-mysql-gui-10-41-released/

[ashwin]

@pgoloskie: Could you please share the excel file where this is reproducible?

[ashwin]

Could you tell us the structure of the source? If there are PK(s) in the target then importing from source and having 'Keep target data' will not import duplicates. So you must have a target table with some PK in it without which duplicates will be imported.

It does not matter if your source is from a view, but the target table must have unique index so that there will be no duplicates on import.

[ashwin]

We have released v10.1 Beta1. Refer: http://www.webyog.co…eta-1-released/

Quote:

* It is now optional whether DATA, INFO and HISTORY tabs shall display in ‘upper pane’ (as in 10.0) or in ‘lower pane’ (as before 10.0). The setting is available in tools .. preferences .. general. Note that for DATA tab this applies to the ‘non-sticky’/non-persistent DATA tab. A ‘sticky’/persistent DATA tab will always display in ‘upper pane’.

@DAE51D, ALT+C- shortcut to copy query without formatting(Normalize white-spaces and line-breaks) and paste as a single line.

Quote:

* Added an option to copy selected text into clipboard with all whitespace (SPACE characters, TAB characters and linebreaks) replaced with a single SPACE character. The option is available from menu and the keyboard shortcut ALT+C .

[ashwin]

To update with new data(duplicate data will be replaced) and without drop & recreate table you should use the option Import Into Existing Table->Update With Source details which is under Advanced Options in Import External data. Please see attached screen-shot.

Refer Help file(Help Menu->Help(F1) for more information.

[ashwin]

@DAE51D,

Quote:

“Paste SQL statements” it stacks the columns like I have in my preferences for F12. If I'm having you generate me a SQL statement, you can pretty much bet your ass I need it to paste into my PHP code and preferably as a single line.

We have decided to give a shortcut to copy query without formatting(Normalize white-spaces and line-breaks) and paste as a single line. This will be included in our next public release(Approx. 10 days).

Quote:

Another annoyance is that I always set my “default rows” to 5000, yet it always seems to be set to 25!? WHY!? ugh.

We have changed this now. If you set default to 5000 then in table data it will be set to 5000 only if you have not changed the Limit rows before.

Quote:

And that's just one example of probably 20 more that I could think of for preference settings.

We would love to hear all your suggestions 🙂 Could you please detail/list those?

[ashwin]

We have taken into consideration your concerns, and accordingly have planned to release 10.1 in approximately 2 weeks.

There will be preference options to choose the position of table data and info tabs (either the query tab level as is now-v10, or the result tab level as was before).

[ashwin]

SQLyog v10 Beta1 is available now with this fix. Refer: http://www.webyog.com/blog/2012/05/04/sqlyog-mysql-gui-10-0-beta-1-released/

Quote:

When upgrading, the installer will now remember what shortcuts were created previously.

[ashwin]

Quote:

My DDL of the table says:

`title` varchar(255) NOT NULL,

`code` varchar(255) NOT NULL

but the editor shows '' (2 single quotes). That should not be displayed.

We are not clear with this. Could you please attach a screen-shot here?

Quote:

1. When there is NO default value (as in the DDL above), I can NOT set a default value to '' (2 single quotes), because they are already there in the EDIT COLUMNS view.

You could set the Default to '' (2 single quotes) which means empty string. But, could you please tell what do you mean by “because they are already there in EDIT COLUMNS view”? You mean 'Manage Columns'?

Quote:

2. I can set the default value of a column ('title') to, for instance, 'a'. (I type in: a … NOT the single quotes, otherwise i get 4 quotes in my DDL (''a'')).

You would be getting like this '''a''' if you have Default like- 'a' (single quote a as Default). You get extra quotes because the single quote is actually escaped. Refer this- http://dev.mysql.com/doc/refman/5.0/en/string-literals.html

which says- A “'” inside a string quoted with “'” may be written as “''”. If you execute SHOW CREATE TABLE you will get the same result.

Quote:

3. I can then edit the table and set the default value, explicit to '' (I type in: quote quote)). The DDL shows:

`title` varchar(255) NOT NULL default '',

`code` varchar(255) NOT NULL

This Default is Empty string. ''(quote quote) means Empty string.

Quote:

4. I can, for the column 'title', clear the quotes in de default field (the column 'code' also shows 2 quotes, but these are just not in the DDL

We are not clear with this as well. Please attach a screen-shot. “Column `code` shows 2 quotes”. But where? Alter table tab? INFO tab?

[ashwin]

Thank you for the very useful information. We could reproduce the crash when EXPLAIN EXTENDED is enabled. We are checking this.

[ashwin]

@Mitch, We are unable to reproduce the crash. The dump also does not have a usable stack trace. We had 1M picture in the 'picture' column but “SELECT * from web_object_review WHERE webobjectreviewid=14;” query returned the result without crashing. It could be a data specific issue. So could you share us the table dump(with any client) or the 1MB image so that we could try at our end and reproduce it?

[ashwin]

Hi Mitch,

This is not reproducible in Win 7. This crash report is similar- http://code.google.com/p/sqlyog/issues/detail?id=1764

Please attach the crash dump here. We will investigate into this tomorrow.

Thank you for reporting.

Regards,

Ashwin

[Author]

Posts