javascript - Node.jsSqlite 3: Alternative for INSERT query syntax - Stack Overflow

admin管理员组

文章数量:1395012

For every INSERT query (normally more columns and data entries) i am using this syntax

db.run(`INSERT into table1(column1, column2, column3) VALUES(?,?,?)`,
          [data1, data2, data2], (err) => {
            if (err) {
              return console.log('Error:', err.message);
            }
          });

This is working fine but when i have 20+ columns and data, i dont want to write every single column and every data variable. This is very susceptible to errors and time consuming.

I am looking for a query like

db.run(`INSERT into table1(*) VALUES(*)`,[myArray], (err) => {
       if (err) {
         return console.log('Error:', err.message);
       }
      });

// Using "*" like in Select query
db.run(`SELECT * FROM table1`, (err) => {
       if (err) {
         return console.log('Error:', err.message);
       });

In this case each data from every column is fetched without naming each column using "*". Thanks for every hints!

本文标签： javascriptNodejsSqlite 3 Alternative for INSERT query syntaxStack Overflow