Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
If new table is not yet created,
create table new_table as select * from old_table;
if new table is already created,
insert into new table select * from old_table
provided the structure of the new table is same as old
table.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Does a primary key have to be a number?
What does partition by mean in sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is the maximum number of columns in sql table?
What do you understand by exception handling in pl/sql?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
what is difference between delete and truncate commands? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
Can we insert delete data in view?
Why do we use partitions in sql?
how to use in conditions? : Sql dba
What are sql objects?
how to create a test table in your mysql server? : Sql dba
What's the difference between inner join and left join?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
