SpitFire Help Desk



Transfers Query

SELECT name, address, city, state, zipcode, voicephone into outfile 'c:\\transfers.txt' fields terminated by ',' lines terminated by '\r\n' FROM `clients` where dateedited between '20080721000000' and '20080721235959' and (spare16 like '1%' or spare16 like '2%') limit 1000000

Related Articles

Attachments

No attachments were found.

Visitor Comments

No visitor comments posted. Post a comment

Post Comment for "Transfers Query"

To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.

   Name:
   Email:
* Comment:
* Enter the code below:

 

Article Details

Last Updated
20th of August, 2008

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Add to favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF


User Opinions

No users have voted.

How would you rate this answer?




Thank you for rating this answer.

Continue