Select ... INTO fn gets 1000 return code from MySQL 5.x

[bmcswain]

Let me say "Thank You" again for all that responded and even those that thought about responding.

The power of this medium is the collection of us out here. We can help each of us to move forward.

I have finished my project. The data is refined and purified and usable by anyone with a spreadsheet.

Thanks!
Bob
_________________
Bob

[Sliderule]

Bob:

Just FYI ( For Your Information ) and for anyone else reading this . . . another method to create a CSV ( Comma Separated Value ) file from the contents of a Base table is:

1. Open your OpenOffice Base database file
   
2. From the Menu: Tools -> SQL...
   
3. In the Command to execute box, enter your SQL with one change . . . add a line BEFORE the "FROM clause"
   
   INTO TEXT "precinct_ 69_2007-02-23"
   
   so that the 'output' will be placed in the named file with a CSV extension, in the same directory as your ODB file . . . in this case file name . . . precinct_69_2007-02-23.csv
   

   Code:

   SELECT DISTINCT       "Name: Last,First,Middle",       "Res Addr: Full",       "Res Addr: City,State,Zip"    INTO TEXT "precinct_69_2007-02-23"    FROM "Precinct 69"

   
   
4. Press Execute button
   
5. Press Close button
   

I hope this helps . . . and . . . best of success.

Sliderule

[bmcswain]

OK... Just to finish the thread...

My last task was to split the house number from the street name.

Way simple ... compared to the previous step.

Download CSVed and it's done.

Under one of the split techniques, you can split at a certain character. Since house numbers can be 2, 3, 4 or 5+ numbers, CSVed allows you to split it following the " " (blank) after the number.

Simple.

But not if you had not helped me.

Thanks to the online community.
_________________
Bob