问答博客资讯标签用户活动
logo极客观点logo项目管理logoHarmonyOS
开发者社区
javascript
前端
python
node.js
react
vue.js
php
laravel
go
人工智能
mysql
linux
ios
java
android
css
typescript
spring
程序员
logoONES 研发管理logo思否企业问答logo安谋科技 XPU

mysql多个数据总结成一条数据

头像
arsenal91
    10211222

    3个表
    1.问题表tbl_question
    id,fk_questionnaire_id (问卷id，统一为1)，title(问题名称),type(1单选2多选3填空)，create_time
    2.问题选项表tbl_answer
    id，fk_question_id(问题id)，answer_name（选项名称），number（选择的个数，答题每答一次自动加1），
    3.问卷回答表tbl_question_deail
    id，openid（回答用户的唯一标识），fk_questionnaire_id (问卷id，统一为1),fk_question_id(问题id)，fk_answer_id（答案id），remark（问卷问题不是选择题，是填空题时的记录）

    clipboard.png
    实际数据如上图
    用户填问卷，单选题就多一条记录，多选题用户多选的话，就会多多条记录，问答题的话，fk_aid为空，remark记录用户填空的答案
    根据这个这个表，怎么获取每个用户的答题情况
    怎么写sql语句，才能让每个用户成一行数据，多选的可以用逗号分割开

    SET FOREIGN_KEY_CHECKS=0;

    -- ----------------------------
    -- Table structure for wx_question
    -- ----------------------------
    DROP TABLE IF EXISTS wx_question;
    CREATE TABLE wx_question (
    id int(11) NOT NULL AUTO_INCREMENT,
    fk_questionnaire_id int(11) unsigned DEFAULT NULL,
    title varchar(256) DEFAULT NULL,
    creater char(32) DEFAULT NULL,
    type tinyint(4) DEFAULT NULL,
    create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    remark varchar(128) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY fk_questionnaire_id (fk_questionnaire_id)
    ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='问卷题目表';

    -- ----------------------------
    -- Records of wx_question
    -- ----------------------------
    INSERT INTO wx_question VALUES ('7', '1', '若双喜组织同城品吸会，请问您是否愿意参加呢？', null, '1', '2017-05-26 10:51:15', null);
    INSERT INTO wx_question VALUES ('8', '1', '您希望品吸到的香烟规格是哪些呢？（可复选）', null, '2', '2017-05-26 10:51:15', null);
    INSERT INTO wx_question VALUES ('9', '1', '您的身份是？', null, '1', '2017-05-26 10:51:16', null);
    INSERT INTO wx_question VALUES ('10', '1', '您的姓名是？', null, '3', '2017-05-26 10:51:16', null);
    INSERT INTO wx_question VALUES ('11', '1', '您的手机是？', null, '3', '2017-05-26 10:51:16', null);
    INSERT INTO wx_question VALUES ('12', '1', '您所在的地区是？（请填写省市区，例：广东省广州市天河区）', null, '3', '2017-05-26 10:51:16', null);

    -- ----------------------------
    -- Table structure for wx_question_answer
    -- ----------------------------
    DROP TABLE IF EXISTS wx_question_answer;
    CREATE TABLE wx_question_answer (
    id int(11) NOT NULL AUTO_INCREMENT,
    fk_question_id int(11) DEFAULT NULL,
    answer_name varchar(256) DEFAULT NULL,
    number int(11) DEFAULT NULL,
    creater char(32) DEFAULT NULL,
    create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    remark varchar(500) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY fk_question_id (fk_question_id)
    ) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='问卷答案选项表';

    -- ----------------------------
    -- Records of wx_question_answer
    -- ----------------------------
    INSERT INTO wx_question_answer VALUES ('25', '7', '愿意', '5690', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('26', '7', '不愿意', '252', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('27', '8', '国喜', '2734', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('28', '8', '国喜细支', '2281', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('29', '8', '沉香', '2036', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('30', '8', '红邮喜', '1204', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('31', '8', '五叶神金尊', '1540', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('32', '8', '喜百年', '1104', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('33', '8', '和喜', '817', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('34', '8', '花悦', '625', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('35', '8', '百年红', '922', null, '2017-05-26 10:51:15', null);
    INSERT INTO wx_question_answer VALUES ('36', '8', '百年经典', '1121', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('37', '8', '经典工坊', '1000', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('38', '8', '经典1906', '1304', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('39', '8', '金01', '1065', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('40', '8', '世纪经典', '799', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('41', '8', '硬逸品', '842', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('42', '8', '双喜（传奇）', '915', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('43', '8', '典藏逸品', '1236', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('44', '8', '双喜(珍藏)', '1166', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('45', '8', '硬红五叶神', '674', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('46', '8', '莲香', '1097', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('47', '9', '零售户', '1491', null, '2017-05-26 10:51:16', null);
    INSERT INTO wx_question_answer VALUES ('48', '9', '消费者', '4452', null, '2017-05-26 10:51:16', null);

    -- ----------------------------
    -- Table structure for wx_question_detailrecord
    -- ----------------------------
    DROP TABLE IF EXISTS wx_question_detailrecord;
    CREATE TABLE wx_question_detailrecord (
    id int(11) NOT NULL AUTO_INCREMENT,
    fk_questionnaire_id int(11) DEFAULT NULL,
    fk_question_id int(11) DEFAULT NULL,
    fk_answer_id int(11) DEFAULT NULL,
    openid varchar(50) DEFAULT NULL,
    remark varchar(512) DEFAULT NULL,
    PRIMARY KEY (id),
    KEY fk_questionnaire_id (fk_questionnaire_id),
    KEY fk_question_id (fk_question_id),
    KEY fk_answer_id (fk_answer_id)
    ) ENGINE=InnoDB AUTO_INCREMENT=54192 DEFAULT CHARSET=utf8 COMMENT='问卷调查记录详情表';

    -- ----------------------------
    -- Records of wx_question_detailrecord
    -- ----------------------------
    INSERT INTO wx_question_detailrecord VALUES ('1', '1', '7', '25', 'ojQ7isny-6O69dnD3qSDY9pQAbXo', null);
    INSERT INTO wx_question_detailrecord VALUES ('2', '1', '8', '37', 'ojQ7isny-6O69dnD3qSDY9pQAbXo', null);
    INSERT INTO wx_question_detailrecord VALUES ('3', '1', '9', '48', 'ojQ7isny-6O69dnD3qSDY9pQAbXo', null);
    INSERT INTO wx_question_detailrecord VALUES ('4', '1', '10', null, 'ojQ7isny-6O69dnD3qSDY9pQAbXo', 'Jj');
    INSERT INTO wx_question_detailrecord VALUES ('5', '1', '11', null, 'ojQ7isny-6O69dnD3qSDY9pQAbXo', '135xxx655');
    INSERT INTO wx_question_detailrecord VALUES ('6', '1', '12', null, 'ojQ7isny-6O69dnD3qSDY9pQAbXo', '广州市天河区');
    INSERT INTO wx_question_detailrecord VALUES ('7', '1', '7', '25', 'ojQ7ismR6qRR0Fp1Hukl-iK7VAEg', null);
    INSERT INTO wx_question_detailrecord VALUES ('8', '1', '8', '27', 'ojQ7ismR6qRR0Fp1Hukl-iK7VAEg', null);
    INSERT INTO wx_question_detailrecord VALUES ('9', '1', '8', '36', 'ojQ7ismR6qRR0Fp1Hukl-iK7VAEg', null);
    INSERT INTO wx_question_detailrecord VALUES ('10', '1', '8', '41', 'ojQ7ismR6qRR0Fp1Hukl-iK7VAEg', null);
    INSERT INTO wx_question_detailrecord VALUES ('11', '1', '9', '47', 'ojQ7ismR6qRR0Fp1Hukl-iK7VAEg', null);
    INSERT INTO wx_question_detailrecord VALUES ('12', '1', '10', null, 'ojQ7ismR6qRR0Fp1Hukl-iK7VAEg', '李晓明');
    INSERT INTO wx_question_detailrecord VALUES ('13', '1', '11', null, 'ojQ7ismR6qRR0Fp1Hukl-iK7VAEg', '132651xxx427');
    INSERT INTO wx_question_detailrecord VALUES ('14', '1', '12', null, 'ojQ7ismR6qRR0Fp1Hukl-iK7VAEg', '广东省广州市番禺区');
    INSERT INTO wx_question_detailrecord VALUES ('15', '1', '7', '26', 'ojQ7ishu7tV2qlwRpGNNtB7yV4z4', null);
    INSERT INTO wx_question_detailrecord VALUES ('16', '1', '8', '27', 'ojQ7ishu7tV2qlwRpGNNtB7yV4z4', null);
    INSERT INTO wx_question_detailrecord VALUES ('17', '1', '8', '31', 'ojQ7ishu7tV2qlwRpGNNtB7yV4z4', null);
    INSERT INTO wx_question_detailrecord VALUES ('18', '1', '9', '48', 'ojQ7ishu7tV2qlwRpGNNtB7yV4z4', null);
    INSERT INTO wx_question_detailrecord VALUES ('19', '1', '10', null, 'ojQ7ishu7tV2qlwRpGNNtB7yV4z4', '用处');
    INSERT INTO wx_question_detailrecord VALUES ('20', '1', '11', null, 'ojQ7ishu7tV2qlwRpGNNtB7yV4z4', '1231xx23');
    INSERT INTO wx_question_detailrecord VALUES ('21', '1', '12', null, 'ojQ7ishu7tV2qlwRpGNNtB7yV4z4', '1111111');
    INSERT INTO wx_question_detailrecord VALUES ('22', '1', '7', '25', 'ojQ7isgzDibxfF24TIfjeguaI8HA', null);
    INSERT INTO wx_question_detailrecord VALUES ('23', '1', '8', '31', 'ojQ7isgzDibxfF24TIfjeguaI8HA', null);
    INSERT INTO wx_question_detailrecord VALUES ('24', '1', '9', '48', 'ojQ7isgzDibxfF24TIfjeguaI8HA', null);
    INSERT INTO wx_question_detailrecord VALUES ('25', '1', '10', null, 'ojQ7isgzDibxfF24TIfjeguaI8HA', '凹凸曼');
    INSERT INTO wx_question_detailrecord VALUES ('26', '1', '11', null, 'ojQ7isgzDibxfF24TIfjeguaI8HA', '1888888888');
    INSERT INTO wx_question_detailrecord VALUES ('27', '1', '12', null, 'ojQ7isgzDibxfF24TIfjeguaI8HA', '');
    INSERT INTO wx_question_detailrecord VALUES ('28', '1', '7', '25', 'ojQ7istsQQMI1RBKp4HdPmk0UJEw', null);
    INSERT INTO wx_question_detailrecord VALUES ('29', '1', '8', '27', 'ojQ7istsQQMI1RBKp4HdPmk0UJEw', null);
    INSERT INTO wx_question_detailrecord VALUES ('30', '1', '9', '48', 'ojQ7istsQQMI1RBKp4HdPmk0UJEw', null);
    INSERT INTO wx_question_detailrecord VALUES ('31', '1', '10', null, 'ojQ7istsQQMI1RBKp4HdPmk0UJEw', '');
    INSERT INTO wx_question_detailrecord VALUES ('32', '1', '11', null, 'ojQ7istsQQMI1RBKp4HdPmk0UJEw', '');
    INSERT INTO wx_question_detailrecord VALUES ('33', '1', '12', null, 'ojQ7istsQQMI1RBKp4HdPmk0UJEw', '');
    INSERT INTO wx_question_detailrecord VALUES ('34', '1', '7', '25', 'ojQ7issPt_UF4tRCDQ994SV_XXAw', null);
    INSERT INTO wx_question_detailrecord VALUES ('35', '1', '8', '30', 'ojQ7issPt_UF4tRCDQ994SV_XXAw', null);
    INSERT INTO wx_question_detailrecord VALUES ('36', '1', '8', '32', 'ojQ7issPt_UF4tRCDQ994SV_XXAw', null);
    INSERT INTO wx_question_detailrecord VALUES ('37', '1', '8', '33', 'ojQ7issPt_UF4tRCDQ994SV_XXAw', null);
    INSERT INTO wx_question_detailrecord VALUES ('38', '1', '8', '42', 'ojQ7issPt_UF4tRCDQ994SV_XXAw', null);
    INSERT INTO wx_question_detailrecord VALUES ('39', '1', '9', '48', 'ojQ7issPt_UF4tRCDQ994SV_XXAw', null);
    INSERT INTO wx_question_detailrecord VALUES ('40', '1', '10', null, 'ojQ7issPt_UF4tRCDQ994SV_XXAw', '孙佳琪');
    INSERT INTO wx_question_detailrecord VALUES ('41', '1', '11', null, 'ojQ7issPt_UF4tRCDQ994SV_XXAw', '158xxx5426');
    INSERT INTO wx_question_detailrecord VALUES ('42', '1', '12', null, 'ojQ7issPt_UF4tRCDQ994SV_XXAw', '广东省广州市天河区');
    INSERT INTO wx_question_detailrecord VALUES ('43', '1', '7', '26', 'ojQ7iskcPTYAtAQpG2V2Eokxt62s', null);
    INSERT INTO wx_question_detailrecord VALUES ('44', '1', '8', '27', 'ojQ7iskcPTYAtAQpG2V2Eokxt62s', null);
    INSERT INTO wx_question_detailrecord VALUES ('45', '1', '9', '48', 'ojQ7iskcPTYAtAQpG2V2Eokxt62s', null);
    INSERT INTO wx_question_detailrecord VALUES ('46', '1', '10', null, 'ojQ7iskcPTYAtAQpG2V2Eokxt62s', '');
    INSERT INTO wx_question_detailrecord VALUES ('47', '1', '11', null, 'ojQ7iskcPTYAtAQpG2V2Eokxt62s', '');
    INSERT INTO wx_question_detailrecord VALUES ('48', '1', '12', null, 'ojQ7iskcPTYAtAQpG2V2Eokxt62s', '');
    INSERT INTO wx_question_detailrecord VALUES ('49', '1', '7', '25', 'ojQ7isuQ6X8WPon-U45Auvl_24Fc', null);
    INSERT INTO wx_question_detailrecord VALUES ('50', '1', '8', '27', 'ojQ7isuQ6X8WPon-U45Auvl_24Fc', null);
    INSERT INTO wx_question_detailrecord VALUES ('51', '1', '9', '48', 'ojQ7isuQ6X8WPon-U45Auvl_24Fc', null);
    INSERT INTO wx_question_detailrecord VALUES ('52', '1', '10', null, 'ojQ7isuQ6X8WPon-U45Auvl_24Fc', '叶亮');
    INSERT INTO wx_question_detailrecord VALUES ('53', '1', '11', null, 'ojQ7isuQ6X8WPon-U45Auvl_24Fc', '137xxx68773');
    INSERT INTO wx_question_detailrecord VALUES ('54', '1', '12', null, 'ojQ7isuQ6X8WPon-U45Auvl_24Fc', '浙江省杭州市');
    INSERT INTO wx_question_detailrecord VALUES ('55', '1', '7', '25', 'ojQ7istP53FTgRqUXxc6Ij-mfTqU', null);
    INSERT INTO wx_question_detailrecord VALUES ('56', '1', '8', '29', 'ojQ7istP53FTgRqUXxc6Ij-mfTqU', null);
    INSERT INTO wx_question_detailrecord VALUES ('57', '1', '8', '37', 'ojQ7istP53FTgRqUXxc6Ij-mfTqU', null);
    INSERT INTO wx_question_detailrecord VALUES ('58', '1', '8', '46', 'ojQ7istP53FTgRqUXxc6Ij-mfTqU', null);
    INSERT INTO wx_question_detailrecord VALUES ('59', '1', '9', '48', 'ojQ7istP53FTgRqUXxc6Ij-mfTqU', null);
    INSERT INTO wx_question_detailrecord VALUES ('60', '1', '10', null, 'ojQ7istP53FTgRqUXxc6Ij-mfTqU', '刘文杰');
    INSERT INTO wx_question_detailrecord VALUES ('61', '1', '11', null, 'ojQ7istP53FTgRqUXxc6Ij-mfTqU', '1364xxx9271');
    INSERT INTO wx_question_detailrecord VALUES ('62', '1', '12', null, 'ojQ7istP53FTgRqUXxc6Ij-mfTqU', '广东省汕头市潮南区');
    INSERT INTO wx_question_detailrecord VALUES ('63', '1', '7', '26', 'ojQ7isvChnYkR54pb5FuoxGReYsM', null);
    INSERT INTO wx_question_detailrecord VALUES ('64', '1', '8', '31', 'ojQ7isvChnYkR54pb5FuoxGReYsM', null);
    INSERT INTO wx_question_detailrecord VALUES ('65', '1', '8', '36', 'ojQ7isvChnYkR54pb5FuoxGReYsM', null);
    INSERT INTO wx_question_detailrecord VALUES ('66', '1', '8', '37', 'ojQ7isvChnYkR54pb5FuoxGReYsM', null);
    INSERT INTO wx_question_detailrecord VALUES ('67', '1', '9', '47', 'ojQ7isvChnYkR54pb5FuoxGReYsM', null);
    INSERT INTO wx_question_detailrecord VALUES ('68', '1', '10', null, 'ojQ7isvChnYkR54pb5FuoxGReYsM', '1');
    INSERT INTO wx_question_detailrecord VALUES ('69', '1', '11', null, 'ojQ7isvChnYkR54pb5FuoxGReYsM', '13213');
    INSERT INTO wx_question_detailrecord VALUES ('70', '1', '12', null, 'ojQ7isvChnYkR54pb5FuoxGReYsM', '12313');
    INSERT INTO wx_question_detailrecord VALUES ('71', '1', '7', '25', 'ojQ7isghlJk0UqRd0m8um2AwIKeQ', null);
    INSERT INTO wx_question_detailrecord VALUES ('72', '1', '8', '27', 'ojQ7isghlJk0UqRd0m8um2AwIKeQ', null);
    INSERT INTO wx_question_detailrecord VALUES ('73', '1', '8', '28', 'ojQ7isghlJk0UqRd0m8um2AwIKeQ', null);
    INSERT INTO wx_question_detailrecord VALUES ('74', '1', '9', '48', 'ojQ7isghlJk0UqRd0m8um2AwIKeQ', null);
    INSERT INTO wx_question_detailrecord VALUES ('75', '1', '10', null, 'ojQ7isghlJk0UqRd0m8um2AwIKeQ', '谢敏');
    INSERT INTO wx_question_detailrecord VALUES ('76', '1', '11', null, 'ojQ7isghlJk0UqRd0m8um2AwIKeQ', '138xxx943');
    INSERT INTO wx_question_detailrecord VALUES ('77', '1', '12', null, 'ojQ7isghlJk0UqRd0m8um2AwIKeQ', '广西南宁市青秀区');
    INSERT INTO wx_question_detailrecord VALUES ('78', '1', '7', '25', 'ojQ7ist5N5e3Eag-7KRywEZ4GbFo', null);
    INSERT INTO wx_question_detailrecord VALUES ('79', '1', '8', '27', 'ojQ7ist5N5e3Eag-7KRywEZ4GbFo', null);
    INSERT INTO wx_question_detailrecord VALUES ('80', '1', '8', '28', 'ojQ7ist5N5e3Eag-7KRywEZ4GbFo', null);
    INSERT INTO wx_question_detailrecord VALUES ('81', '1', '9', '48', 'ojQ7ist5N5e3Eag-7KRywEZ4GbFo', null);
    INSERT INTO wx_question_detailrecord VALUES ('82', '1', '10', null, 'ojQ7ist5N5e3Eag-7KRywEZ4GbFo', '周敏');
    INSERT INTO wx_question_detailrecord VALUES ('83', '1', '11', null, 'ojQ7ist5N5e3Eag-7KRywEZ4GbFo', '138cccc7122');
    INSERT INTO wx_question_detailrecord VALUES ('84', '1', '12', null, 'ojQ7ist5N5e3Eag-7KRywEZ4GbFo', '安徽省淮南市谢家集区教育局');
    INSERT INTO wx_question_detailrecord VALUES ('85', '1', '7', '25', 'ojQ7ismyeeTbLSuDhYCFZJgMLZis', null);
    INSERT INTO wx_question_detailrecord VALUES ('86', '1', '7', '25', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('87', '1', '8', '36', 'ojQ7ismyeeTbLSuDhYCFZJgMLZis', null);
    INSERT INTO wx_question_detailrecord VALUES ('88', '1', '8', '27', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('89', '1', '9', '47', 'ojQ7ismyeeTbLSuDhYCFZJgMLZis', null);
    INSERT INTO wx_question_detailrecord VALUES ('90', '1', '8', '28', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('91', '1', '10', null, 'ojQ7ismyeeTbLSuDhYCFZJgMLZis', '薛远');
    INSERT INTO wx_question_detailrecord VALUES ('92', '1', '11', null, 'ojQ7ismyeeTbLSuDhYCFZJgMLZis', '1393xxx999');
    INSERT INTO wx_question_detailrecord VALUES ('93', '1', '8', '29', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('94', '1', '12', null, 'ojQ7ismyeeTbLSuDhYCFZJgMLZis', '山西省运城市盐湖区');
    INSERT INTO wx_question_detailrecord VALUES ('95', '1', '8', '30', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('96', '1', '8', '31', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('97', '1', '8', '32', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('98', '1', '8', '33', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('99', '1', '8', '34', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);
    INSERT INTO wx_question_detailrecord VALUES ('100', '1', '8', '35', 'ojQ7ispI1h5Ekxi7qQ_5oSQdXZok', null);

    mysql
    阅读 2.5k
    2 个回答
    得票最新
    头像
    Tims
      1.9k1311

      帮你搞好，请叫我雷锋哈哈哈～～～～唔该合意噶话比个好评

      SELECT wx_question.title, wx_question_detailrecord.openid, GROUP_CONCAT( wx_question_answer.answer_name ) , wx_question_detailrecord.remark
FROM wx_question_detailrecord
LEFT JOIN wx_question ON wx_question_detailrecord.fk_question_id = wx_question.id
LEFT JOIN wx_question_answer ON wx_question_detailrecord.fk_answer_id = wx_question_answer.id
GROUP BY wx_question_detailrecord.openid, wx_question_detailrecord.fk_question_id

      //我只能做成甘样

      SELECT wx_question_detailrecord.openid, GROUP_CONCAT( wx_question_answer.answer_name ) as  value, GROUP_CONCAT(wx_question_detailrecord.remark ) as tk, 
FROM wx_question_detailrecord
LEFT JOIN wx_question ON wx_question_detailrecord.fk_question_id = wx_question.id
LEFT JOIN wx_question_answer ON wx_question_detailrecord.fk_answer_id = wx_question_answer.id
GROUP BY wx_question_detailrecord.openid
      头像
      clcx_1315
        5k2418

        没有测试数据的问题都是在耍流氓

        撰写回答
        你尚未登录，登录后可以
        • 和开发者交流问题的细节
        • 关注并接收问题和回答的更新提醒
        • 参与内容的编辑和改进，让解决方法与时俱进
        推荐问题