Monday, 5 June 2017

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

I am developing an APiRest using NodeJS and MySQL as engine of Database. I use the standard package of npm for MySQL. I am throwing the following judgment at the moment of insert data into DB:

INSERT INTO DATABASE.TABLE SET ?

And the JSON that I try to insert is:

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

But in database the order is:

Table Database Columns

You know if the order of arrival of the fields matters, or the package of mysql of nodejs respects the name of the columns?

Thank you!



via Luis Fernando Melón Pérez

No comments:

Post a Comment