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

MySQLMySQLi Database

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.

raja
Published on 22-Feb-2018 11:33:23
Advertisements