What are the different MySQL prompts we have on the command line?

MySQLMySQLi Database

As we know that after writing the first line of multiple-line queries, MySQL changes the prompt. The following table shows different MySQL prompts and it's meaning −

Prompt
Meaning
         mysql>
It means MySQL is ready for a new command.
 →It means that MySQL is waiting for the next line of multiple-line command.
 ‘>
It means that MySQL is waiting for the next line, waiting for the completion of a string that began with a single quote.
 “>
It means that MySQL is waiting for the next line, waiting for the completion of a string that began with a double quote.

 `>
It means that MySQL is waiting for the next line, waiting for the completion of an identifier that began with a backtick (`).
/*>
It means that MySQL is waiting for the next line, waiting for the completion of a comment that began with /*.

It means that MySQL prompts give valuable feedback with the help of which we can be aware of what MySQL is waiting for.

raja
Published on 22-Feb-2018 05:32:31
Advertisements