TT Queries
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
- Custom Query in SpitFire
- access queries
- How to Use MySQL Control Center
- SpitFire Predictive Pro - Latest Version Logs
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "TT Queries"
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
