无效的sql语句 - 撇号？ [重复]

Question

This question already has an answer here:

• When to use single quotes, double quotes, and backticks in MySQL 12 answers

i programm some PHP Scripts and i wrote this sql query (for example):

INSERT INTO \`table1\` (\`article\`, \`typ\`)
    VALUES(\`test\`, \`test2\`)

this query works.

my problem is that if i write the tablename and columns like this 'table1' i get an sql error: SQL Error(1064): You have an error in your SQL Syntax; check the manual that corresponds to your MariaDB server Version for the right syntax to use near ''article', 'typ') VALUES('test', 'test1')'

Does anybody know why i have to write it like this `table1` and why it doesnt work with normal --> ' ?

Server-Typ: MariaDB

Server-Version: 10.1.9-MariaDB - mariadb.org binary distribution

Server-Zeichensatz: UTF-8 Unicode (utf8)

</div>

Answer 1

This is too long for a comment. The right way to write the code is:

INSERT INTO table1(article, typ)
    VALUES ('test', 'test2')

All of the identifiers (table and column names) are valid names. They do not need to be escaped. Hence, no backticks are necessary.

You do need single quotes for quoted strings, not backticks. If the backticks are part of the name, you could just do:

INSERT INTO table1(article, typ)
    VALUES ('`test`', '`test2`');

But that seems highly unlikely.