Create new table in SQLite with query result

Question

I have this code in Java and i need to insert the result into new table. Is this possible with just editing this query?

  ResultSet result = stat.executeQuery("SELECT artist, COUNT(artist) AS countartist FROM table1 GROUP BY artist ORDER BY countartist DESC;");

You can do that or use create table tab_name as select artist ... — juergen d
– juergen d, Commented Nov 12, 2016 at 17:28

swmcdonnell · Accepted Answer · 2016-11-16 06:23:24Z

1

Try this:

ResultSet result = stat.executeUpdate("CREATE TABLE newtable AS SELECT artist, COUNT(artist) AS countartist FROM table1 GROUP BY artist ORDER BY countartist DESC");

edited Nov 16, 2016 at 6:23

answered Nov 12, 2016 at 17:31

swmcdonnell

1,44111 silver badges24 bronze badges

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

4 Comments

bardamu Over a year ago

"java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "(": syntax error)"

swmcdonnell Over a year ago

Sorry, I put an extra parentheses. Try it now.

bardamu Over a year ago

"java.sql.SQLException: query does not return ResultSet" could it be something with my code? previous query is working fine

swmcdonnell Over a year ago

It's not going to return a result set because it's essentially a command.

Collectives™ on Stack Overflow

Create new table in SQLite with query result

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related