Basics
Creating a Document
Head and Body Elements
Formatting Text
Creating Lists
Embedding Images
URLs Explained
Linking to Documents
Creating Tables
Forms Form Basics
Input and Textarea
Select Lists
Frames Framesets
The Frame Element
Nested Framesets
Targetting Frames
Inline Frames
Tips and Tricks Meta Tags
Transition Effects
HTML Generators Create a Document
Create a List
Create a Table
HTML
Basics
Implementing CSS
CSS Syntax
Pseudo Classes/Elements
CSS Classes
CSS Properties Font Properties
Color and Background
Text Properties
Border Properties
Margins and Padding
Size and Position
Tips and Tricks Menu Buttons
Special Effects
CSS
Basics
Running a Script
Variables
Expressions and Operators
Objects.Properties.Methods
The Date Object
Strings
Regular Expressions
Defining RegExp Patterns
Branches and Conditions
Loops
Arrays Array Basics
Array Methods
Sorting Arrays

User-Defined Functions
Cookies
Windows
Frames
Tips and Tricks Image Replacement
Using Includes
Form Validation
Debugging
JavaScript
Basics
Creating a Script
Running a Script
Variables
Expressions and Operators
Strings Strings Basics
Strings and Substrings
Replacing Substrings
Regular Expressions
Branches and Conditions
Loops
Arrays Array Basics
Array Functions
Sorting Arrays
User-Defined Functions
Include and Require
Uploading Files
File Functions
Session Variables
Tips and Tricks Page Templates
Form Reply Scripts
Form Validation
JavaScript to PHP
PHP
Basics
Create and Drop
Show and Describe
Insert, Update and Delete
Querying
Join Queries
Functions
Table Locking
PHP/MySQL Functions Accessing a Database
Querying with PHP
Create and Drop with PHP
Insert and Update with PHP
Frequently Used Functions MySQL
Basics
Layout and Navigation
Page Content Style
Web Page Copy
Graphics and Animation
HTML Forms
Accessibility
Legal Requirements
MySQL
MySQLBasicsCreate and DropMySQL show and describeShow and DescribeInsert, Update and DeleteQueryingJoin QueriesFunctionsTable LockingPHP/MySQL FunctionsAccessing a DatabaseQuerying with PHPCreate and Drop with PHPInsert & Update with PHPFrequently 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 - MySQL Create and Drop Previous - Create and Drop     Next - Insert, Update and Delete Next - MySQL Insert, Update and Delete


Privacy | Terms | Contact | Links | Sitemap | RSS Feeds RSS and JavaScript Feeds
©2010 www.webdesignworkmate.co.uk all rights reserved 
Design and Production by smallbizonline website design © 2000-2010
Valid HTML 4.01! Level Double-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0Valid CSS!
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