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: loryzz on date: 03.02.2008 13:58:38

Last edit by: loryzz on date: 02.04.2008 16:54:26

Statistics

This article has been viewed 677 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 published by loryzz in MySQL
Problemi di FLOAT published by loryzz in MySQL
MySQL table rename published by loryzz in MySQL
Password di root dimenticata published by loryzz in MySQL
Selezione condizionale published by loryzz in MySQL

Advertising

Tags