There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Web Design & Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Internet & Networking > Web Design & Development >
Viewing Table Data in MySQL


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
smooth's Avatar
Distinguished Member with 3,485 posts.
  
Join Date: Sep 2005
Location: NC, USA
Experience: Learning everyday :)
06-Mar-2007, 09:42 AM #1
Viewing Table Data in MySQL
Hey everybody

I want to be able to see the actual data within my tables in MySQL administrator. When I double-click on the table, it just shows me the structure of the tables and not the actual information within them.

Is it possible to view the information in them through MySQL Administrator?
__________________

Meet Your Fellow TSG Members :: Find Out What CWLMST Means :: NCAA Football :: NCAA Basketball


Looking forward to meeting you up in heaven angel

I don't care how bad I feel, when I go to work I make sure I give it my all! Never any less than 12%...

47.5% of all statistics are made up right on the spot

When something is done in ignorance, then its always best to admit that you have no excuse, fix the problem, put it behind you, and move on - valley
MMJ's Avatar
MMJ MMJ is offline
Distinguished Member with 3,208 posts.
  
Join Date: Oct 2006
06-Mar-2007, 01:32 PM #2
Ouch, I hate that program, phpMyadmin is much better and is easy to install too!

Open the query browser, click on the db you want than type: "select * from table_name" without the quotes.
Chicon's Avatar
Computer Specs
Distinguished Member with 6,587 posts.
  
Join Date: Jul 2004
Location: 50° 34' 07.13" N - 04° 10' 23.
Experience: Second socks retriever
07-Mar-2007, 07:11 AM #3
You may also download SQLyog MySQL GUI - Community Edition from here.

It's free and it works nicely.
smooth's Avatar
Distinguished Member with 3,485 posts.
  
Join Date: Sep 2005
Location: NC, USA
Experience: Learning everyday :)
07-Mar-2007, 08:17 AM #4
Thanks Chicon. I will definitely give that program a try
Chicon's Avatar
Computer Specs
Distinguished Member with 6,587 posts.
  
Join Date: Jul 2004
Location: 50° 34' 07.13" N - 04° 10' 23.
Experience: Second socks retriever
07-Mar-2007, 08:21 AM #5
Quote:
Originally Posted by smooth
Thanks Chicon. I will definitely give that program a try
You're welcome !
Reply

« Previous Thread | Web Design & Development | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

Related Sites: Support.com | Tech Gift Ideas | Mobile TechGuy | Advertise on TSG
Contact Us - HelpOnThe.Net - Archive - Terms of Service - Top
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 12:02 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.