#   qryExportFixedWidth-mysql.sql
#   SQL to export certain tables into an ASCII, fixed-width format
#   n6lhv@arrl.net (Wayne Smith)
#   created:  28-July-2004
#   updated:  19-October-2008



#   Display the MySQL version
SELECT version();


#  Switch to the correct database
USE uls


#  export the data into fixed-width file (importable elsewhere)
#SELECT * INTO OUTFILE 'i:/uls/master/tblGeoUS-fixedwidth.txt'
#  FROM tblGeoUS;

#SELECT * INTO OUTFILE 'i:/uls/master/tblGeoStateCA-fixedwidth.txt'
#  FROM tblGeoStateCA;

#SELECT * INTO OUTFILE 'i:/uls/master/tblGeoCountiesSoCal-fixedwidth.txt'
#  FROM tblGeoCountiesSoCal;

#SELECT * INTO OUTFILE 'i:/uls/master/tblGeoCountyLosAngeles-fixedwidth.txt'
#  FROM tblGeoCountyLosAngeles;

SELECT * INTO OUTFILE 'i:/uls/master/tblOrgCityLosAngeles-fixedwidth.txt'
  FROM tblOrgCityLosAngeles;


#SELECT * INTO OUTFILE 'i:/uls/master/tblStatIQVFrequencyByCounty-fixedwidth.txt'
#  FROM tblStatIQVFrequencyByCounty;