INT UNSIGNED
mysql> mysql> CREATE TABLE attendee( -> att_id INT UNSIGNED NOT NULL AUTO_INCREMENT, -> att_name CHAR(100), -> att_title CHAR(40), -> PRIMARY KEY (att_id) -> ); Query OK, 0 rows affected (0.01 sec) mysql> mysql> drop table attendee; Query OK, 0 rows affected (0.00 sec)
1. | Int(11) not null | ||
2. | Default null value for Int type column | ||
3. | INTEGER(4) ZEROFILL | ||
4. | The width specification is most often used with zerofill | ||
5. | Compare with integers | ||
6. | How MySQL deals with non-exist number |