Today, understanding the code of one site, which I need to correct, I found a request of the form INSERT table .... lack of INTO immediately rushed into my eyes, I got off. manual , yes, it’s not a required parameter, but I still didn’t find the reason why it is used. I was taught to write in kindergarten

 INSERT INTO table

But just out of curiosity, can anyone know why it?

    2 answers 2

    Then, why AS and other words that facilitate the perception.
    Insert into table sounds more harmonious and more correct than insert table.

    • You are probably right. Looked at the standard, there INTO as an obligatory parameter costs. Apparently, in MySQL they decided that reading is reading, but the extra word is not recruited not by Feng Shui and allowed to be omitted)) - aldem67

    According to the standard, INTO is an obligatory word in an INSERT statement, but some dialects do not think so, in particular, T-SQL. More than once on this came across using the generated script.

    So it is better to follow the standard in order to avoid unnecessary problems.