show create table tbl_products;

This topic is empty.

Viewing 8 reply threads

Author

Posts
- May 12, 2005 at 10:37 am #8976
  
  zzapper
  Member
  
  Hi,
  
  show create table tbl_products; appears to just show garbage.
  
  tested above OK with CLI mysql.exe.
- May 12, 2005 at 10:53 am #17790
  
  zzapper
  Member
  
  Ritesh,
  
  Sorry 4got am using latest rc1
- May 12, 2005 at 11:11 am #17791
  
  peterlaursen
  Participant
  
  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
- May 17, 2005 at 5:56 am #17792
  
  zzapper
  Member
  
  This hasn't been fixed in 4.06
- May 17, 2005 at 7:27 am #17793
  
  Shadow
  Member
  
  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.
- May 17, 2005 at 8:25 am #17794
  
  Ritesh
  Member
  
  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.
- May 18, 2005 at 3:03 pm #17795
  
  zzapper
  Member
  
  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) ?
- May 18, 2005 at 4:00 pm #17796
  
  Shadow
  Member
  
  Right-click pop-up menu and hot-keys are not sufficient?
- May 18, 2005 at 4:38 pm #17797
  
  zzapper
  Member
  
  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 !!!!
Author

Posts