Home >Database >Mysql Tutorial >How to get MySQL interactive output format in batch mode?

How to get MySQL interactive output format in batch mode?

PHPz
PHPzforward
2023-09-09 10:17:021116browse

How to get MySQL interactive output format in batch mode?

#We can obtain the MySQL output format in batch mode with the help of the -t option. For example, after running the same query in batch mode using the –t option, we will get an interactive-like format output.

Example

C:\Program Files\MySQL\bin>mysql -u root -p gaurav < hh.sql -t
Enter password: *****

Output

+------+
| id   |
+------+
| 1    |
| 2    |
+------+

The above is the detailed content of How to get MySQL interactive output format in batch mode?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete