Changes between Version 16 and Version 17 of AdminTips

Timestamp:

2013-12-13T23:35:04Z (11 years ago)

Author:

Pan Luo

Comment:

--

AdminTips

@@ -300 +300 @@
 select * from users where role LIKE "S";
 }}}
+
+=== Export Survey Results ===
+{{{
+#!sql
+SELECT 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
+ 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;
+}}}