If you want to cancel the statement that you are composing, just enter \c mysql will cancel that and return you to a new mysql> prompt. Take an example like below:
mysql> SELECT Name, Population FROM City WHERE c
mysql>
Comments
Submitted by THROWQQQQR on Thursday, 13th November 2008 at 14:24:24