The MySQL client program
22 important questions on The MySQL client program
What is the default mysql statement terminator?
What is the prompt when entering the second line of a sql statement in the mysql client?
What 3 commands quit the mysql client?
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What cli parameter executes a sql command in mysql client from the shell?
What is the difference between the ; terminator and the \g terminator in mysql client?
What is the purpose of the \G terminator in mysql client?
What are the 6 prompts in the mysql client and there meaning?
-> Waiting for next line of statement
‘> Waiting for end of single-quoted string
“> Waiting for end of double-quoted string or identifier
`> Waiting for end of backtick-quoted identifier
/*> Waiting for end of C-style comment
Does the mysql client provide tab completion?
How do you execute a sql file from the mysql client prompt?
What option of mysql client prevents the program from stopping when an error occurs during execution?
What does the option --batch or -B do in mysql client?
What does the option --table or -t do in mysql client?
What does the option -r or --raw do in mysql client?
What are the 2 extra output format next to tabular and tab-delimited in mysql client?
XML --xml or -X
Name 3 commands in mysql client that are not MySQL commands?
What does the STATUS command do in mysql client?
Are the long form commands case-sensitive in mysql client? And the short forms?
Short form: Yes
Are long form commands functional on multiline statements? and short form?
Short form: Yes
What option enables long form commands in multiline statements in mysql client?
What command clears the currently entered statement in mysql client?
What does HELP contents; do in mysql client?
What does the --safe-updates option do in mysql client?
2. Output from a single SELECT is limited to 1000 rows
3. Multi-table SELECT queries are restricted to examining 1.000.000 rows for processing the query
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding