商品列表查询没有delete_at字段报错
来源：1-19 商品列表页接口 - 3
张博0
2023-07-19 11:23:59
[0.000ms] [rows:0] SELECT * FROM `category` WHERE `category`.`id` = 130361 AND `category`.`deleted_at` IS NULL ORDER BY `category`.`id` LIMIT 1
2023/07/19 11:08:38 D:/Softwares/GO/GoWorkstation/src/mxshop/goods_srv/handler/goods.go:67 Error 1054 (42S22): Unknown column 'category.deleted_at' in 'where clause'
[1.032ms] [rows:0] SELECT * FROM `category` WHERE `category`.`id` = 130358 AND `category`.`deleted_at` IS NULL ORDER BY `category`.`id` LIMIT 1
商品列表查询商品分类时候怎么没有delete_at字段 从sql文件.sql导入的goods_srv所有表 ，貌似每张表都少delete_at字段
1回答
-
张博0
提问者
2023-07-19
CREATE TABLE `category` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`parent_category_id` int(11) DEFAULT NULL,
`level` int(11) NOT NULL,
`is_tab` tinyint(1) NOT NULL,
`url` varchar(300) NOT NULL,
`add_time` datetime DEFAULT NULL,
`is_deleted` tinyint(255) DEFAULT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `category_name` (`name`) USING BTREE,
KEY `category_parent_category_id` (`parent_category_id`) USING BTREE,
KEY `category_url` (`url`) USING BTREE,
CONSTRAINT `category_ibfk_1` FOREIGN KEY (`parent_category_id`) REFERENCES `category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=238012 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
0h023-07-25
相似问题
回答 1