mysql报ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must
来源:互联网 发布:win10 linux安装教程 编辑:程序博客网 时间:2024/06/06 00:51
mysql在建表时报故障ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
create table ll(
-> id int(5) not null auto_increment,
-> name varchar(10),
-> age int(10));
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
原因:在设置了自增长列以后需要定义主键列,否则报错
添加主键,修改后成功:
create table ll(
-> id int(5) not null auto_increment,
-> name varchar(10),
-> primary key(id));
Query OK, 0 rows affected (0.81 sec)
阅读全文
0 0
- mysql报ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must
- ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be def
- ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be def
- 创建主键时报错:ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it mus
- 创建主键时报错:ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it mus
- [Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as
- 1075 - Incorrect table definition;there can be only one auto column and it must be defined as a key
- [Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as
- 1075-Incorrect table definition;there can be only one auto column and it must be defined as a key
- Incorrect table definition; there can be only one auto column and it must be defined as a key
- MySQL 数据表创建报错:there can be only one auto column and it must be defined as a key
- error : Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in
- mysql单表多timestamp报错#1293 - Incorrect table definition; there can be only one TIMESTAMP column with C
- Mysql 1293 - Incorrect table definition; there can be only one TIMESTAMP column with C
- [Err] 1293 - Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTA
- mysql报there can be only one auto column的问题原因
- MySQL 5.4.6之前有关timestamp设置current_timestamp时报错there can be only one TIMESTAMP column with CURRENT_TI
- there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
- Java泛型
- IntentService解析与使用
- 洛谷Oj-[USACO1.1]贪婪的送礼者-模拟
- Qt 学习之路 2(25):画刷和画笔
- 在本地计算机上注册“microsoft.ACE.oledb.12.0”提供程序
- mysql报ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must
- 深入解读缓存(二)——一致性Hash算法
- ASP 使用 Request.ServerVariables(HTTP_REFERER) 方法获取请求页面地址的注意事项
- JMS(一):JMS基础;一个JMS例子
- 一文入门百度天工IOT平台
- python-多态、类属性、类方法、静态方法、异常
- angular js 终极购物车
- 两个链表的第一个公共结点
- Matplotlib之pyplot常用操作(一)