Database "Insert Into" Help Needed

S

Smee

Well-Known Member

Licensed User

Longtime User

• Apr 23, 2009

• #1

First Post.
Is there a sql lite equivalaent to the expression
"SELECT TableName.* INTO NewTable FROM TableName". Or is there a work around such as renaming a table?

Can any suggest any simplistic code?

Many thanks

 

R

RB Smissaert

Well-Known Member

Licensed User

Longtime User

• Apr 23, 2009

• #2

Have a look here:

SQLite Query Language: ALTER TABLE

RBS

 

S

Smee

Well-Known Member

Licensed User

Longtime User

• Apr 24, 2009

• #3

Thanks,

That code works ok

Smee