mysql命令行不能粘贴_将SQL粘贴到MySQL命令行中

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?

解决方案

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.