# CREATE command with no result

**URL:** <https://discourse.rom-rb.org/t/create-command-with-no-result/538>\
**Category:** Issues\
**Created:** [May 18, 2022, 2:43pm UTC](https://discourse.rom-rb.org/t/create-command-with-no-result/538 "2022-05-18T14:43:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![paddor](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/paddor/32/231_2.png) [@paddor](https://discourse.rom-rb.org/u/paddor)\
**Post date:** [May 18, 2022, 2:43pm UTC](https://discourse.rom-rb.org/t/create-command-with-no-result/538/1 "2022-05-18T14:43:19Z")

</div>

I want to create multiple records and I don’t want a follow-up `SELECT` to be executed.  
Is there a way to avoid the automatic `SELECT` query?

Currently doing this:

```ruby
my_relation.command(:create, result: :one).call records

```

And it still executes a `SELECT` with the IDs of ALL the new records.

---

<div class="post-metadata">

**Author:** ![solnic](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/solnic/32/279_2.png) [@solnic](https://discourse.rom-rb.org/u/solnic)\
**Post date:** [May 23, 2022, 10:31am UTC](https://discourse.rom-rb.org/t/create-command-with-no-result/538/2 "2022-05-23T10:31:36Z")

</div>

This will be supported in rom 6.0.0 + rom-sql 4.0.0.