Posted by Alexander Chelidze on 09/27/21 11:40

SELECT ... INTO OUTFILE 'filename'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM table_name;

This way will be correct.

• Prev in thread: Re: AW: [PHP] export mysql to csv prob
• Next in forum: Re: annoying problem!
• Prev in forum: Re: GD Install - Apache, Win XP
• Thread view: AW: [PHP] export mysql to csv prob

[Reply to this message]