wordpress中wpdb如何直接调用MySQL命令

如何利用wordpress中wpdb直接调用MySQL命令，下面web建站小编给大家简单介绍一下如query的运用方法！

举例说明：

function create_order($goods_id, $stock, $number) {
  global $wpdb;
  $wpdb->query('START TRANSACTION');

  $wpdb->insert(
    $wpdb->prefix . 'order',
    [
      'goods_id' => $goods_id,
      'number' => $number,
      'status' => 0,
      'createtime' => current_time('mysql')
    ]
  );
  
  if ($wpdb->last_error) {
    $wpdb->query('ROLLBACK');
    return;
  }
  
  $wpdb->update(
    $wpdb->prefix . 'goods',
    [
      'stock' => $stock - $number
    ],
    [
      'id' => $goods_id
    ]
  );

  if ($wpdb->last_error) {
    $wpdb->query('ROLLBACK');
    return;
  }

  $wpdb->query('COMMIT');
}