Collections:
Escape Special Characters in MySQL
How To Escape Special Characters in SQL statements in MySQL?
✍: FYIcenter.com
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:
Here are some examples of how to include special characters:
SELECT 'It''s Sunday!' FROM DUAL; It's Sunday! SELECT 'Allo, C\'est moi.' FROM DUAL; Allo, C'est moi. SELECT 'Mon\tTue\tWed\tThu\tFri' FROM DUAL; Mon Tue Wed Thu Fri
⇒ Concatenating Character Strings in MySQL
⇐ Entering Character Strings in MySQL
2018-04-12, 6622🔥, 0💬
Popular Posts:
How to obtain the version number of the ICU (International Components for Unicode) library using the...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...