1.以html格式输出结果使用mysql客户端的参数–html或者-T,则所有SQL的查询结果会自动生成为html的table代码$ mysql -u root --htmlWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3286Server version: 5.1.24-rc-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> select * from test.test;
i |
---|
1 |
2 |