linux执行脚本 excec,shell_excec（）不返回格式化的MySQL结果

如果从mysql命令输出管道到另一个cmd ie。您的应用程序mysql客户端会剥离此信息，您可以使用-t选项打开它。

样品

正常输出

$ mysql -uroot -e "select * from l.user_art"

+----+---------+--------+

| id | user_id | art_id |

+----+---------+--------+

| 1 | 10 | 10 |

| 2 | 20 | 30 |

| 3 | 20 | 80 |

| 4 | 10 | 90 |

| 5 | 20 | 10 |

| 6 | 23 | 10 |

| 7 | 23 | 11 |

| 8 | 23 | 12 |

| 9 | 10 | 11 |

+----+---------+--------+

输出在其他CMD(猫)管道

$ mysql -uroot -e "select * from l.user_art" | cat

id user_id art_id

1 10 10

2 20 30

3 20 80

4 10 90

5 20 10

6 23 10

7 23 11

8 23 12

9 10 11

管道输出与选择启用-t

$ mysql -uroot -t -e "select * from l.user_art" | cat

+----+---------+--------+

| id | user_id | art_id |

+----+---------+--------+

| 1 | 10 | 10 |

| 2 | 20 | 30 |

| 3 | 20 | 80 |

| 4 | 10 | 90 |

| 5 | 20 | 10 |

| 6 | 23 | 10 |

| 7 | 23 | 11 |

| 8 | 23 | 12 |

| 9 | 10 | 11 |

+----+---------+--------+