One of my mysql table's icon is changed and not showing data and when click to browse , download the page?

This is a VIEW and no TABLE. VIEWS are something like queries combined in a table-like-thing which you can query and pull data from it with standard commands like SELECT * from myView WHERE userID = 3.

Up vote 0 down vote favorite 1 share g+ share fb share tw.

MySql Table showing Browse: VIEW (0) on mouse over and download the page when I click for browse. Mysql phpmyadmin link|improve this question edited Nov 4 '11 at 15:40Will?50.6k1494177 asked Nov 4 '11 at 6:23Sumit Kumar Upadhyay103.

You'll have to give us more information. Which sql browser's icon are you talking about? What does a direct query using cli give you?

Are you sure there is data in the table? – abhinav Nov 4 '11 at 6:28 Are you talking about PHP Myadmin? – pinaldesai Nov 4 '11 at 7:18 Yes pinaldesai I am talking about phpMyadmin.

– Sumit Kumar Upadhyay Nov 4 '11 at 7:33 abhinav I added a link of icon . Please see the link. – Sumit Kumar Upadhyay Nov 4 '11 at 7:57 Please edit your question and upload the images to our image server.

If you cannot figure out how to do this, please read this post on Meta. – Will? Nov 4 '11 at 15:41.

Sn0opy thanks for answering. Have you seen the image. Only tickeyallpass is creating problem another table with same icon are working means all queries are running on other tables.

– Sumit Kumar Upadhyay Nov 4 '11 at 8:36 I download the database and found there is no myd and myi file for changed icon table. – Sumit Kumar Upadhyay Nov 4 '11 at 8:38 myi / myd file? Just make a dump of the database and show us the VIEW code.

– Sn0opy Nov 4 '11 at 8:44 I export and save the table query here. Min.us/m1VZCFiP9 . Please download.

I choose complete export for this table but there is no insert query in file. – Sumit Kumar Upadhyay Nov 4 '11 at 9:17 It's a bit hidden, but there's exactly what I meant: VIEW ticketallpass AS select book_tickets.id... please consider viewing the docs, for further informations how VIEWs work – Sn0opy Nov 4 '11 at 9:33.

According to phpMyAdmin's source code, that icon appears if the table's comment is VIEW. However I don't know what the significance of this is. EDIT: Just seen Sn0opy's reply, that explains the significance.

However that icon also shows up on tables with the comment "view", regardless of being a view or not.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.