Home >Database >Mysql Tutorial >Print structured MySQL SELECT at command prompt

Print structured MySQL SELECT at command prompt

WBOY
WBOYforward
2023-09-04 13:41:011171browse

To print, the syntax is as follows -

mysql -uroot -t -e "your Select Query  " -p

To achieve the above syntax, let us open the command prompt -

在命令提示符处打印结构化 MySQL SELECT

Now, reach the MySQL bin -

在命令提示符处打印结构化 MySQL SELECT

Let us implement the above syntax to easily print structured SQL selections. Following is the query -

在命令提示符处打印结构化 MySQL SELECT

# which will produce the following output -

在命令提示符处打印结构化 MySQL SELECT

在命令提示符处打印结构化 MySQL SELECT

The above is the detailed content of Print structured MySQL SELECT at command prompt. 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