# insert bulk records

**URL:** <https://forum.kx.com/t/insert-bulk-records/6144>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [July 13, 2009, 8:10pm UTC](https://forum.kx.com/t/insert-bulk-records/6144 "2009-07-13T20:10:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Iris2](https://avatars.discourse-cdn.com/v4/letter/i/e47774/32.png) [@Iris2](https://forum.kx.com/u/Iris2)\
**Post date:** [July 13, 2009, 8:10pm UTC](https://forum.kx.com/t/insert-bulk-records/6144/1 "2009-07-13T20:10:00Z")

</div>

When I try to insert table A into table ttable A is the select result from a table:table t is an self-defined tablet:( sym:(); exp\_month:(),strike\_code:();strike:();exp\_year:();size:();ex\_time:();ex:();trigger:());table A and table B have the same columns`t insert AI meet the error:Possibly this error refers to columns that can’t be aligned for R,R orK,Kany hints for that?? thanks!

---

<div class="post-metadata">

**Author:** ![Lindqvist](https://avatars.discourse-cdn.com/v4/letter/l/b4bc9f/32.png) [@Lindqvist](https://forum.kx.com/u/Lindqvist)\
**Post date:** [July 14, 2009, 1:06pm UTC](https://forum.kx.com/t/insert-bulk-records/6144/2 "2009-07-14T13:06:00Z")

</div>

I noticed an error in the declaration of t:"exp\_month:(),strike\_code:();"Note that the column names are seperated by , (comma) and not ;(semicolon).That would result in a table which has no strick\_code column. You canverify this by issuing “meta t”.I also suggest that when lookin at strange errors: Get the meta of thetables you try to operate over to verify that types and column namescan associate as expected.On 13 Juli, 21:10, Iris \<fanny…\> wrote:\> When I try to insert table A into table t\>\> table A is the select result from a table:\>\> table t is an self-defined table\>\> t:( sym:(); exp\_month:(),strike\_code:();strike:();exp\_year:();size:\> ();ex\_time:();ex:();trigger:());\>\> table A and table B have the same columns\>\> `t insert A\>\> I meet the error:\> Possibly this error refers to columns that can’t be aligned for R,R or\> K,K\>\> any hints for that?? thanks!\</fanny…\>

---

<div class="post-metadata">

**Author:** ![Iris2](https://avatars.discourse-cdn.com/v4/letter/i/e47774/32.png) [@Iris2](https://forum.kx.com/u/Iris2)\
**Post date:** [July 14, 2009, 8:23pm UTC](https://forum.kx.com/t/insert-bulk-records/6144/3 "2009-07-14T20:23:00Z")

</div>

Thanks:)On Jul 14, 7:06 am, H?kan \<lindqvist.h…\> wrote:\> I noticed an error in the declaration of t:\>\> “exp\_month:(),strike\_code:();”\>\> Note that the column names are seperated by , (comma) and not ;\> (semicolon).\> That would result in a table which has no strick\_code column. You can\> verify this by issuing “meta t”.\>\> I also suggest that when lookin at strange errors: Get the meta of the\> tables you try to operate over to verify that types and column names\> can associate as expected.\>\> On 13 Juli, 21:10, Iris \<fanny…\> wrote:\>\> \> When I try to insert table A into table t\>\> \> table A is the select result from a table:\>\> \> table t is an self-defined table\>\> \> t:( sym:(); exp\_month:(),strike\_code:();strike:();exp\_year:();size:\> \> ();ex\_time:();ex:();trigger:());\>\> \> table A and table B have the same columns\>\> \> `t insert A\>\> \> I meet the error:\> \> Possibly this error refers to columns that can’t be aligned for R,R or\> \> K,K\>\> \> any hints for that?? thanks!\</fanny…\>\</lindqvist.h…\>