How To Escape Special Characters in SQL statements? | MySQL Interview Questions

There are a number of special characters that needs to be escaped (protected), if you want to include them in a character string. Here are some basic character escaping rules:
=>The escape character () needs to be escaped as (\).
=>The single quote (‘) needs to be escaped as (‘) or (“) in single-quote quoted strings.
=>The double quote () needs to be escaped as (“) or (““) in double-quote quoted strings.
=>The wild card character for a single character () needs to be escaped as (_).
=>The wild card character for multiple characters (%) needs to be escaped as (%).
=>The tab character needs to be escaped as (t).
=>The new line character needs to be escaped as (n).
=>The carriage return character needs to be escaped as (r).