mysql insert syntax with multiple rows

[Pierre N]

Does querydsl support multiple rows insert in one MySQL statement  ?

insert into table(name) values ('row1'),('row2');

Best,

[timowest]

For now these need to be specified via batches

SQLInsertClause clause = new SQLInsertClause(...);

clause.columns(...).values(...).addBatch();

clause.columns(...).values(...).addBatch();

clause.execute();

Timo

[Pierre N]

it's not the same, your suggestion will do multiple batched insert query, while the one I suggest is a single query, doing multiple insert at a time. It's a mysql specific feature, it's really faster than batched insert.

        QAlert t_alert = QAlert.alert;
        try(Connection con = ds.getConnection()){
            SQLInsertClause clause = new SQLInsertClause(con, conf, t_alert);
            clause.columns(t_alert.city).values("city1").addBatch();
            clause.columns(t_alert.city).values("city2").addBatch();
            clause.execute();
        }catch(Exception ex){
        }

Generated queries : 

insert into `alert` (`city`) values ('city1');
insert into `alert` (`city`) values ('city2');