«
dbrowse
Table Structure
This node is informative, descriptive and functional.
[definitions]
Query Path
Interactive Path
Synopsis
This is a structural view of the active table in the current database.
Node/View
| mysql> describe laz.resource; | |||||
|---|---|---|---|---|---|
| Field | Type | Null | Key | Default | Extra |
| 10 rows in set (0.0004 seconds) | |||||
| rid | smallint(5) unsigned | Yes | PRI | NULL | auto_increment |
| cid | tinyint(3) unsigned | No | 1 | ||
| fid | char(16) binary | No | |||
| icon | char(16) binary | YES | default | ||
| mid | tinyint(3) unsigned | YES | 15 | ||
| URI | char(100) binary | No | |||
| title | char(64) | No | |||
| description | char(255) | No | |||
| updated | timestamp(14) | YES | |||
| aid | smallint(5) unsigned | No | MUL | 0 | |
[skip to the dbrowse Navigation information]
Selected Data
To learn more about the design of this table, and see some or all of the data contained in it, visit the Selected Data view. Or you may Enter the keyword “data” onto the end of the interactive path interface above.
SQL Statements
The following three MySQL statements are equivalent:
The first form is provided for Oracle compatibility. I prefer it for its brevity.
Description of Results
For detailed documentation regarding the information displayed on this page, visit the MySQL Reference Manual section on Describe Table. Brief descriptions are listed below, some of which have links to more specific sections of the manual.
MySQL Terms
- Field
- The name of the column in the table. Unlike naming rules for tables, since they are based on the underlying OS, these are restricted both by the MySQL RDBMS, and possibly the Storage Engine of the table itself. See Legal Names for details. If the column name is rendered in blue, then it is a foreign key and selecting it will move you to the detailed view of the index in the table that it references.
- Type
- There are many column types and there is simply no room here for even a brief description of all of them. I recommend you study Column Types thoroughly.
- Null
- Indicates whether Null (empty, void, nil...) values are allowed.
- Key
-
Whether the field is indexed. PRI indicates the key is primary,
UNI indicates the field is part if a unique index and
MUL indicates the field is allowed to have multiple occurances
(non-unique) within an index. Indexes are very important to faciltate fast lookups of data, but
they must be designed with care and some experience. If you’re going to remember
anything from this series, then you should try to remember this: index fields you
search on (where clause), not ones you select (results).
More details will follow in the next section on keys and indexing. Go figure!
Notes: Rows in this view that contain fields that are primary keys are offset from others by the use of a brighter background color. Fields that are keys of any sort are also links in this column to the keys query path for this table. - Default
- The default value, if any, assigned to the field. An Enum (enumerated) type is an example of one that would normally have a default value.
- Extra
- Any additional attributes that may be associated with the field when it was created. An example of this is the auto_increment modifier.
Create Table
To create this table using your own MySQL installation, use the following syntax:
Navigation
To view the indexing details for this table, select any of the links in the Keys column of this view. To continue to browse the database, you can utilize the query and interactive path navigation tools provided with this application. Or simply use your Web browser’s features.
Last updated: Tuesday, February 28th, 2006 @ 2:38 AM EST [2006-02-28T07:38:14Z]
