代码如下 ：

获取资料并修改状态为status为1

备注 定义了 id的名称对应Data_ID

const mysql = require('mysql2');

const connection = mysql.createPool({

   connectionLimit: 30,

   host: "127.0.0.1",

   port: "3306",

   user: "root",

   database: "data",

   password: "root"

});

let ID = await(new Promise((resolve, reject) => {

   connection.query(

       'SELECT  Data_ID ,First_Name ,Last_Name ,Email ,Phone ,Address ,City ,State ,Zip ,YY ,MM ,DD ,Mobile ,Rent_or_Own ,Employer ,Job_Title ,Work_Phone ,Pay_Frequency ,Monthly_Income ,SSN ,License_No ,License_State ,Bank_Name ,Bank_Account ,Routing_No ,Loan_Amount ,status FROM us_data   WHERE status IN (0) ORDER BY Data_ID LIMIT 1;',

       function (err, results, fields) {

           if (err) {

               reject('Database connection error: ' + err)

               return

           }

     [[VARIABLE_BAS]] = results

     console.log(results);

     [[Data_ID]] = results[0].Data_ID

     console.log( results[0].Data_ID)

     resolve(results)

   //   resolve()

       }

   );

}));

let sqlStatus = 'UPDATE us_data SET status=1 WHERE Data_ID= ' + ID[0].Data_ID+';'

console.log(sqlStatus)

if(!sqlStatus ) return  

console.log("ID:",sqlStatus);

await(new Promise((resolve, reject) => {

 connection.query(

   sqlStatus,

   function (err, results, fields) {

       console.log(results);

     if (err) {

       reject('Database connection error: ' + err)

       return

     }

     resolve()

   }

 );

}));