How to make Node.Js wait for MySQL to execute?

Question

MySQL

Because Node.js, unlike PHP, is an asynchronous thing, then some difficulties arise ...

function sql_get(){
  var mysql      = require('mysql');
  var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : '',
    database : '1047750'
  });
  connection.query(
    'SELECT * FROM test',
    function(err, result, fields){
      return(result[0]);
    }
  );
  
  connection.end();
}
console.log(sql_get());

The code prints "undefined" to the console...
ATTENTION, QUESTION! How to make Node wait for a response from MySQL, and then print the value to the console?
Do not send to Google! It hasn't given me anything other than a headache...

Answer 1

And if so:

var mysql      = require('mysql');
  var connection = mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : '',
    database : '1047750'
  });
  connection.query(
    'SELECT * FROM test',
    function(err, result, fields){
      console.log(err);
      console.log(result);
    }
  );
  
  connection.end();

So you have a callback here, a function that will be called after the request is made and will accept data (result or error).

Answer 2

use async await

Answer 3

Download bible sync
https://github.com/ybogdanov/node-sync

Answer 4

The function sql_get()has no return, so "undefined".
returnin a completely different function. By the way, it is not used in any way. Instead, write a call to the action you need (for example, console.log(result);).
Forget about PHP and synchronicity. If you started writing on node.js - learn asynchrony!

Answer 5

await from ES6 sends you hello
caolan.github.io/async
better pseudo async and getting rid of callback sausage