phpmyadmin sql apostrophe not working

Question

hey guys was hoping you could help me out,

Not sure if I always had this problem or if its new, in phpmyadmin in the sql tab, the apostrophe it recognizes is different from what i type, for example,

when i type, it is

SELECT * FROM 'table'

this gives me an error, so instead I have to like copy/paste the inverted commas of some prebuilt query so that it looks like

SELECT * FROM `table`

see how the apostrophes are different? any way I can fix this?

also, i have seen many queries on the web, and i think even queries i call from php dont require table names to have apostrophes. But when write it in phpmyadmin, I can do queries without table names having apostrophes?

thanks in advance.

I don't understand why many people keep table name as TABLE?? — Fahim Parkar, Jun 22 '12 at 12:17
@islandmyth There's such a thing as different keyboard layouts. ;-) — Gnarfoz, Jun 22 '12 at 12:17
Also see http://stackoverflow.com/questions/1275127/character-for-single-quote — simbabque, Jun 22 '12 at 12:33

score 6 · Accepted Answer · answered Jun 22 '12 at 12:19

6

In MYSQL, table is a reserved keyword. If you want to use reserved keywords in mysql in query, you have to enclose them in backtick(`).

As table is reserved keyword you query should be

SELECT * FROM `table`

Regarding single quote ('), in mysql, it represents string value.

SELECT *, 'table' FROM `table`;

Demo

answered Jun 22 '12 at 12:19

Fahim Parkar

30,974
45
160
276

1

+1 for demo in sqlfiddle – bart s Jun 22 '12 at 12:43
@barts : sqlfiddle is my best friend these days. I never test any mysql query on my PC machine. And its good to give demo on what we write so that OP and especially others can see how output is coming with respective query... – Fahim Parkar Jun 22 '12 at 12:56
I didn't know this one up to now. I only new jsfiddle, but its good to know as I am soon into a php/mysql project... – bart s Jun 22 '12 at 12:58
thanks, was literally going mad over this for more than an hour :/.... – Ahmed-Anas Jun 22 '12 at 14:13
not a problem. happy to help... – Fahim Parkar Jun 22 '12 at 14:29

Gnarfoz · Answer 2 · 2012-06-22T17:34:05.577

2

You should only need to quote table names when they conflict with a reserved word.

Also:

` = Grave accent, or (because someone needed to invent a word) backtick
' = Apostrophe, or straight single quote

edited Jun 22 '12 at 17:34

answered Jun 22 '12 at 12:16

Gnarfoz

3,146
1
17
15

score 1 · Answer 3 · answered Jun 22 '12 at 12:14

1

You dont need apostrophe on table name.

answered Jun 22 '12 at 12:14

Kristijan

323
6
11

score 1 · Answer 4 · answered Jun 22 '12 at 12:23

1

You should use ` in cases that your table/field name is a reserve word eg:

SELECT `distinct`, myfields FROM mytable

note that distinct is an sql command so you need to put the `.

SELECT * FROM `table`

table here should be inside `.

answered Jun 22 '12 at 12:23

Bob

1,489
1
16
28

score 0 · Answer 5 · answered Jun 22 '12 at 12:15

0

There are two different characters, the backtick and the single quote. Table and column names can be surrounded by the backtick, strings can be surrounded by quotes. There is nothign to fix :D

answered Jun 22 '12 at 12:15

Nanne

64,065
16
119
163

phpmyadmin sql apostrophe not working

5 Answers5

Demo

Linked