[MySQL]Show information on a table

Last update on July 20, 2009 08:47 AM by jak58
Published by jak58

[MySQL]Show information on a table






To view information on a TabTest table must run the following command (option\G improves formatting of the u outcome): 
mysql> show create table TabTest\G




1. row

         Table: TabTest
Create Table: CREATE TABLE `tabtest` (
  `cle_prim` int(4) NOT NULL AUTO_INCREMENT,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `z` int(11) DEFAULT NULL,
  PRIMARY KEY (`cle_prim`),
  UNIQUE KEY `x` (`x`,`y`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
1 row in set (0.00 sec)


Note that this command does not work if the database is started with the --safe-show-database or --skip-show-database.
Best answers for « Show information on a table » in :
Download Rainmeter Show Several gadgets allow to show information systems without big aesthetics. Rainmeter is a tool allowing to show data systems of your computer. He allows to measure and to show the complete rate of load supported by your central processing unit...
Connecting to Oracle via php Show Connecting to Oracle via php Settings Requirements Example of code Settings Below is an article based on an example of connection to an Oracle database through a php script. However it is not designed to configure your oracle...
Can't open secure websites Show Can't open secure websites Issue Solution Issue It happens that some secure (https://) websites can't be opened on Internet Explorer or other browsers. You can get this error "The page cannot be displayed". This because these...
Show what you are listening to on MSN/WLM ShowShow what you are listening to on MSN/WLM Windows Media Player The Winamp Player The VLC Media Player The Foobar 2000 player When we are connected to instant messaging Windows Live Messenger, it is possible to display and use...
[Virus] System Volume Information Show[Virus] System Volume Information The System Volume Information folder is used by Windows XP for storing data on system configuration and is also used by the System Restore tool to store information and restore points. Restore points...
ORA-00942: table or view does not exist ShowORA-00942: table or view does not exist In the case you encounter the following error message: a table or view entered does not exist, or unauthorized synonym was used, or an expression of view was used instead of a table name. YOu must...
Download TinyResMeter ShowTinyResMeter is a tool allowing to show information system real-time. Via a right click of the mouse, you can acquire more details on the various shown fields. In more practice, it inserts a capture your screen one to safeguard important information...
Download Slide Show Movie Maker Show
Download Export Table To Text For Sql Server Show
The NTFS file system ShowThe NTFS file system The NTFS file system (New Technology File System) is based on a structure called the "master file table" or MFT, which is able to hold detailed information on files. This system allows the use of long names, but, unlike the...
HTML forms ShowForms Interactive forms let web page authors give their pages interactive elements, such as for receiving messages from their readers, much like the reply cards found in some magazines. The reader enters information by filling in fields or clicking...
The file system ShowWhat is a file system? Even though hard drives can be very small, they still contain millions of bits and therefore need to be organised so that information can be located. This is the purpose of the file system. Remember that a hard drive is made...
They need your help