MySQL's different quote marks

Question

I am a bit new to MySQL and just wanted to know what is the difference between:

`   '    "

when I'm using them in a query.

score 7 · Accepted Answer · edited Dec 27 '11 at 08:50

7

With ` you write mysql variable names. With ' you write mysql variable values

For example

SELECT * FROM `test` WHERE `x` = '1'

edited Dec 27 '11 at 08:50

nico

answered Dec 27 '11 at 08:45

Narek

Stan · Answer 2 · 2016-05-17T07:14:46.817

7

I would add that the way double quotes are interpreted depend of wether or not your MySQL server has ANSI quotes turned on or off.

In the former you cannot use double quotes as a string delimiter.

SELECT name FROM user WHERE last_name = "norris" ;

will return you a punch in your teeth.

edited May 17 '16 at 07:14

answered Dec 27 '11 at 10:05

Stan

The link is broken. A version-agnostic way seems to work. http://dev.mysql.com/doc/refman/en/sql-mode.html#sqlmode_ansi_quotes – Melebius May 17 '16 at 07:08

score 2 · Answer 3 · answered Dec 27 '11 at 08:45

2

``quotes you dont need to escape where as string quotes you do ''single or ""double

answered Dec 27 '11 at 08:45

Philip

score 2 · Answer 4 · answered Dec 27 '11 at 08:47

2

answered Dec 27 '11 at 08:47

newtover

score 1 · Answer 5 · answered Dec 27 '11 at 08:49

1

use ` (backquotes) for column name

use ' or " for values

Don't use backticks with column values. use either single or double quotes otherwise mysql considered that value as a column name.

answered Dec 27 '11 at 08:49

Pradeep Singh

5 Answers5