Export MySQL data into csv file

April 6th, 2011 von sdohn

SELECT cal_date,cal_name,cal_description
    INTO OUTFILE '/tmp/export.csv'
    FIELDS
            TERMINATED BY ';'
            OPTIONALLY ENCLOSED BY '"'
    from webcalendar.webcal_entry
where cal_create_by='sdohn' AND cal_date between '20090330' AND '20090331';