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 / kavitha nedigunta

create table new_table as select * from old_table;

EG:- create table emp1 as select * from emp;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between a query and a report?

904


What programs use sql?

944


explain advantages of innodb over myisam. : Sql dba

1085


Why left join is used in sql?

919


How many types of cursors are available in pl/sql?

1045


Why do we need sharding?

939


Is natural join same as inner join?

872


How do sql triggers work?

989


Explain raise_application_error.

1044


what is innodb? : Sql dba

1034


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7140


What do you understand by case manipulation functions?

954


What is a sql statement?

904


Explain some predefined exceptions.

993


Why stored procedure is faster than query?

951