MySQL数据库子查询练习——EXISTS

DDL88

DROP TABLE IF EXISTS `wst_user_scores`;
CREATE TABLE `wst_user_scores`  (
  `scoreld` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `userld` int(11) NOT NULL COMMENT '用户ID',
  `score` int(11) NOT NULL COMMENT '积分数',
  `dataSrc` int(11) NOT NULL COMMENT '来源（1：订单2：评价3：订单取消4：拒收返还）',
  `datald` int(11) NOT NULL COMMENT '来源记录ID',
  `dataRemarks` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '描述（N/A）',
  `scoreType` int(11) NOT NULL COMMENT '积分类型（1：收入2：支出）',
  `createTime` datetime(0) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`scoreld`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;