create table emp_dup as select * from emp: if we have already structure

How to copy a table in another table with datas?

Question Posted / mohan

Answer Posted / mohan

create table emp_dup as select * from emp:

if we have already structure means:

Insert into emp_dup(select * from emp);

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does mysql support pl sql?

1097

I need a function for a train ticket reservation please answer it thanks in advance

957

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

998

How many clustered indexes can you have?

924

what is datawarehouse? : Sql dba

950

Can a trigger call a stored procedure?

1000

What is the difference between Union and Union all. Which is faster.

1337

what is index? : Sql dba

942

How to run pl/sql statements in sql*plus?

1016

What is snowflake sql?

1010

How do you run a query?

953

How do you exit in sql?

1060

How many joins in sql?

944

How can you load multi line records? : aql loader

1015

How do you optimize a stored procedure in sql?

892