mysql2 prepared statement

I wanted to ask you which way is the best for prepared statement in mysql2

First:
try {
        const [rows] = await db.execute('SELECT * FROM account WHERE login = ?', [username]);

        if (rows.length > 0) {
          console.log("error");
          return;
        }

        const [result] = await db.execute('INSERT INTO account (login, password, discord_id) VALUES (?, ?, ?)', [username, password, interaction.user.id]);

          console.log("succesfull");
      } catch (err) {
        console.error('no DB:', err);
      }

Second:
const checkUserQuery = 'SELECT * FROM account WHERE login = ?';
const checkUserParams = [username];
      try {
        const [result] = await connection.execute(checkUserQuery, checkUserParams);

        if (result.length > 0) {
          console.log("error");
          return;
        }

        const createUserQuery = 'INSERT INTO account (login, password, discord_id) VALUES (?, ?, ?)';
        const createUserParams = [username, password, interaction.user.id];

        await connection.execute(createUserQuery, createUserParams);

        console.log("succesfull");
      } catch (err) {
        console.error('no DB:', err);
      }
    }
Was this page helpful?