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, 2241🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......