express mysql2 connection.execute()의 results 값 return 하기

 

이런 식으로 하니까 
return이 될 때도 안 될 때도 있었다.

let content = '';

image.select = async (id) => {
        await connection.execute("SELECT id, content FROM img WHERE id = ?;", [id], (err, results, fields) => {
            content = results;
        });
        return content;
};

 

image.insert = async (name) => {
        return new Promise(function(resolve, reject) {
         connection.execute("INSERT INTO suggest_img (original_name, created_at, updated_at) VALUES (?, NOW(), NOW());", [name],
            (err, results, fields) => {
                resolve(results.insertId);
            });
        // return insertId;
        })
 };

 

출처 : https://stackoverflow.com/questions/31875621/how-to-properly-return-a-result-from-mysql-with-node