Thread: MySQL Command

    #1
  1. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2000
    Location
    Hong Kong
    Posts
    71
    Rep Power
    15
    I want to know the command of the structure of table. Pls help me!
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Posts
    81
    Rep Power
    15
    try:
    desc mytablename;
    That'll give you an overview of the table metadata. More info is available -- permissions info, for example, can be found in the mysql database (use mysql).

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 06:02 PM
  2. Batch command to run MySQL Optimize Table
    By Horus_Kol in forum MySQL Help
    Replies: 10
    Last Post: February 20th, 2004, 02:45 AM
  3. Evoke Shell Command in Perl
    By yannn in forum Perl Programming
    Replies: 0
    Last Post: February 16th, 2004, 02:14 PM
  4. MySQL "source" command in PHP
    By crackwombat in forum PHP Development
    Replies: 2
    Last Post: January 18th, 2004, 06:25 AM

IMN logo majestic logo threadwatch logo seochat tools logo