SELECT column_name(s) INTO new_table_name FROM old

write the Sql query for creating database backup?

Question Posted / vikneswaran

Answer Posted / vikneswaran

SELECT column_name(s)
INTO new_table_name
FROM old_tablename

Is This Answer Correct ?

3 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is meant by user defined function?

581

Why do we go for stored procedures?

513

what is cross join? : Sql dba

575

How can we avoid duplicating records in a query?

564

What is clause in sql?

584

What is dml with example?

517

explain the difference between delete , truncate and drop commands? : Sql dba

548

What is the source code of a program?

507

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

558

What is query syntax?

520

What are the two virtual tables available at the time of database trigger execution?

640

How is data stored in sql?

551

Which software is used for pl sql programming?

520

what are date and time functions in mysql? : Sql dba

535

Is pl sql a scripting language?

590