How to insert " and ' in one sentence of sql at the same time?

[limeng32]

We know that single quotation marks (') can be inserted in double quotation marks, and double quotation marks (") can be inserted in single quotation marks. However, if an indicator has both single quotation marks (') and double quotation marks (") in the same time, how to insert it?

[Alima777]

Can you give one example?

[limeng32]

I can Use:
insert into root.ln.wf01.wt01 (timestamp,asd) values(now()," ' ");
To add a single quote record, I can also use:
insert into root.ln.wf01.wt01 (timestamp,asd) values(now(),' " ');
To add a double quote record, but I can’t add a record with both single quotes and double quotes, because there is no escape mechanism;

[jixuan1989]

Now you can use "" as the escape char, but the "" will not be removed from the values...

[limeng32]

I think you mean "\", but in this rich-editor you must write '\\' to display '\'.
How about use two single quotation marks '' to escape one single quotation mark ' , just like mysql?