CSS Codes
CSS Layouts
Results 1 to 6 of 6

Thread: Veiwing Database Contents?

  1. 12-14-2006, 02:07 PM #1
    boxxertrumps's Avatar
    boxxertrumps
    boxxertrumps is offline Senior Coders
    Join Date
    Jun 2006
    Location
    Acton Ontario Canada.
    Posts
    677
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default Veiwing Database Contents?

    Hello everyone...
    due to my horrible memory, i have created a table in my database and cant remember the colum names in the table.
    is there any way to view this information, any mysql command-line command or php function?

    I have 2 tables so far, named "login" and "boxxertrumps" in my DB "blog"

    Thanks for your time/help...
    - Ryan "Boxxertrumps" Trumpa
    Come back once it validates: HTML, CSS, JS.
    Reply With Quote Reply With Quote
  2. 12-14-2006, 02:19 PM #2
    NXArmada
    NXArmada is offline Regular Coders
    Join Date
    Apr 2006
    Posts
    190
    Thanks
    3
    Thanked 7 Times in 7 Posts

    Default

    Check out the MySQL GUI Tools

    MySQL Administrator will help you out as well as the Query browser.
    Ryan
    Sevierville, TN
    Reply With Quote Reply With Quote
  3. 12-14-2006, 10:03 PM #3
    Twey's Avatar
    Twey
    Twey is offline Modtoreador
    Join Date
    Jun 2005
    Location
    英国
    Posts
    11,876
    Thanks
    1
    Thanked 180 Times in 172 Posts
    Blog Entries
    2

    Default

    any mysql command-line command
    Code:
    explain login;
    Twey | I understand English | 日本語が分かります | mi jimpe fi le jbobau | mi esperanton komprenas | je comprends français | entiendo español | tôi ít hiểu tiếng Việt | ich verstehe ein bisschen Deutsch | beware XHTML | common coding mistakes | tutorials | various stuff | argh PHP!
    Reply With Quote Reply With Quote
  4. 01-04-2007, 07:34 AM #4
    ibrux
    ibrux is offline New Comer (less than 5 posts)
    Join Date
    Jan 2007
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    or use phpmyadmin
    Reply With Quote Reply With Quote
  5. 01-04-2007, 04:13 PM #5
    Twey's Avatar
    Twey
    Twey is offline Modtoreador
    Join Date
    Jun 2005
    Location
    英国
    Posts
    11,876
    Thanks
    1
    Thanked 180 Times in 172 Posts
    Blog Entries
    2

    Default

    I don't recommend it. One gets a much better feel for the database using the command-line client.
    Twey | I understand English | 日本語が分かります | mi jimpe fi le jbobau | mi esperanton komprenas | je comprends français | entiendo español | tôi ít hiểu tiếng Việt | ich verstehe ein bisschen Deutsch | beware XHTML | common coding mistakes | tutorials | various stuff | argh PHP!
    Reply With Quote Reply With Quote
  6. 01-20-2007, 03:46 PM #6
    mburt's Avatar
    mburt
    mburt is offline Elite Coders
    Join Date
    Jul 2006
    Location
    Canada
    Posts
    2,581
    Thanks
    13
    Thanked 28 Times in 28 Posts

    Default

    phpmyadmin is good though if you can't/don't want to download the 50mb package for the command-line client.
    - Mike
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules