alterine0101’s avataralterine0101’s Twitter Archive—№ 46

  1. …in reply to @codingfess
    codingfess bisa sih; tapi memang ribet; jadi kamu harus liat daftar isi dari kuisioner pakai SELECT DISTINCT kuisioner dari table kamu; lalu define columnnya satu per satu dan responsenya via subquery, kalau mau sekalian by id_usernya;
    On twitter.com Twitter logo alterine0101’s avatar Mood 0
    1. …in reply to @alterine0101
      codingfess paling seperti ini: SELECT DISTINCT id_user, (SELECT response FROM table WHERE id_user = id_user, kuisioner = {{pertanyaan 1}}) AS {{pertanyaan 1}}, (SELECT response FROM table WHERE id_user = id_user, kuisioner = {{pertanyaan 2}}) AS {{pertanyaan 2}} FROM table;
      Permalink On twitter.com Twitter logo alterine0101’s avatar Mood 0