duanmie9682 2014-08-16 23:11 采纳率: 100%
浏览 301
已采纳

mysql:表创建时不存在错误

slm, HI can you help me please ! my problem is when i create a new table named : fiche_med like this:

create table fiche_med(id int(10) primary key not null) on MYSQL i have that message error :

#1146 - Table 'test.fiche_med' doesn't exist

  • 写回答

2条回答 默认 最新

  • doulao2128 2014-08-16 23:22
    关注

    :) well the solution is that you have to remove all views using a table witch have same name (i hade a table named fiche_med that i removed) as your new table and then restart your MYSQL server

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 seatunnel 怎么配置Elasticsearch
  • ¥15 PSCAD安装问题 ERROR: Visual Studio 2013, 2015, 2017 or 2019 is not found in the system.
  • ¥15 (标签-MATLAB|关键词-多址)
  • ¥15 关于#MATLAB#的问题,如何解决?(相关搜索:信噪比,系统容量)
  • ¥500 52810做蓝牙接受端
  • ¥15 基于PLC的三轴机械手程序
  • ¥15 多址通信方式的抗噪声性能和系统容量对比
  • ¥15 winform的chart曲线生成时有凸起
  • ¥15 msix packaging tool打包问题
  • ¥15 finalshell节点的搭建代码和那个端口代码教程