title: mysql why fields type of int have no length
body: <p>I export a mysql schema from the server and import it to another server, but when I check the tables' schema, I found all int type fields have no length.</p>
  <p>But when I tried to import it to my local mysql, It is all normal.</p>
  <p>schema that has problem:</p>
  <pre><code>mysql&gt; desc user;
  +------------+--------------+------+-----+---------+----------------+
  | Field      | Type         | Null | Key | Default | Extra          |
  +------------+--------------+------+-----+---------+----------------+
  | id         | int unsigned | NO   | PRI | NULL    | auto_increment |
  | key        | varchar(255) | YES  |     | NULL    |                |
  | remark     | varchar(255) | YES  |     | NULL    |                |
  | created_at | int          | YES  |     | NULL    |                |
  | updated_at | int          | YES  |     | NULL    |                |
  +------------+--------------+------+-----+---------+----------------+
  5 rows in set (0.00 sec)
  </code></pre>
  <p>schema on the local:</p>
  <pre><code>mysql&gt; desc user;
  +------------+------------------+------+-----+---------+----------------+
  | Field      | Type             | Null | Key | Default | Extra          |
  +------------+------------------+------+-----+---------+----------------+
  | id         | int(11) unsigned | NO   | PRI | NULL    | auto_increment |
  | key        | varchar(255)     | YES  |     | NULL    |                |
  | remark     | varchar(255)     | YES  |     | NULL    |                |
  | created_at | int(11)          | YES  |     | NULL    |                |
  | updated_at | int(11)          | YES  |     | NULL    |                |
  +------------+------------------+------+-----+---------+----------------+
  5 rows in set (0.01 sec)
  </code></pre>
  <p>mysql on the server is the official images of mysql of docker : <code>Server version: 8.0.21 MySQL Community Server - GPL</code></p>
  <p>my local mysql is install by homebrew: <code>Server version: 8.0.16 Homebrew</code></p>
  <p>Why dose this happen? And how to fix it?</p>