Why not is sololearn😏?

Question

In MySQL (on xampp) columns and table name's are writing using single quote and you will get error if don't put it.

Answer 1

Hi, Noname! My English bad too) But in mysql, quotes are needed if there is a space in the column name, as in your example.

Answer 2

Professor Albus for exemple if we want to insert one column we must write:
INSERT INTO 'table name'(_,_) VALUES(_,_);

but here we could do
INSERT INTO table name(_,_) VALUES (_,_) ;
without quote

sorry if you can't understand i speak english too bad

Answer 3

Borovoi Evgenii I have seen something like that :
ALTER TABLE 'pma_bookmark' CHANGE 'id'.........

There is no space between name but there are quote

And in sololearn they don't put nothing

Answer 4

Noname MariaDB 10 is installed on my own server, and quotes are not used in the syntax there either.🤔

Answer 5

Borovoi Evgenii I don't know why are not used in MariaDB but if you try to do something with Sql without quote you'll get syntax error;

Answer 6

Sorry guys I have made a mistake
Thanks for all😔👊