.query returns empty data

[kefyru]

simply query 'SELECT * FROM tablename' returns empty data.

... const mysql = require('mysql2'); const connection = mysql.createConnection(MYSQL_CONFIG); connection.query('SELECT * FROM registration', (e, d, f) => { console.log(e); // null console.log(d); // [] (empty array) console.log(f); // [ColumnDefinition {...}, ColumnDefinition {...},...] (correct fields information)

});

...

There are some rows in this table and the same query in WebStorm SQL console returns them correctly. But node just returns correct field information and empty data... What am i doing wrong?

[kefyru]

Oh... It was uncomitted transaction ))