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, 2204🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...