四、MySQL的数据类型和运算符
mysql> CREATE TABLE tmp1(x TINYINT,y SMALLINT,z MEDIUMINT,m INT,n BIGINT);Query OK, 0 rows affected (0.05 sec)
mysql> DESC tmp1;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| x | tinyint(4) | YES| | NULL | |
| y | smallint(6)| YES| | NULL | |
| z | mediumint(9) | YES| | NULL | |
| m | int(11) | YES| | NULL | |
| n | bigint(20) | YES| | NULL | |
+-------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
页:
[1]