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 / monty

if you have a table employee you can create duplicate
record using into statement

select *into backup_employee from employee

the above statement create new table backup_employee with
same data of employee

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1000


How do you delete data from a table?

1040


how to drop an existing view in mysql? : Sql dba

1061


What is record variable?

993


What is the difference between having clause and where clause?

1062


How to make a copy values from one column to another in sql?

1037


How many types of indexes are there in sql?

985


Does oracle roll back the transaction on an error?

1014


Does truncate free space?

1012


What is microsoft t sql?

949


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1036


What is on delete set null?

1090


What is varchar example?

1032


Why do we use set serveroutput on?

966


What are basic techniques of indexing?

1384