Parse SQL and replace a parameter in Java

Question

I have a list of insert sql strings throw mysqldump. E.g.

INSERT INTO table (id, name) VALUES (1, 'wow');
INSERT INTO table (id, name) VALUES (2, 'yeah');

I want to import this sql to another service, and add 10 to each sql's id. I know PreparedStatement in java.sql can set parameter to sql like this:

INSERT INTO table (id, name) VALUES (？, ？);

But how to analyze an existing sql, get and replace a parameter in Java?

These SQL are generated through mysqldump. I don't have the parameters of each field. — 武子毅
– 武子毅, Commented Mar 11, 2020 at 10:15

Gordon Linoff · Accepted Answer · 2020-03-11 10:40:41Z

1

I'm not quite sure how your strings are stored, but as a string replacement, you can do:

replace(sql_strings, ", '", " + 10, '")

answered Mar 11, 2020 at 10:40

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

武子毅 Over a year ago

Thanks for your answer. My sql strings will be more complicated. Using str.replace may not work. I think I should change the way to export my data.

Collectives™ on Stack Overflow

Parse SQL and replace a parameter in Java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related