Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to copy a table in another table with datas?

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 ?    21 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which language is used in sql?

1047


How do you explain an index?

1276


What is the default isolation level in sql server? : Transact sql

1012


define data blocks ? : Sql dba

971


What is the usage of nvl function?

1029


How can one get sql*loader to commit only at the end of the load file? : aql loader

1049


What is set serveroutput on in pl sql?

1279


What is crud sql?

972


What are the different ddl commands in sql?

1147


Which nosql database is best?

971


What is trigger in sql? Explain

980


Define union, minus, union all, intersect ?

996


how many sql ddl commands are supported by 'mysql'? : Sql dba

1012


What are triggers in sql?

1012


How do I remove sql developer from windows 10?

1092