When to use escape VS escapeId? about sqlstring HOT 5 CLOSED

You would use escape for values and escapeId for identifiers.

from sqlstring.

I think that fundamentally makes sense, but I am struggling to differentiate between the two. To me they are slightly ambiguous terms.

from sqlstring.

I believe it's the terms used by MySQL in the manual and their syntax trees. What are the terms you are seeing in the MySQL server documentation? I may be able to help translate or figure out if there are different terms that should be used, but just don't have enough information to understand why they don't make sense yet.

from sqlstring.

Here is the main doc section regarding the SQL language in MySQL if that helps: https://dev.mysql.com/doc/refman/5.7/en/language-structure.html

from sqlstring.

Oh, this terminology ties directly to MySQL queries! Now it's obvious. I guess I was thinking too much about my application's data and not about what constitutes a SQL query.

Thanks! 👍

from sqlstring.