Mysql导入官方示例employees问题解决记录

来源：互联网发布：怀孕31周b超数据编辑：程序博客网时间：2024/05/17 18:13

前期准备

下载相关文件并解压缩

导入报错：

报错处理

修改路径为绝对路径

重新导入依然报错

依然报错，如上面的参考文章所示为什么人家是正确了。我是在资源管理器地址栏直接复制地址，是反斜杠。
全部替换成正斜杆。

设置默认default_storage_engine

Unknown system variable ‘storage_engine

参考文章：www.cnblogs.com/rgtv-wilkins/p/5147676.html
解决办法：

<code class="language-javascript hljs  has-numbering" style="display: block; padding: 0px; color: inherit; box-sizing: border-box; font-family: 'Source Code Pro', monospace;font-size:undefined; white-space: pre; border-radius: 0px; word-wrap: normal; background: transparent;">line <span class="hljs-number" style="color:#06666;box-sizing: border-box;">38</span> :set storage_engine = InnoDB;   改为 set default_storage_engine = InnoDB;line <span class="hljs-number" style="color:#06666;box-sizing: border-box;">44</span> :select CONCAT(<span class="hljs-string" style="color:#0880;box-sizing: border-box;">'storage engine: '</span>, @@storage_engine) as INFO; 改为 select CONCAT(<span class="hljs-string" style="color:#0880;box-sizing: border-box;">'storage engine: '</span>, @@default_storage_engine) as INFO;</code><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li></ul><ul class="pre-numbering" style="box-sizing: border-box; position: absolute; width: 50px; top: 0px; left: 0px; margin: 0px; padding: 6px 0px 40px; border-right-width: 1px; border-right-style: solid; border-right-color: rgb(221, 221, 221); list-style: none; text-align: right; background-color: rgb(238, 238, 238);"><li style="box-sizing: border-box; padding: 0px 5px;">1</li><li style="box-sizing: border-box; padding: 0px 5px;">2</li><li style="box-sizing: border-box; padding: 0px 5px;">3</li></ul>

导入成功

0 0