Question about the comma delimiter used to export CSV files from SQL statements

For SQL export CSV files, the comma delimiter is generally set to ",", but many of the contents in the database contain commas. how can this problem be solved?

Reply to discussion (solution)

This statement also reports an error. $ rs ['group _ concat (concat_ws ('X', 'sku ', 'quantity-purchased, it should be the 'X' problem. what should I do?

echo $rs['ship-postal-code'].",".$address.",".$rs['recipient-name'].",".$rs['ship-city'].",".$rs['ship-state'].",".$rs['buyer-phone-number'].",".$rs['group_concat( concat_ws(' X ', `sku` , `quantity-purchased` ) )']."\r\n";

CSV files are generally separated by commas (,). However, many contents in the database contain commas (,). how can this problem be solved? According to the format of the CSV file, when the content contains a comma, the content should be enclosed in double quotation marks. when the content contains double quotation marks, the double quotation marks should be changed to two double quotation marks, of course, the entire content is enclosed in double quotation marks.
Generally, the content of the character type should be placed in double quotation marks.
In addition, fgetcsv after php5.3 cannot recognize Chinese characters not in double quotation marks

This statement also reports an error. $ rs ['group _ concat (concat_ws ('X', 'sku ', 'quantity-purchased, it should be the 'X' problem. what should I do?

PHP code

Echo $ rs ['ship-postal-Code']. ",". $ address. ",". $ rs ['recipient-name']. ",". $ rs ['s ......
$ Rs ['group _ concat (concat_ws ('X', 'sku ', 'quantity-purchased')']
It's strange that there are single quotes in single quotes without errors.

Xuzuning is large,

I. Is this problematic statement an escape character or a double quotation mark?

II. This statement writes the database content to a CSV file. what should I do ??

3. The txt file is exported from linen. Which of the following is not prone to the problem caused by separators in CSV and TXT files ??

The standard csv is like this.
"Abcd", "a", 123
The values of the three columns are abcd, a ", and 123.

Double quotation marks can be omitted in case of no ambiguity.
Aaa, bb, cccc

However
Aaa, Chinese character, 123
In this way, php5.3 can only read the content in columns 1 and 3, and the 2nd column is empty.

It doesn't matter what tool you use to notice these facts.
Since a tool becomes a tool, it naturally has its merits.

$ Rs ['group _ concat (concat_ws ('X', 'sku ', 'quantity-purchased')']

How should I change this statement ?? I cannot read any data.

$ Rs ["group_concat (concat_ws ('X', 'sku ', 'quantity-purchased')"]

When exporting files, you can select "column separator (C)" at the bottom. you can select "tab separator". however, pay attention ", when the "symbol" is displayed, the separator is invalid.