Request: Truncate Resets First Row

[andrewteg]

I just noticed that if you truncate a table (with Shift+Del) it leaves your “First Row” as the old value so even if you insert one new value you do not see it without going back to viewing Row 0.

To See This:

Create Table

Insert 100+ rows

Click the Arrow to change First Row from 0 to 100.

Click Table Name in Sidebar

Shift+Del to Truncate Table

Note First Row still say 100.

Insert One Row in Table Data view, hit Refresh and it looks like it disappears, but it actually does not because you are viewing Row 100-199 in a table that now only has 1 row.

[nithin]

Thanks for the suggestion.

It will be implemented as you have suggested, when table is truncated the range options would be the default(LIMIT 0-100). This will be done in next public release (Expected release date for 8.5GA is 15th of this month).

It's added to the issue tracker

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

[Mahesh]

We have released v8.5 GA with many useful features along with this fix.

Please read our blog from here:

http://www.webyog.com/blog/2010/06/15/sqlyog-mysql-gui-8-5-ga-brand-new-tabbed-interface/

[Author]

Posts