How to write multi line sql query (nodejs)

In ES6 you can use template literals as they're allowed to be multi-line.

connection.query(`CREATE TABLE ${dbconfig.database}.${dbconfig.users_table} ( 
    id INT UNSIGNED NOT NULL AUTO_INCREMENT, 
    username VARCHAR(20) NOT NULL, 
    password CHAR(60) NOT NULL, 
        PRIMARY KEY (id), 
    UNIQUE INDEX id_UNIQUE (id ASC), 
    UNIQUE INDEX username_UNIQUE (username ASC) 
)`);