# What is the use of ‘c’ option while writing MySQL statements?

MySQLMySQLi Database

#### MySQL Database Training for Beginners

39 Lectures 5.5 hours

#### Python programming with MySQL database: from Scratch

152 Lectures 16 hours

#### Learn MySQL from scratch for Data Science and Analytics

87 Lectures 5.5 hours

‘\c’ option means ‘clear’ and is used to clear the current input. Suppose if we do not want to execute a command that we are entering, then we can use a clear \c option which clears the current input. For example, the use of \c option can be done as follows −

mysql> Select *
-> from\c

In the example above, when we use \c in a statement, MySQL clears the current input and returns back to the MySQL prompt for accepting other statements.

Updated on 22-Jun-2020 11:40:20