Create database from existing table in sqlite

Question

I have a table. For example: CREATE TABLE temp AS SELECT * FROM range(20)

How i can create in sqlite a new database with one command with the table temp?

What RDMS are you using?

Arun
– Arun

2014-09-20 01:40:25 +00:00
Commented Sep 20, 2014 at 1:40 — Arun
– Arun, Commented Sep 20, 2014 at 1:40

Arun · Accepted Answer · 2014-09-20 03:48:07Z

2

Since your in sqlite, in the command line just type:

 sqlite3 datbase_name.db

This will create a new database called database_name.db, now to create your table to this database just type:

 sqlite3 database_name.db "CREATE TABLE .......;"

Type your create table statement inside the quotes.

For more info, please take a look at their documentation.

answered Sep 20, 2014 at 3:48

Arun

9616 silver badges14 bronze badges

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

Comments

Morgan Buck · Accepted Answer · 2014-09-20 01:37:45Z

-1

I think that would depend on the DBMS but this may be what you're looking for.

COPY Command Syntax

"COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)] USING query"

http://docs.oracle.com/cd/B19306_01/server.102/b14357/apb.htm

answered Sep 20, 2014 at 1:37

Morgan Buck

114 bronze badges

Collectives™ on Stack Overflow

Create database from existing table in sqlite

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related