- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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
413 Views
Advertisements