: SHOW : MySQL Utilities MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
MySQL Utilities
»
SHOW
»
473.1 .
Show a detailed listing of the columns of your database.
Hits: 1174
473.2 .
To see the structure or schema of a database
Hits: 1124
473.3 .
SHOW INDEX FROM tbl_name
Hits: 1324
473.4 .
SHOW CREATE TABLE statement.
Hits: 1208
473.5 .
Display all table names
Hits: 1171
473.6 .
Use the SHOW statement to find out what databases currently exist on the server
Hits: 1186
473.7 .
SHOW COLUMNS and DESCRIBE can display information about the columns in individual INFORMATION_SCHEMA tables.
Hits: 1120
MySQL TUTORIALS
MySQL Utilities
»
SHOW
DUMP
Priority
Import Export Data
QUIT
Mysql
SHOW WARNINGS
Mysqldump
SHOW
Mysqlhotcopy
STATUS
Mysqlimport
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View