# AQL Syntax: Insert multiple records

**URL:** <https://discuss.aerospike.com/t/aql-syntax-insert-multiple-records/6498>\
**Category:** AQL\
**Created:** [July 22, 2019, 3:55pm UTC](https://discuss.aerospike.com/t/aql-syntax-insert-multiple-records/6498 "2019-07-22T15:55:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![arthur.putnam](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/arthur.putnam/32/1234_2.png) [@arthur.putnam](https://discuss.aerospike.com/u/arthur.putnam)\
**Post date:** [July 22, 2019, 3:55pm UTC](https://discuss.aerospike.com/t/aql-syntax-insert-multiple-records/6498/1 "2019-07-22T15:55:03Z")

</div>

I am trying to find the proper syntax for inserting multiple records via aql. I have found this to be helpful: [AQL | Aerospike Documentation](https://www.aerospike.com/docs/tools/aql) but I am having trouble finding the proper syntax for inserting multiple rows. Here is what I have tried:

` INSERT INTO test.myset (PK, name1, name2) VALUES (1, 'test1', 'test2'), (2, 'test3', 'test4');`

Is it possible to insert multiple rows with one aql statement?

---

<div class="post-metadata">

**Author:** ![Albot](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/albot/32/2076_2.png) [@Albot](https://discuss.aerospike.com/u/Albot)\
**Post date:** [July 23, 2019, 1:16am UTC](https://discuss.aerospike.com/t/aql-syntax-insert-multiple-records/6498/2 "2019-07-23T01:16:08Z")

</div>

By rows you mean records? No

---

<div class="post-metadata">

**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/system/32/2274_2.png) [@system](https://discuss.aerospike.com/u/system)\
**Post date:** [July 29, 2019, 1:16am UTC](https://discuss.aerospike.com/t/aql-syntax-insert-multiple-records/6498/3 "2019-07-29T01:16:10Z")

</div>

This topic was automatically closed 6 days after the last reply. New replies are no longer allowed.