Unifix knowledge database - The original one

Dashboard - News - Search - List - About - Admin


Extract a mysql query to XML

Author:black - Fri May 4 01:18:45 2007

echo "select * from table" | mysql -B --xml -h [host] -u [user] -p[password] [database] > output.xml

not all of the parameters are needed of course.

use --table if you want the nice ascii tables around the result
if -B is given and neigther --xml nor --table are given, the output is tabbed out.
Copyright(c) Unifix.org 2002-2011


Dashboard - News - Search - List - About - Admin
 
Powered by Mikjaer Consulting Solutions - Hosted by Specialhosting.dk