create table new table name as select * from new table name

How to copy a table in another table with datas?

Question Posted / sanjeev

Answer Posted / sanjeev

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is union, minus and interact commands?

1213

What is query execution plan in sql?

1125

What is sqlexception in java?

939

What is auto increment?

934

how do you login to mysql using unix shell? : Sql dba

1015

Explain unique key in sql.

942

What are commit, rollback, and savepoint?

935

What is a ddl command?

1004

what is heap table? : Sql dba

1045

How do you update f as m and m as f from the below table testtable?

1787

what happens if null values are involved in expressions? : Sql dba

999

Is sql sequential or random?

980

What is a stored procedure in sql with example?

1052

Why is %isopen always false for an implicit cursor?

1034

What do we need to check in database testing?

963