mySQL will only let me use backticks (not single or double quotes)

Krause · 2010-10-16 10:17:18

What the hell is going on here? This worked fine until a recent update.

SELECT * FROM "table";
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"table"' at line 1

 SELECT * FROM 'table';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''table'' at line 1

SELECT * FROM `table`;
(table prints normally here)

12 rows in set (0.00 sec)

The error happens both in the mysql client, phpmyadmin, and all my php scripts. How do I make it accept single and double quotes?

Phpmyadmin has this to say about the mySQL installation

Server: Localhost via UNIX socket
Server version: 5.1.50
Protocol version: 10
User: root@localhost
MySQL charset:                    UTF-8 Unicode            (utf8)

Last edited by Krause (2010-10-16 10:18:16)

xvello · 2010-10-16 11:23:24

Hello

In the SQL Standard, table and column names don't have to be between quotes, only values can be (for instance if you have spaces in a value).
Just call "SELECT * FROM table;", that's all.

Krause · 2010-10-16 14:00:21

But what if the table name has a space in it?

jt512 · 2010-10-16 17:27:57

Krause wrote:

But what if the table name has a space in it?

Use backticks?

Jay

Carlwill · 2010-10-18 21:36:05

MySQL is notorious for not following SQL standards. Single quotes are only acceptable and if you have spaces, use back tics.

Arch Linux

#1 2010-10-16 10:17:18

mySQL will only let me use backticks (not single or double quotes)

#2 2010-10-16 11:23:24

Re: mySQL will only let me use backticks (not single or double quotes)

#3 2010-10-16 14:00:21

Re: mySQL will only let me use backticks (not single or double quotes)

#4 2010-10-16 17:27:57

Re: mySQL will only let me use backticks (not single or double quotes)

#5 2010-10-18 21:36:05

Re: mySQL will only let me use backticks (not single or double quotes)

Board footer