Insrtuctons for MySQL Sorting
For sorting the Touch Tone 9 into a text file that saves in Folder "Touch Tone 9" on the C drive: SELECT voicephone into outfile 'C:/Touch Tone 9/temp.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' FROM `clients` where spare16 like '9%' limit 1000000 For sorting the Touch Tone 8 into a text file that saves in Folder "Touch Tone 8" on the C drive: SELECT voicephone into outfile 'C:/Touch Tone 8/temp.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' FROM `clients` where spare16 like '8%' limit 1000000 For sorting the Dial Result into a text file that saves in Folder "Dial Result 201" on the C drive: SELECT voicephone into outfile 'C:/Dial Result 201/temp.txt' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' FROM `clients` where DialResult='201' limit 1000000 For deleting records where the touch tone is 9: delete from clients where spare16 like '9%' For deleting records where the touch tone is 8: delete from clients where spare16 like '8%' For deleting records where the Dial Result is 201: delete from clients where DialResult='201'Related Articles
- MySQL Server won't start.
- Deleting Lists in SpitFire Pro (MySQL Version)
- Names Not Showing on SpitFire Agent Software
- Importing a national DNC file with ListMaker Pro (MySQL) version of SpitFire.
- How to manually put a person’s number into the nocalls list. Pro version.
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "Insrtuctons for MySQL Sorting"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.Article Details
Last Updated
20th of August, 2008
