Re: How to get data from mysql to .csv?

SELECT INTO OUTFILE http://www.mysql.com/doc/S/E/SELECT.html ex: SELECT a,b,a+b INTO OUTFILE "/tmp/result.text" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM test_table; also useful - LOAD DATA INFILE http://www.mysql.com/doc/L/O/LOAD_DATA.html olinux --- matthew de Jongh <matthew.de.jongh@the-spa.com> wrote: > hello. > > we are still having no luck figuring out how to do > this. > > we downloaded the code for the calendar off of > www.php.net and everything > works great except we can't get the newly approved > items to go from mysql > into the backend.csv > > we would be very appreciative if someone could > help us with this. > > matthew > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com