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, 6735🔥, 0💬
Popular Posts:
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Get Help Information from the Server in MySQL? While you are at the "mysql>" prompt, y...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...