'Forgot to type ; at end of mysql statement, how to go back?

How do I recover from the below? I need to get back to the maria prompt, i've tried exit and quit neither work. Currently just using ctrl-c which required me to log back in to mysql.

MariaDB [(none)]> DROP DATABASE drupal_db
    ->
mysqlmariadb


Solution 1:[1]

you don't have to have the ; on the same line as your command so you can just put it on the next line by itself. If you find in some place you've made an error like dropping a single or double quote you can use \c to exit to the next line of the shell.

Solution 2:[2]

You can't. Your only option is to end the query and [Ctrl]+[C] out.

See this.

Solution 3:[3]

You can do it with \c It will move your cli to previous state

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Niagaradad
Solution 2 cctan
Solution 3 Farid Niasti

Related Questions