各位大师们:
我想用MySQL中的LONG类型,可是建表之后,系统默认给改成了MEDIUMTEXT,不知为何,请大师们指点迷津!谢过啦~~
建表语句:
CREATE TABLE testLong(
id INT UNSIGNED NOT NULL AUTO_INCREMENT ,
number1 LONG NULL ,
PRIMARY KEY (id
) );
查看结果:DESC testlong;
+---------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| number1 | mediumtext | YES | | NULL | |
+---------+------------------+------+-----+---------+----------------+