SELECT gs.`id`,gs.`title`,gs.`zhaiyao`,gs.`img_url`
FROM good_category gc
LEFT JOIN good_secondData gs ON gc.`id`=gs.`goodCategoryId`
WHERE gs.`goodCategoryId` = 1
CREATE TABLE `news_information_list` (
`id` INT NOT NULL AUTO_INCREMENT,
`title` VARCHAR(100) DEFAULT NULL,
`click` INT DEFAULT NULL,
`add_time` DATETIME DEFAULT NULL,
`zhaiyao` VARCHAR(999) DEFAULT NULL,
`img_url` VARCHAR(999),
PRIMARY KEY (`id`)
)
uniapp微信小程序数据库建表
最新推荐文章于 2024-05-13 20:03:48 发布