SQL规范检查

亦凉 2022-12-25 04:52 237阅读 0赞

<table style="width:500px;"> 
 <tbody> 
 <tr> 
 <td>序号</td> 
 <td>规则</td> 
 <td>规则等级</td> 
 <td>数据库类型</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;width:54pt;">1</td> 
 <td style="vertical-align:middle;width:54pt;">Update/Delete需要带上where条件</td> 
 <td style="vertical-align:middle;width:54pt;">error</td> 
 <td style="vertical-align:middle;width:54pt;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">2</td> 
 <td style="vertical-align:middle;">不允许使用Truncate table语句</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">3</td> 
 <td style="vertical-align:middle;">Update/Delete不允许带limit条件</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">4</td> 
 <td style="vertical-align:middle;">Update/Delete不允许带orderby条件</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">5</td> 
 <td style="vertical-align:middle;">不使用“SELECT *”这样的语句</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">6</td> 
 <td style="vertical-align:middle;">不使用DML广播语句</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">7</td> 
 <td style="vertical-align:middle;">不允许Insert/Update/Delete语句跨分片执行</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">8</td> 
 <td style="vertical-align:middle;">不使用DML跨分片Join语句</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">9</td> 
 <td style="vertical-align:middle;">不使用DML跨分片Union语句</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">10</td> 
 <td style="vertical-align:middle;">select汇聚超过限定行数</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">11</td> 
 <td style="vertical-align:middle;">update和delete语句，限制影响行数</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">12</td> 
 <td style="vertical-align:middle;">select语句，限制影响行数</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">13</td> 
 <td style="vertical-align:middle;">update和delete语句，限制实际影响行数</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">14</td> 
 <td style="vertical-align:middle;">DML未使用索引的SQL</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td style="vertical-align:middle;">15</td> 
 <td style="vertical-align:middle;">SELECT语句需要带上where条件</td> 
 <td style="vertical-align:middle;">error</td> 
 <td style="vertical-align:middle;">Mysql</td> 
 </tr> 
 <tr> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 <td>&nbsp;</td> 
 </tr> 
 </tbody> 
</table>