Mysql create table failure: ERROR 1005 (HY000): Can't create table 'lams.attendance1' (errno: 121)
来源:互联网 发布:怎么能开淘宝店铺 编辑:程序博客网 时间:2024/05/21 00:48
ERROR 1005 (HY000): Can't create table 'lams.attendance1' (errno: 121)
ERROR 1005: Can't create table (errno: 121)
errno 121 means a duplicate key error. Probably the table already exists in the InnoDB internal data dictionary, though the .frm file for the table has been deleted. This is the most common reason for getting errno 121 in table creation. Another possible reason is a name conflict in a foreign key constraint name. Constraint names must be unique in a database, like table names are.
意思是:
1、表名重复
2、以该名字命名的表之前创建过后来删除了,但是对应的.frm文件还留在磁盘上
3、主键名字在全数据库范围内不是唯一的
阅读全文
0 0
- Mysql create table failure: ERROR 1005 (HY000): Can't create table 'lams.attendance1' (errno: 121)
- ERROR 1005 (HY000): Can't create table 'XXXXX' (errno: 150)
- ERROR 1005 (HY000): Can't create table '' (errno: 150)
- mysql ERROR: Error 1005: Can't create table (errno: 121)
- Mysql 的ERROR 1005 (HY000): Can't create table 'xxx' (errno: 150)
- MySQL 外键创建表失败 ERROR 1005 (HY000): Can't Create Table....(errno: 150)
- MySQL ERROR 1005 (HY000): Can't create table 'schema_name.table_name' (errno: 150)
- mysql创建表失败 ERROR 1005 (HY000): Can't create table (errno: 13)
- MySQL错误之ERROR 1005 (HY000): Can't create table '******' (errno: 150)
- mysql:ERROR 1005 (HY000): Can't create table 'company.#sql-45d5_9' (errno: 150)
- mysql 1005-Can't create table ''error:121&mysql error 1005 can't create table'<errno:150>
- MYSQL中ERROR 1005 (HY000): Can't create table 错误
- mysql 外键约束不能重名ERROR 1005 (HY000): Can't create table 'prize.tb_power' (errno: 121)
- MySQL ERROR 1005: Can't create table (errno: 150)解决办法
- MySQL ERROR 1005: Can't create table (errno: 150)解
- MySQL ERROR 1005: Can't create table (errno: 150)
- MySQL ERROR 1005: Can't create table (errno: 150)解决办法
- MySQL ERROR 1005: Can't create table (errno: 150)
- Hibernate(五):Hibernate映射——一对一单向关联映射
- 欢迎使用CSDN-markdown编辑器
- 仿照JAVA vector模型写一个SuperArray
- 1115: 数字统计
- C++作业6
- Mysql create table failure: ERROR 1005 (HY000): Can't create table 'lams.attendance1' (errno: 121)
- Generate Parentheses
- eclipse安装svn插件
- CDN 技术详解--读书笔记-完
- quadratic equation
- fedora 安装eclipse和pydev以及wxpython
- UVA 1395 Slim Span--苗条的生成树(并查集+枚举)
- 发送短信(阿里云短信发送方式)
- 【剑指offer-解题系列(4)】重建二叉树