Skip to content

Instantly share code, notes, and snippets.

@SpringMT

SpringMT/gist:3999615

Created November 2, 2012 09:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SpringMT/3999615 to your computer and use it in GitHub Desktop.
Save SpringMT/3999615 to your computer and use it in GitHub Desktop.
Download ZIP
schema
Raw
gistfile1.txt
(root@localhost:mysql.sock) [bench_work] 18:02 (5.5.19-log)> desc test;
+-----------+-----------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-----------------------+------+-----+-------------------+-----------------------------+
| tiny | tinyint(4) | YES | | NULL | |
| utiny | tinyint(3) unsigned | YES | | NULL | |
| small | smallint(6) | YES | | NULL | |
| usmall | smallint(5) unsigned | YES | | NULL | |
| medium | mediumint(9) | YES | | NULL | |
| umedium | mediumint(8) unsigned | YES | | NULL | |
| i | int(11) | YES | | NULL | |
| ui | int(10) unsigned | YES | | NULL | |
| big | bigint(20) | YES | | NULL | |
| ubig | bigint(20) unsigned | YES | | NULL | |
| f | float | YES | | NULL | |
| d | double | YES | | NULL | |
| c | char(100) | YES | | NULL | |
| vc | varchar(100) | YES | | NULL | |
| date | date | YES | | NULL | |
| datetime | datetime | YES | | NULL | |
| timestamp | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
+-----------+-----------------------+------+-----+-------------------+-----------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment