Description
noneTable properties
| name | value |
|---|
| name | language
|
| created | 3/19/2009 11:39:18 PM
|
| modified |
|
| row count | 6
|
| Size of data | 16 kb
|
| Size of indexes | 0 kb |
| average row size | 2,730 b
|
| engine | InnoDB
|
| version | 10
|
| row format | Compact
|
| max data length | 0 kb
|
| data free | 5242880
|
| auto increment | 7
|
| table collation | utf8_general_ci
|
| create options |
|
Columns
| column | datatype | length | bytes | precision | scale | default | nulls | PK | FK | UQ | extra | privileges | comment |
|---|
| language_id
| tinyint(3) unsigned
|
|
| 3
| 0
|
| NO
| yes
|
| yes
| auto_increment
| select,insert,update,references
|
|
| name
| char(20)
| 20
| 60
|
|
|
| NO
|
|
|
|
| select,insert,update,references
|
|
| last_update
| timestamp
|
|
|
|
| CURRENT_TIMESTAMP
| NO
|
|
|
| on update CURRENT_TIMESTAMP
| select,insert,update,references
|
|
Indexes
| name | columns | unique | cardinality | type | comment |
|---|
| PRIMARY
| language_id
| yes
| 6
| BTREE
|
|
Referenced by
Foreign key graph
Sample rows
| language_id | name | last_update |
|---|
| 1
| English
| 2/15/2006 5:02:19 AM
|
| 2
| Italian
| 2/15/2006 5:02:19 AM
|
| 3
| Japanese
| 2/15/2006 5:02:19 AM
|
| 4
| Mandarin
| 2/15/2006 5:02:19 AM
|
| 5
| French
| 2/15/2006 5:02:19 AM
|
| 6
| German
| 2/15/2006 5:02:19 AM
|
Code
CREATE TABLE `language` (
`language_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`name` char(20) NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`language_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8