3.11 dump formatting/wrap problem on block inserts

[jmichae3]

block insert statements should have the value sets each on their own line, especially if they are long.

the sqlyog editor (or any editor) can't handle lines that long.

example:

INSERT INTO `businesses` VALUES (1,'Thousand Trails, Inc.','campgrounds'),(2,'y','n','AAA AirSupply','HVAC Installation/Service'),(3,'y','n','American Paper Converting, Inc.',NULL);

should be

INSERT INTO `businesses` VALUES

(1,'Thousand Trails, Inc.','campgrounds'),

(2,'y','n','AAA AirSupply','HVAC Installation/Service'),

(3,'y','n','American Paper Converting, Inc.',NULL);

[Ritesh]

Thanks for the suggestion 🙂

[davgran]

Hi Ritesh:

You are getting to the point where mySQLyog can go up against the best! But there are some lingering problems…

Unfortuneately, this 'wrap' problem is more than just a 'suggestion' for me. It is one of the reasons I am holding off purchasing your retail version. (I'm using 3.11)

You have areas in your application where it is impossible 😡 to scroll to the end of a (query) line for editing.

Another 'serious' problem along the same lines is the 'blob' viewer. An example. I have two 'longtext' fields in one of my clients databases. One of them can contain any number of characters, and some can become quite long. When I double-click to view the text, IT DOES NOT WRAP 🙁 in the dialogue box. It should!!

In closing, I have a question which I would appreciate the answer to. If I install the retail 'demo' version to view the improvements you have made, will I be able to uninstall the demo and reinstall the 'freebie' version until you address any deficiencies I find.

Your program is our tool of choice and we have every intention of supporting your retail version once the minor annoyances are 'fixed'.

Kindest regards,

David

[Ritesh]

Quote:

You have areas in your application where it is impossible  to scroll to the end of a (query) line for editing.

Can you give us more details?

Quote:

Another 'serious' problem along the same lines is the 'blob' viewer. An example. I have two 'longtext' fields in one of my clients databases. One of them can contain any number of characters, and some can become quite long. When I double-click to view the text, IT DOES NOT WRAP  in the dialogue box. It should!!

It is planned for 3.6 wherein you can specify whether you need to 'wrap' data or not.

Quote:

In closing, I have a question which I would appreciate the answer to. If I install the retail 'demo' version to view the improvements you have made, will I be able to uninstall the demo and reinstall the 'freebie' version until you address any deficiencies I find.

Yes 😀

[Author]

Posts