[Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as

最新推荐文章于 2024-04-16 20:31:31 发布
原创 最新推荐文章于 2024-04-16 20:31:31 发布 · 1.4w 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文解决了一个在MySQL数据库中创建表时遇到的错误：'Incorrect table definition; there can be only one auto column and it must be defined as a key'. 通过在创建表时明确声明主键，成功避免了该错误。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

msyql 数据库 报错

[Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key


sql 语句创建表，报错语句如下 


 

create table users(


id int not null auto_increment  ,
uname  varchar(30)  not null  ,
upwd int not null  ,
note varchar(30) not null    
)





create table tusers(
id int not null auto_increment  ,
uname  varchar(30)  not null  ,
upwd int not null  ,
note varchar(30) not null,
primary key(id) 
)


加上  声明一个主键 就ok啦。


记录:MySQL报错1075 - Incorrect table defintion；there can be only...【解决方案】
**My Coding Family**
04-04 1万+
解决:MySQL报错1075 - Incorrect table defintion；there can be only...不会我教你啊。
CWE：通病总结
mzhan017的博客
12-16 5285
文章目录网站398686 网站 https://cwe.mitre.org/data/definitions/686.html 398 风格问题，如果一个局部变量，可以放在一个更小的区域，而且满足使用，最好是将作用域缩小。但是需要注意不要搞错。检查工具有点时候，检查有问题。 [STYLE] (cwe=398, variableScope): The scope of the variable ‘left’ can be reduced., The scope of the variable ‘left’ c
出现1075：Incorrect table definition； there can be only one auto column and it must be defined as a key
qq_46940100的博客
04-05 5186
删除主键出错
[Err] 1075 - Incorrect table definition； there can be only one auto column and it must be defined 解决
亲测，只为展现最完美的有效！
12-26 708
原因 mysql新建表时，设置自增长的字段没有设置成主键 通常我们这么做（我是用powerdesigner设计后导出） create table tb_department ( Id bigint not null auto_increment comment 'id', Name varchar(60) not null default '' comment '名称', Short_Name varc
1075-Incorrect table definition；there can be only one auto column and it must be defined as a key
游海东的技术专栏
09-09 1万+
1、错误描述1075-Incorrect table definition；there can be only one auto column and it must be defined as a key2、错误原因     这个错误的原因是由于，在创建数据库表时，创建了两个自增的字段和主键，这样的方式在MySQL数据库不被允许3、解决办法（1）修改自增字段和主键字段（2）或者使用联合主键
[Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
11-01
there can be only one auto column and it must be defined as a key报错】 【Fix MySQL ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key】...
[SQL] Query gudingzichan start [ERR] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key [ERR] CREATE TABLE `users` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(10) NOT NULL, `password` varchar(10) NOT NULL, `tell` varchar(11) NOT NULL, `jibei` char(1) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TABLE `liebie` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `text` varchar(255) NULL, `nianxian` varchar(5) NULL, `fenlei` varchar(10) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TABLE `guanli` ( `id` int(10) NOT NULL AUTO_INCREMENT, `bumen` int(10) NULL, `fuzeren` int(10) NULL, `kuguan` int(10) NULL, `caiwu` int(10) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TABLE `zichan` ( `id` int(10) NOT NULL AUTO_INCREMENT, `liebie` int(10) NULL, `bumen` int(10) NULL, `name` varchar(10) NOT NULL, `guige` varchar(100) NULL, `danwei` int(1) NULL, `year` varchar(50) NULL, `fangshi` int(1) NULL, `yuanzhi` varchar(50) NULL, `beizhu` varchar(255) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TABLE `danwei` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(5) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TABLE `fangshi` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(5) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TABLE `bumen` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(50) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TABLE `zichan_mingxi` ( `id` int(10) NOT NULL AUTO_INCREMENT, `fenlei` int(10) NULL, `bianma` int(8) ZEROFILL NOT NULL AUTO_INCREMENT, `zichan` int(10) NULL, `shiyongren` int(10) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`, `bianma`) ); CREATE TABLE `weixiu` ( `id` int(10) NOT NULL AUTO_INCREMENT, `users` int(10) NULL, `gongzhong` varchar(50) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TABLE `weixui_mingxi` ( `id` int(10) NOT NULL AUTO_INCREMENT, `weixiuren` int(10) NULL, `zichanbianma` int(10) NULL, `zhuangtai` char(1) NULL, PRIMARY KEY (`id`) ); CREATE TRIGGER ON `weixui_mingxi` FOR EACH ROW ; ALTER TABLE `zichan` ADD CONSTRAINT `zichan_liebie` FOREIGN KEY (`liebie`) REFERENCES `liebie` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `zichan` ADD CONSTRAINT `zichan_danwei` FOREIGN KEY (`danwei`) REFERENCES `danwei` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `zichan` ADD CONSTRAINT `zicahn_fangshi` FOREIGN KEY (`fangshi`) REFERENCES `fangshi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `zichan` ADD CONSTRAINT `zichan_bumen` FOREIGN KEY (`bumen`) REFERENCES `bumen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `guanli` ADD CONSTRAINT `guanli_bumen` FOREIGN KEY (`bumen`) REFERENCES `bumen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `guanli` ADD CONSTRAINT `guanli_fuzeren` FOREIGN KEY (`fuzeren`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `guanli` ADD CONSTRAINT `guanli_kuguan` FOREIGN KEY (`kuguan`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `guanli` ADD CONSTRAINT `guanli_caiwu` FOREIGN KEY (`caiwu`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `zichan_mingxi` ADD CONSTRAINT `zichanmingxi_fenlei` FOREIGN KEY (`fenlei`) REFERENCES `liebie` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `zichan_mingxi` ADD CONSTRAINT `zichanmingxi_zichan` FOREIGN KEY (`zichan`) REFERENCES `zichan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `zichan_mingxi` ADD CONSTRAINT `zichanmingxi_shiyongren` FOREIGN KEY (`shiyongren`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `weixiu` ADD CONSTRAINT `weixiu_users` FOREIGN KEY (`users`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `weixui_mingxi` ADD CONSTRAINT `weixiumingxi_weixiuren` FOREIGN KEY (`weixiuren`) REFERENCES `weixiu` (`id`) ON DELETE C [SQL] Finished with error
最新发布
08-05
去掉`id`列，将`bianma`作为主键（因为它是自增且唯一），并去掉自增属性中的`AUTO_INCREMENT`（因为已经有一个自增列了，但这里我们保留`bianma`的自增属性，并将它设为主键）。但是原表定义中`bianma`是自增的，...
IBM DB2 SQL error code list
weixin_30426957的博客
08-25 2311
SQL return codes that are preceded by a minus sign (-) indicate that the SQL statement execution was unsuccessful. IBM DB2 SQL error code list 官方文档地址：https://www.ibm.com/support/knowledgecente...
1075 - Incorrect table definition； there can be only one auto column and it must be defined as a key
qq_43012792的博客
08-03 9004
mysql报1075错误【图文讲解】： 原因是：该表中一个字段设置成了主键（非空、唯一），而且又把另外一些字段设置成了自动递增 解决：把非主键的字段的自动递增取消掉即可，因为不允许这么做。 有用点个关注，手留余香！ ???? ???? ???? ...
#1075-Incorrect table definition；there can be only one auto column and it must be defined as a key
qq_47664976的博客
07-26 7366
在使用Navicat for MySQL建表时出现#1075-Incorrect table definition;there can be only one auto column and it must be defined as a key这样的问题。 这个错误是：表定义不正确；只能由一个自动列，必须将其定义为主键。 mysql建表时如果要设置自动递增，必须要是逐渐设置才行，且不能为零只能设置一个。 所以出现这样的问题，检查建表语句，如果设置了自增，需要将自增字段设置为主键。 ...
1075 - Incorrect table definition;there can be only one auto column and it must be defined as a key
牛栏山矿泉水
10-22 404
1、错误描述 2、错误原因 建表时id，勾选自动递增，不是null，但是没有将其设置成为主键 3、解决办法 将表中的id定义成主键
1075-Incorrect table definition； there can be only one auto column and it must be defined as a key
Aile
07-07 1352
数据库设计表的常见问题
MYSQL报错1075 ‘Incorrect table definition； there can be only one auto column and it must be defined as
2302_81271670的博客
04-16 783
当我们遇到这个问题时，可能是因为要删除主键id，但id设置了自增，由于自增要求列必须为唯一，所以执行。初学者在使用Windows基础的数据库时可以使用。先删除主键自增然后再运行删除语句就可以了。
MySQL报错1075: Incorrect table definition； there can be only one auto column and it must be defined *
热门推荐
Donald Su
01-21 4万+
MySQL中，添加联合主键时，执行SQL语句时，报错：ERROR 1075: Incorrect table definition; there can be only one auto column and it must be defined as a key。 以下是我遇到的问题场景，其他同学场景基本上都类似（涉及到自增列），可以直接跳到“解决方法”部分阅读，查看该问题发生的本质原因以及解决方法。 文章目录1、问题发生场景2、解决方法3、参考 1、问题发生场景 如下数据表中，将原主键modu..
MySQL：1075 - Incorrect table definition; there can be only one auto column and it must be defined as
6块腹肌的博客
08-01 3964
1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key 发生该错误的原因是一个字段设置了自动递增，另外一个字段被设置为主键，发生冲突。 ...
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值