How to get the MySQL interactive output format in batch mode also?

MySQLMySQLi Database

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    |
+------+
raja
Published on 21-Feb-2018 07:00:14
Advertisements