alterine0101’s avataralterine0101’s Twitter Archive—№ 47

    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;
      Permalink 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;
    On twitter.com Twitter logo alterine0101’s avatar Mood 0