NodeJS - The Package of mysql respects the names of the columns on having done an INSERT INTO... SET?

Question

I am developing a Rest API using NodeJS and MySQL as the atabase. I use the standard package of npm for MySQL. I am using the following statement at the moment of insert data into DB:

INSERT INTO DATABASE.TABLE SET ?

And the JSON that I am trying to insert is:

{
     name    : "Lorem",
     surname : "Ipsum",
     email   : "lorem.ipsum@mail.com"
}

But in the database the order of columns is:

Do you know if the order of the fields matters, or does the NodeJS mysql package respect the name of the columns?

score 0 · Accepted Answer · answered Jun 05 '17 at 11:09

0

It doesn't matter.

According to the JSON spec the order of the attributes is not significant.

And as you don't have brackets arround keys (which is required for valid JSON) I suppose you're missing it with regular JavaScript object which doesn't have ordering guaranties as well.

answered Jun 05 '17 at 11:09

Glen Swift

10,962
14
43
73

Thank you for all! I will correct this, and try it. – Luisfermp Jun 05 '17 at 11:18

NodeJS - The Package of mysql respects the names of the columns on having done an INSERT INTO... SET?

1 Answers1