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

What is the difference between syntax error and runtime error?

1142

how can we optimize or increase the speed of a mysql select query? : Sql dba

948

Why we use stored procedure instead of query?

999

How show all rows in sql?

1014

Does sql require a server?

1018

define join and explain different type of joins? : Sql dba

954

what are aggregate and scalar functions? : Sql dba

1057

How to create your own reports in sql developer?

1020

what is rdbms? : Sql dba

1014

Does pl sql work in mysql?

983

Is sql open source?

979

What is the best partition size for windows 10?

1003

What is the difference between delete and truncate commands?

1042

What are all the different normalizations?

1033

Is sql a programming?

978