MySQL表名、列名长度限制

柔光的暖阳◎ 2022-01-29 23:07 507阅读 0赞

参考文献:[https://dev.mysql.com/doc/refman/8.0/en/identifiers.html][https_dev.mysql.com_doc_refman_8.0_en_identifiers.html]

<table> 
 <thead> 
  <tr> 
   <th>Identifier Type</th> 
   <th>Maximum Length (characters)</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <th>Database</th> 
   <td>64 (<a href="https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster.html" rel="nofollow"><code>NDB</code></a>&nbsp;storage engine: 63)</td> 
  </tr> 
  <tr> 
   <th>Table</th> 
   <td>64 (<a href="https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster.html" rel="nofollow"><code>NDB</code></a>&nbsp;storage engine: 63)</td> 
  </tr> 
  <tr> 
   <th>Column</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>Index</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>Constraint</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>Stored Program</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>View</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>Tablespace</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>Server</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>Log File Group</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>Alias</th> 
   <td>256 (see exception following table)</td> 
  </tr> 
  <tr> 
   <th>Compound Statement Label</th> 
   <td>16</td> 
  </tr> 
  <tr> 
   <th>User-Defined Variable</th> 
   <td>64</td> 
  </tr> 
  <tr> 
   <th>Resource Group</th> 
   <td>64</td> 
  </tr> 
 </tbody> 
</table>

附：其他数据库

<table style="width:549px;"> 
 <tbody> 
  <tr> 
   <td> <p>数据库类型</p> </td> 
   <td> <p>表名</p> </td> 
   <td> <p>字段名</p> </td> 
  </tr> 
  <tr> 
   <td> <p>SQL SERVER</p> </td> 
   <td> <p>128个字符，临时表116个字符</p> </td> 
   <td> <p>128个字符</p> </td> 
  </tr> 
  <tr> 
   <td> <p>Oracle</p> </td> 
   <td> <p>30个字符</p> </td> 
   <td> <p>30个字符</p> </td> 
  </tr> 
  <tr> 
   <td> <p>MySQL</p> </td> 
   <td> <p>64个字符</p> </td> 
   <td> <p>64个字符</p> </td> 
  </tr> 
  <tr> 
   <td> <p>Access</p> </td> 
   <td> <p>64个字符</p> </td> 
   <td> <p>64个字符</p> </td> 
  </tr> 
  <tr> 
   <td> <p>DB2</p> </td> 
   <td> <p>128个字符</p> </td> 
   <td> <p>128个字符</p> <p>&nbsp;</p> </td> 
  </tr> 
 </tbody> 
</table>

[https_dev.mysql.com_doc_refman_8.0_en_identifiers.html]: https://dev.mysql.com/doc/refman/8.0/en/identifiers.html