Hi,

show create table tbl_products; appears to just show garbage.

tested above OK with CLI mysql.exe.

Ritesh,
Sorry 4got am using latest rc1

confirmed!

It's a problem with the "result pane" only. If you copy to clipboard and paste into SQL-pane or a text-editor it's OK!

The problem is related to characters to produce LineFeed and CarriageReturn. They are mismatched by the result pane. It's displayed as a square followed by (I think) 3 space-characters

This hasn't been fixed in 4.06

This is not a bug of SQLyog, but rather a bug of the GUI control SQLyog uses. It simply cannot handle line breaks... In case of SHOW CREATE TABLE command switch to Edit->Show results in text, and results will be displayed as expected. However, if you have more fields in the returned resultset, that contain line breaks, then even this workaround is spoiled.

Show create table returns table definition in multiple lines. The current grid can only show data in a single line and hence the carriage returns come as grabage.

As shadow said you have to switch to Text Mode.

BTW, you can get the same thing in the object pane when you select a table in the object browser.

Hi,
You can toggle Control L to switch Display Mode, that's really useful & cool.

I fear however that this fool others!

Howsabout an extra button on the results pane (next to export cells/rows,all) ?

Right-click pop-up menu and hot-keys are not sufficient?

Shadow,

I just know that lots of others are going to stumble on this one.
I didn't even know there was a text mode, so I couldn't "see" any of the options.

BTW Text mode is wonderful as it gives you a reall quick way to select just the data you want.

So everyone try Control-L in the results Pane !!!!