Why is my Query wrong and the phpMyAdmin's is not?

Question

I made a query like this:

INSERT INTO slider ('h1', 'h2', 'data-bg', 'data-img', 'data-url', 'status') VALUES ('Lalala', 'Lalala', 'http://localhost/mares.com.br-final/images/backgrounds/black_thumb.jpg', 'http://localhost/mares.com.br-final/images/banners/papeis_2015.png', 'http://lalala.com', 1)

But it's not working and phpMyAdmin says the syntax is incorrect.

So I tried adding a line through phpMyAdmin and it gave me back a query, I cleaned it, to take away some elements that I'm not inserting in my query, and tried it, and it works...

Here's the phpMyAdmin's query:

INSERT INTO slider (`data-img`, `data-bg`, `data-url`, `h1`, `h2`, `status`) VALUES ('images/lalal.jpg', 'images/back/lalala.jpg', 'http://lalal.com', 'Oi', 'Olá', '1')

Obs: I alredy tried to change ' for ` (the symbol to add code here) int he columns names.

The querys are identical to me, so why my query is wrong and phpMyAdmin's is not?

Your first query uses quotes instead of back ticks - columns and tables must have back ticks. — Jay Blanchard, Sep 28 '15 at 13:13
**Prepared statements**.. It will save you alot of trouble in the future... — Naruto, Sep 28 '15 at 13:13
I changed the quotation, but i was adding it the wrong way in phpMyAdmin. The problem was the quotation. Thanks — Rafael, Sep 28 '15 at 13:21

score 1 · Accepted Answer · edited May 23 '17 at 10:27

1

Your using single quotes for column which is wrong, instead of using single code for column use Backticks.

wrong syntax : ('h1', 'h2', 'data-bg', 'data-img', 'data-url', 'status')
right syntax : (`data-img`, `data-bg`, `data-url`, `h1`, `h2`, `status`)

for more refer the below link When to use single quotes, double quotes, and backticks in MySQL

edited May 23 '17 at 10:27

Community

1
1

answered Sep 28 '15 at 13:16

Ankur Tiwari

2,762
2
23
40

Why is my Query wrong and the phpMyAdmin's is not?

1 Answers1