Database Description

Practical examples for a generic viewing of a database.

Database Description

List the fields of a table

Syntax

describe table_name;

Example

describe customer;

List all the database

Syntax

show databases;

List all the tables of a database

Syntax

show tables;

Notes

These commands can be used either by script, such as PHP, both from mysql client.

tags describe, sql describe, describe database, describe tables

Publication details

Category: MySQL

Published by: loris.genetti on date: 03.02.2008 13:58:38

Last edit by: loris.genetti on date: 02.04.2008 16:54:26

Statistics

This article has been viewed 817 times.

Send to

Ratings

Currently 0; ?>/ TOTALSTARS
1
2
3
4
5

Comments

0 user comments, 0 still waiting.

Leave a comment

All comments must be approved by site administrator.
Please write comments on topic. Spam will be never approved.

MySQL: Linked articles

SQL: Selezionare righe duplicate on date 2 October 2009
Problemi di FLOAT on date 24 January 2008
MySQL table rename on date 14 January 2008
Password di root dimenticata on date 6 January 2008
Selezione condizionale on date 6 January 2008

Advertising

Tags