MySQLBasics Create and Drop

Show and DescribeInsert, Update and Delete Querying Join Queries Functions Table LockingPHP/MySQL FunctionsAccessing a Database Querying with PHP Create and Drop with PHP Insert & Update with PHP Frequently Used Functions

Home > MySQL > Show and Describeprinter version

MySQL Show and Describe

This tutorial assumes that you have access to the MySQL command prompt.

Show

The SHOW command is used to display details about databases, tables and indexes.

Examples of the SHOW command

mysql> SHOW databases;
+--------+
|Database|
+--------+
|test |
+--------+
1 row in set (0.01 sec)

mysql> SHOW tables;
+--------------+
|Tables_in_test|
+--------------+
|people |
+--------------+
1 row in set (0.01 sec)

mysql>

Describe

The DESCRIBE command is used to display information about a table. It outputs attribute names, their data types, keys and other information about the attributes.

Example of the DESCRIBE command

mysql> DESCRIBE people;
+---------+------------+----+---+-------+--------------+
|Field    |Type        |Null|Key|Default|Extra         |
+---------+------------+----+---+-------+--------------+
|id       |int(6)      |    |PRI|NULL   |auto_increment|
|firstname|varchar(30) |    |   |       |              |
|lastname |varchar(30) |    |   |       |              |
|address |varchar(100)|    |   |       |              |
|county   |varchar(40) |YES |   |NULL   |              |
|country |varchar(30) |YES |   |UK     |              |
|age      |int(3)      |YES |   |NULL   |              |
+---------+------------+----+---+-------+--------------+
7 rows in set (0.01 sec)

mysql>

Previous - Create and Drop Next - Insert, Update and Delete

Privacy | Terms | Contact | Links | Sitemap | RSS Feeds

©2009 www.webdesignworkmate.co.uk all rights reserved
Design and Production by smallbizonline website design © 2000-2009

Recommended Reading

PHP6 and MySQL5

PHP and MySQL Web Development

Build Your Own Database Driven Website using PHP and

MySQL

How to do Everything with PHP and MySQL