FYI mysql select query get values into filepro

[Richard D. Williams]

Linux version;

fa="/tmp/MYSQL_DATA.txt"
w="mysql --user=username --password=password -N -e \"SELECT * FROM 
tablename;\" database >"<fa;
system w

Produces a tab delimited file in /tmp/MYSQL.txt.
Then use an import to get it.

-N removes the header.


---
This email has been checked for viruses by AVG.
https://www.avg.com