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, 2275🔥, 0💬
Popular Posts:
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...