Table Data Will Not Display With Certain Tables

[sloppyboy]

Hello,

I've been experiencing an issue with version 5.11 where the table data will not display on the table data tab when performing a “select * from…” command. However, this issue only happens with one specific table in my schema.

I am running the following sql in the sql window:

select * from orders_staging;

Instead of dispaying the table data on the table data tab, it is showing the following on the Messages tab:

(2 row(s) affected)

(0 ms taken)

If I click on the “Table Data” tab then nothing shows up for this specific table, not even the column names. ** If I try to view the table data in PHPMyAdmin then the data shows up just fine. **

I ran the table diagnostics under the Tools menu to see if there was something wrong with the table but everything checks out ok.

Any ideas if this is a bug or is something else wierd going on? Thanks in advance.

Tommy

[Manoj]

Hello,

To view the content of a table by using Table Data tab you need to select the table in the Object Browser and then select the Table Data tab. If you are using a query like “select * from …” to view content, the result is shown in the Result tab NOT IN Table Data tab.

If you are following the correct steps and still not showing the table content, can you please paste the create table statements here.

[Author]

Posts