import Tabs from '@theme/Tabs'; import TabItem from '@theme/TabItem'; import { FAQ } from '@site/src/components/FAQ'; import { ExternalCodeEmbed } from '@site/src/components/ExternalCodeEmbed';

UPDATE

The examples below also work for the execute method.

query(sql)

query(sql: string)

try {
  const sql = 'UPDATE `users` SET `age` = 20 WHERE `name` = "Josh" LIMIT 1';

  // highlight-next-line
  const [result, fields] = await connection.query(sql);

  console.log(result);
  console.log(fields);
} catch (err) {
  console.log(err);
}

</TabItem> <TabItem value='callback.js'>

const sql = 'UPDATE `users` SET `age` = 20 WHERE `name` = "Josh" LIMIT 1';

connection.query(sql, (err, result, fields) => {
  if (err instanceof Error) {
    console.log(err);
    return;
  }

  console.log(result);
  console.log(fields);
});

</TabItem> </Tabs>

result: contains a ResultSetHeader object, which provides details about the operation executed by the server.
fields contains extra meta data about the operation, if available

:::info The connection used for the query (.query()) can be obtained through the createConnection, createPool or createPoolCluster methods. :::

<hr />

query(options)

query(options: QueryOptions)

try {
  const sql = 'UPDATE `users` SET `age` = 20 WHERE `name` = "Josh" LIMIT 1';

  // highlight-start
  const [result, fields] = await connection.query({
    sql,
    // ... other options
  });
  // highlight-end

  console.log(result);
  console.log(fields);
} catch (err) {
  console.log(err);
}

</TabItem> <TabItem value='callback.js'>

const sql = 'UPDATE `users` SET `age` = 20 WHERE `name` = "Josh" LIMIT 1';

connection.query(
  {
    sql,
    // ... other options
  },
  (err, result, fields) => {
    if (err instanceof Error) {
      console.log(err);
      return;
    }

    console.log(result);
    console.log(fields);
  }
);

</TabItem> </Tabs>

result: contains a ResultSetHeader object, which provides details about the operation executed by the server.
fields contains extra meta data about the operation, if available

:::info The connection used for the query (.query()) can be obtained through the createConnection, createPool or createPoolCluster methods. :::

<hr />

Glossary

ResultSetHeader

QueryOptions