Skip to content

mysql: support for insert of multiple rows #2002

Closed as not planned
Closed as not planned
mysql: support for insert of multiple rows#2002
Labels
bugSomething isn't workingtriageNew issues that hasn't been reviewed

Description

@newhook
newhook
opened on Dec 20, 2022

Version

1.15.0

What happened?

Is there a way to insert multiple rows into a MySQL database?

ie: the equivalent of:

insert into foo(bar1, bar2, bar3)
values
  (?,?,?),
  (?,?,?),
  (?,?,?)

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

No response

Playground URL

No response

What operating system are you using?

No response

What database engines are you using?

No response

What type of code are you generating?

No response

Activity

  1. newhook
    added
    bugSomething isn't working
    triageNew issues that hasn't been reviewed
    on Dec 20, 2022

  2. croconut commented on Dec 21, 2022

    @croconut
    croconut
    on Dec 21, 2022

    for an arbitrarily sized array, the mysql query would look like:

    insert into table_1
(col_1, col_2)
values
?;

    and the query parameter passed to mysql would look like:

    ('string', 15), ('second', 16), ('last', 35)

  3. kyleconroy commented on Feb 22, 2023

    @kyleconroy
    kyleconroy
    on Feb 22, 2023
    Collaborator

    There currently isn't a way to do this for an unknown number of rows. Duplicate of #695

  4. kyleconroy
    closed this as not plannedon Feb 22, 2023

  5. croconut commented on Feb 23, 2023

    @croconut
    croconut
    on Feb 23, 2023

    Thats too bad as its definitely doable, e.g. npm's mysql package (and why mysql doesn't already support arrays, I don't understand).

  6. aakarim commented on Jul 9, 2024

    @aakarim
    aakarim
    on Jul 9, 2024

    It looks like #695 is now closed, are there any examples of this working with an INSERT statement?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingtriageNew issues that hasn't been reviewed

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions