View Single Post
  #2  
Old 07-12-2007, 03:16 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 385
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: Escape Character in MySql

Hi,

Escape Character,Yes available in MYSQL as same as Oracle.

Here are some examples.

1. SELECT "Its \n really \n working";

This will list the values as every character in new line

Output:

Its
really
working


2. SELECT "P.R & Sons";
Will List the Value with the Ambersent

3. SELECT "This is Mayor's Book";
Will List the Value with the single quote.
__________________
-Murali..
Reply With Quote