1146 - Table 'xxx.xxx' doesn't exist
来源:互联网 发布:淘宝图片排序二个一排 编辑:程序博客网 时间:2024/06/05 08:33
今天开始测试mysql的新版本,从生产mysql库中备份部分表到测试库中。
测试中发现,有些表可以查询出数据,但不能update,报1146,表不存在。
mysql> select version();
+------------+
| version() |
+------------+
| 5.6.12-log |
+------------+
1 row in set
mysql> select bonus from ei_case where case_no='HT102398';
+-------+
| bonus |
+-------+
| 0 |
+-------+
1 row in set
mysql> explain update ei_case set bonus=100 where case_no='HT102398';
+----+-------------+-----------------+-------+---------------+---------+---------+------+--------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------------+-------+---------------+---------+---------+------+--------+-------------+
| 1 | SIMPLE | ei_case | index | NULL | PRIMARY | 4 | NULL | 220156 | Using where |
+----+-------------+-----------------+-------+---------------+---------+---------+------+--------+-------------+
1 row in set
mysql> update ei_case set bonus=100 where case_no='HT102398';
1146 - Table 'test.ei_case_initial' doesn't exist
经查发现要更新的这个表上有个TRIGGER,在update后会向另一张表中插入数据。
而这个表没有从生产复制过来,所以报错。
- 1146 - Table 'xxx.xxx' doesn't exist
- hibernate---Table 'XXX.XXX' doesn't exist
- 表不存在1146:table 'xxx.xxx' doesn't exist
- Table 'database1.xxx' doesn't exist
- 10020---hibernate---Table 'XXX.XXX' doesn't exist
- linux下解决mysql table xxx doesn't exist
- 解决Discuz! X2.5 后台能登陆,前台提示“[1146] Table 'xxx.myrepeats' doesn't exist”错误
- MySql - 导入数据时 Table XXX doesn't exist 的解决
- mysql表复制文件过去以后提示 Mysql table 'xxx' doesn`t exist
- Linux环境下MySQL报Table 'xxx' doesn't exist错误解决方法
- Linux下MySQL报Table 'xxx' doesn't exist错误解决方法
- 遇到这个问题SQL execution # 1146.Response from database:Table 'xxx' doesn't exist
- Mysql table '' doesn`t exist
- Android报错:Parent file doesn't exist:/Users/XXX/Library/Caches/AndroidStudio2.3/caches/
- MySQL错误:1146-table 'mysql.proc' doesn't exist
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't exist
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't exist
- ERROR 1146 (42S02): Table 'mysql.slow_log' doesn't exist
- 音频采样率
- php清空目录函数
- js去掉空格(左,右,全部)
- 装箱和拆箱
- C# 动态加载dll
- 1146 - Table 'xxx.xxx' doesn't exist
- linux命令行的$和#
- Winform连接SQL数据库并实现用户登录
- google快捷键
- 第一章 - 整洁代码 - 读书心得
- 详解Java解析XML的四种方法
- About Unit Testing单元测试摘要
- POJ 3225 Help with Intervals(线段树)
- Linux Shell判断某程序是否在运行