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 ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of the primary key?

1005


How many joins can you have in sql?

880


Which is better varchar or nvarchar?

933


What are different types of functions in sql?

954


What are different methods to trace the pl/sql code?

1047


Does sqlite need a server?

994


When to use inner join and left join?

903


How do you create an update query?

913


Is sql microsoft?

977


How long does it take to learn pl sql?

1000


What are the set operators in sql?

1027


How to write a query to show the details of a student from students table whose

937


what are tables and fields? : Sql dba

988


What does inner join mean?

1061


What is difference between ms sql and mysql?

909