Pasting SQL into the MySQL command line
mysql
Solution
Perhaps you could save the statement to a text file `myTest.sql`, then use the MySQL command `source myTest.sql` to run it? You could then tweak the SQL in the file, save the changes, and run it again.
Problem
I have an application that is defining some SQL code: ``` mySql = "SELECT sq.question, qs.title, sq.id as question_id, sq.type, qs.id as option_id, sri.title as rankTitle, sri.id as rankId, sfi.title as formTitle, sfi.id as formId, sq.sub_type, sq.sort_order FROM survey_questions as sq LEFT JOIN question_suboptions as qs ON sq.id = qs.question_id LEFT JOIN survey_rankingitems as sri ON sq.id = sri.question_id LEFT JOIN survey_formitems as sfi ON sq.id = sfi.question_id WHERE sq.survey_id = #{@surveyId} ORDER BY sq.sort_order" ``` I would like to paste this code (everything between the double quotes) in the MySQL command line, change the one parameter and execute it, but I have run into an issue where for every line above MySQL will display: Display all 1450 possibilities? (y or n) And then 1450 different available commands. If I remove all linebreaks and tabs then I can paste in, but that is time consuming and a pain. Is there a way that I can simply paste in the above code, edit it and then execute it as a single unit?