| name | description | example |
| binary | ||
| unsigned | no negative | if an INT column is UNSIGNED, the size of the column’s range is the same but its endpoints shift up, from -2147483648 and 2147483647 to 0 and 4294967295. |
| unsigned zerofill | add leading zeros | |
| on update CURRENT_TIMESTAMP |