- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
How to get the MySQL interactive output format in batch mode also?
We can get the MySQL output format in batch mode with the help of –t option. For example, after running the same query in batch mode with –t option we will get the output like interactive format.
Example
C:\Program Files\MySQL\bin>mysql -u root -p gaurav < hh.sql -t Enter password: *****
Output
+------+ | id | +------+ | 1 | | 2 | +------+
- Related Articles
- What would be the difference between default output format when running MySQL in batch mode or interactively?
- Using MySQL in Batch Mode
- How can we run MySQL statements in batch mode?
- While running MySQL statements in batch mode, how can we print, along with output, which statements are getting executed?
- How to get process output in GridView format in PowerShell ?
- How do we use Python in interactive mode?
- How can MySQL produce the output in a vertical format rather than tabular format?
- How can we get the sorted MySQL output?
- MySQL convert timediff output to day, hour, minute, second format?
- How to batch update MySQL table?
- How to convert command output to the Hashtable format in PowerShell?
- How to do a batch insert in MySQL?
- How to change the order of one column data frame and get the output in data frame format in R?
- How to output MySQL query results in CSV format and display it on the screen, not a file?
- Change date format (in DB or output) to dd/mm/yyyy in PHP MySQL?
Advertisements