Database Description
Practical examples for a generic viewing of a database.
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.
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
Ratings
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
























Ritorna all'inizio
Based total comments
0 %
Comments percentage
0 %