Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Selected Reading
What are the different MySQL prompts we have on the command line?
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.
Updated on: 2020-06-22T10:57:40+05:30
469 Views
Advertisements