How can we discard a MySQL statement in the middle of its processing?


With the help of \c command, we can discard a MySQL statement in the middle of its processing. Consider the following example in which in the middle of the statement we want to discard it then we use \c option for it −

mysql> Select *
   -> from\c
mysql>

The above query shows that after using \c option MySQL discards the statement and returns to the prompt.

Updated on: 22-Jun-2020

44 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements