JDT

 

FREE Downloads
Articles
Tutorials

 

Export MySQL Data to a File



Here is some sample code that exports MySQL output to a file:

SELECT something,something_else FROM table order by something
INTO OUTFILE '/tmp/output.txt'
FIELDS TERMINATED BY ','
ENCLOSED BY ' " '
LINES TERMINATED BY '\n';







Go back to MySQL Tutorials home page

Go back to Tutorials home page



Earnings Tracker is John Dixon Technology's FREE open source accounting and bookkeeping software tool.

The software is written in PHP and MySQL and is available to use for FREE online, or as a FREE download.

Earnings Tracker is aimed at contractors and freelancers, and lets you record invoice amounts, salaries, income tax, pension contributions, employers and employees national insurance contributions, and calculates the amount of VAT and corporation /business tax due, and the size of dividends that can be taken by shareholders.

Earnings Tracker can also be used simply as a dividend, corporation tax, or VAT calculator.

free accounting software
 


JDT

Copyright Notice for John Dixon Technology Ltd

Privacy Statement

Terms & Conditions