Results 1 to 2 of 2
  1. #1
    Join Date
    May 2014
    Posts
    2

    Unanswered: reduce data redundence

    please reduce the data redendence becase user_id repeating
    there is any other way to reduce this data repeation
    even struture of table may change no problem
    please check attachment
    Attached Thumbnails Attached Thumbnails reducence_table.PNG  
    Last edited by satyanani40; 05-14-14 at 10:39.

  2. #2
    Join Date
    Dec 2013
    Posts
    14
    Use CONCAT_WS to reduce the redundancy
    SELECT auto_id, CONCAT_WS(',',user_id,',',subject_id) from table

    output will be
    Auto_ID User_ID Subject_ID
    1 1 1,2,3,4
    2 2 1,2,3,4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •