错误代码：1100 Table 't_depart_info' was not locked with LOCK TABLES的解决方法
<p>一步步来分析错误代码的生成原因，大家要有耐心哦。</p>
<p>
<strong>第一步，错误描述</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_313052">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">1 queries executed, 0 success, 1 errors, 0 warnings </code>
</div>
<div class="line number2 index1 alt1">
<code class="sql spaces"> </code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">查询：</code><code class="sql keyword">insert</code> <code class="sql keyword">into</code> <code class="sql plain">emp </code><code class="sql keyword">values</code><code class="sql plain">(11,</code><code class="sql string">'h'</code><code class="sql plain">,23,</code><code class="sql string">'女'</code><code class="sql plain">) </code>
</div>
<div class="line number4 index3 alt1">
<code class="sql spaces"> </code>
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">错误代码： 1100 </code>
</div>
<div class="line number6 index5 alt1">
<code class="sql keyword">Table</code> <code class="sql string">'t_depart_info'</code> <code class="sql plain">was </code><code class="sql color1">not</code> <code class="sql plain">locked </code><code class="sql keyword">with</code> <code class="sql plain">LOCK TABLES </code>
</div>
<div class="line number7 index6 alt2">
<code class="sql spaces"> </code>
</div>
<div class="line number8 index7 alt1">
<code class="sql plain">执行耗时 : 0 sec </code>
</div>
<div class="line number9 index8 alt2">
<code class="sql plain">传送时间 : 0 sec </code>
</div>
<div class="line number10 index9 alt1">
<code class="sql plain">总耗时 : 0 sec</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>第二步，错误原因</strong></p>
<p>
将emp数据库表READ锁定：LOCK TABLE emp READ;</p>
<p>
在向emp插入数据，并调用触发器insert_data</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_146905">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">DELIMITER $$ </code>
</div>
<div class="line number2 index1 alt1">
<code class="sql spaces"> </code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">USE `test`$$ </code>
</div>
<div class="line number4 index3 alt1">
<code class="sql spaces"> </code>
</div>
<div class="line number5 index4 alt2">
<code class="sql keyword">DROP</code> <code class="sql keyword">TRIGGER</code> <code class="sql plain">/*!50032 IF EXISTS */ `insert_data`$$ </code>
</div>
<div class="line number6 index5 alt1">
<code class="sql spaces"> </code>
</div>
<div class="line number7 index6 alt2">
<code class="sql keyword">CREATE</code>
</div>
<div class="line number8 index7 alt1">
<code class="sql spaces"> </code><code class="sql plain">/*!50017 DEFINER = </code><code class="sql string">'root'</code><code class="sql plain">@</code><code class="sql string">'localhost'</code> <code class="sql plain">*/ </code>
</div>
<div class="line number9 index8 alt2">
<code class="sql spaces"> </code><code class="sql keyword">TRIGGER</code> <code class="sql plain">`insert_data` BEFORE </code><code class="sql keyword">INSERT</code> <code class="sql keyword">ON</code> <code class="sql plain">`emp` </code>
</div>
<div class="line number10 index9 alt1">
<code class="sql spaces"> </code><code class="sql keyword">FOR</code> <code class="sql plain">EACH ROW </code><code class="sql keyword">BEGIN</code>
</div>
<div class="line number11 index10 alt2">
<code class="sql spaces"> </code><code class="sql keyword">INSERT</code> <code class="sql keyword">INTO</code> <code class="sql plain">t_depart_info(id,depart_name,depart_teacher) </code><code class="sql keyword">VALUES</code><code class="sql plain">(7,</code><code class="sql string">'hai'</code><code class="sql plain">,</code><code class="sql string">'hugang'</code><code class="sql plain">); </code>
</div>
<div class="line number12 index11 alt1">
<code class="sql spaces"> </code><code class="sql keyword">END</code><code class="sql plain">; </code>
</div>
<div class="line number13 index12 alt2">
<code class="sql plain">$$ </code>
</div>
<div class="line number14 index13 alt1">
<code class="sql spaces"> </code>
</div>
<div class="line number15 index14 alt2">
<code class="sql plain">DELIMITER ;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>第三步，解决办法（很简单）</strong></p>
<p>
<span><strong>释放锁</strong></span> <strong><span><span>UNLOCK TABLES;</span></span></strong></p>
<p>
<span><span>其实在遇到错误代码的时候，大家就按照上面这三步走，问题一定会迎刃而解的，要善于发现问题并解决问题。</span></span></p>
頁:
[1]