分类: Mysql/postgreSQL
2009-07-23 14:23:05
[root@localhost tmp]# /usr/local/mysql/bin/mysql --defaults-file=/data/txdata/test/my.cnf txtest -e "select * from pet" > mysql.out
[root@localhost tmp]# cat mysql.out
name owner kind sex birth death
buffy chen bird NULL 1997-12-09 NULL
fang james hamster f 1999-11-11 NULL
smth chen bird NULL 1997-12-09 NULL
aa chen dog m 1977-11-11 NULL
bb chen dog f 1977-11-11 NULL
cc chen cat m 1977-11-11 NULL
dd chen cat f 1977-11-11 NULL
ee chen bird m 1977-11-11 NULL
ff chen bird f 1977-11-11 NULL
gg chen nn m 1977-11-11 NULL
hh chen nn f 1977-11-11 NULL
kk chen mm m 1977-11-11 NULL
ww chen mm f 1977-11-11 NULL