- Trending Categories
- Data Structure
- Operating System
- C Programming
- 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 would be the difference between default output format when running MySQL in batch mode or interactively?
152 Lectures 16 hours
87 Lectures 5.5 hours
The default MySQL output would be different if we will run the same query interactively or in batch mode. For example, if we will run the query select * from hh interactively then following would be a format of output −
mysql> select * from hh; +------+ | id | +------+ | 1 | | 2 | +------+ 2 rows in set (0.01 sec)
On the other hand, if we will run the same query in batch mode then following would be the format of output −
C:\Program Files\MySQL\bin>mysql -u root -p gaurav < hh.sql Enter password: ***** id 1 2
- How to get the MySQL interactive output format in batch mode also?
- Using MySQL in Batch Mode
- While running MySQL statements in batch mode, how can we print, along with output, which statements are getting executed?
- What is MySQL STRCMP() function and what would be the output of this function?
- What would be the default return type of MySQL IFNULL() control flow operator?
- How can we run MySQL statements in batch mode?
- What would be the effect on the output of MySQL LAST_INSERT_ID() function in the case on multiple-row insert?
- What would be the output if we use a NULL value in an arithmetic expression?
- What would be a query to remove from the text in MySQL?
- What would be the result on concatenating server_id and UUID in MySQL?
- What would be the output of MySQL ELT() function if the index number, provided as an argument, is not an integer?
- Difference between Memory Address Mode and Register Address Mode.
- What would be the output of MySQL SUM() function if a column having no values has been passed as its argument?
- What would be the effect on summary output when I use explicit sort order (ASC or DESC) with column names in the GROUP BY list along with “WITH ROLLUP” modifier?
- Change date format (in DB or output) to dd/mm/yyyy in PHP MySQL?