Thursday, 21 April 2016

Mysql query result into HTML or XML

mysql can do that for you. Use mysql -H or mysql-X.

mysql generates an HTML table from each query result set if you use the -H (or --html) option mysql creates an XML document from the result of a statement if you use the -X (or --xml) option:

mysql  db_name -H -e "select * from table_name";
mysql  db_name -X -e "select * from table_name";

2 comments:

  1. sarkari result can be only good when a candidate is good at following websites like this. Only this type of stuff presented here will help those who are appearing for the government jobs. Thanks for your efforts.

    ReplyDelete