How to modify the previous command when an input error occurs in the MySQL command prompt

Current Issues

It is very frustrating to enter multiple lines of commands in the MySQL command prompt and suddenly find that there are errors at the beginning. Most people know that they can cancel the previous input by typing \c and directly return to the "mysql->" prompt. However, if there are too many inputs, it would be a pity to cancel directly, and we need to re-type the command. If we copy directly, there will be a "—>" symbol in front of each copied line, so it will take time to delete these symbols.

Solution process

​ In this case, you can enter \p, and all the content you entered previously will pop up below the command prompt window. Then select the content you want to copy (Ctrl+C), paste it (Ctrl+V) into a text box, and then copy and paste the wrong part after correcting it into the command prompt window to execute the command.

Specific steps

​ That is, enter \p → select the content to be copied (Ctrl+C) → paste it into another text box (where you can paste the changes conveniently) → copy the modified content → enter \c in the command prompt window to end the previous command first → press Ctrl+V to paste the modified content → execute the command.

Solved Case

Example: The spelling of "jion" in the fifth line is wrong and needs to be changed to "join"

After entering multiple lines of commands, it is found that the previous "jion" is misspelled. Press Enter and enter \p

Copy the content you need between the two dotted lines

select
e.ename,d.dname
from
emp e
right jion
dept d
on
e.deptno = d.deptno

Paste it anywhere else and change "jion" to "join".

Execute the command and it runs successfully

By the way, write a quick command for MySQL.

The following table lists the various prompts and briefly describes the status they represent:

This is the end of this article about how to modify the previous command when an input error occurs in the MySQL command prompt. For more information about how to modify the previous command in the MySQL command prompt, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!