<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    Chapter 4: Database Administration 251    If the thread is waiting for free disk space in a write call, the write is aborted with an disk full error message. 4.5.6  SHOW Syntax SHOW DATABASES [LIKE wild] or SHOW [OPEN] TABLES [FROM db_name] [LIKE wild] or SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE wild] or SHOW INDEX FROM tbl_name [FROM db_name] or SHOW TABLE STATUS [FROM db_name] [LIKE wild] or SHOW STATUS [LIKE wild] or SHOW VARIABLES [LIKE wild] or SHOW LOGS or SHOW [FULL] PROCESSLIST or SHOW GRANTS FOR user or SHOW CREATE TABLE table_name or SHOW MASTER STATUS or SHOW MASTER LOGS or SHOW SLAVE STATUS SHOW  provides information about databases, tables, columns, or status information about the server.  If the LIKE wild part is used, the wild string can be a string that uses the SQL `%' and `_' wildcard characters. 4.5.6.1  Retrieving information about Database, Tables, Columns, and Indexes You can use db_name.tbl_name as an alternative to the tbl_name FROM db_name syntax. These two statements are equivalent: mysql> SHOW INDEX FROM mytable FROM mydb; mysql> SHOW INDEX FROM mydb.mytable; SHOW DATABASES  lists the databases on the MySQL server host.  You can also get this list using the mysqlshow command line tool.  In version 4.0.2 you will only see those databases for which  you  have  some  kind of privilege,  if you  don't have  the  global  SHOW DATABASES privilege. SHOW TABLES  lists  the  tables  in  a  given  database.   You  can  also  get  this  list  using  the mysqlshow db_name command. Note:  if a user doesn't have any privileges for a table, the table will not show up in the output from SHOW TABLES or mysqlshow db_name. SHOW OPEN TABLES  lists  the  tables  that  are  currently  open  in  the  table  cache.   See  Sec- tion  5.4.7  [Table  cache],  page  361.   The  Comment   eld  tells  how  many  times  the  table  is cached and in_use. SHOW COLUMNS  lists the columns in a given table.  If you specify the  FULL  option, you will also get the privileges you have for each column. If the column types are di erent from what you expect them to be based on a CREATE TABLE statement, note that MySQL sometimes changes column types.  See Section 6.5.3.1 [Silent column changes], page 476.
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide