Changes between Version 16 and Version 17 of AdminTips


Ignore:
Timestamp:
2013-12-13T23:35:04Z (10 years ago)
Author:
Pan Luo
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • AdminTips

    v16 v17  
    300300select * from users where role LIKE "S";
    301301}}}
     302
     303=== Export Survey Results ===
     304{{{
     305#!sql
     306SELECT first_name, last_name, student_no, prompt, response_text INTO OUTFILE '/tmp/survey_export.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY "\\" LINES TERMINATED BY "\n" FROM
     307 survey_inputs si join users on user_id = users.id join survey_questions sq on sq.question_id = si.question_id join questions q on q.id = si.question_id WHERE event_id = EVENT_ID;
     308}}}