PDA

View Full Version : Viewing Table


KlingonOffTheStarboardBow
10-31-2010, 09:31 AM
Having used MS Access and Paradox, I am puzzled that it seems so different/difficult to just SEE what is in a table. Is there no MYSQL command to "VIEW" data, or does one each time have to do a SELECT query to see ALL the records?

I am using HeidiSQL, but can't see an MS Access equivalent of View there either. Surely seeing what is IN a table is fundamental?

edbr
11-01-2010, 01:52 AM
do you mean create a view or just see the data? in heidi if i recall you go to data

KlingonOffTheStarboardBow
11-01-2010, 01:58 AM
You're quite right .... I found the solution some time later ... should have looked harder in the first place. In the main interface you click on DATA and you get a more than adequate "view" into which you can also input data directly as in MS Access and others ....

Sorry for the trouble .. I panic easily .....

edbr
11-01-2010, 02:33 AM
no prob actually heidi is a nice little package