Home Answers Viewqa SQL basic question

 
 


aftab mansuri
basic question
1 Answer(s)      a year and 6 months ago
Posted in : SQL

how we create a new table with the same structure and data of another table

View Answers

November 14, 2011 at 4:05 PM


Use the following query:

CREATE TABLE <newtablename> SELECT * FROM <oldtablename>;









Related Pages:
basic question
basic question  how we create a new table with the same structure and data of another table
Java basic question...
Java basic question...   Design a Java Application project...), emp_desig as String (To hold designation of the employee) and basic as Integer (To hold the basic salary of the employee). (iii) Define and declare a method
Basic on J2ee - Java Beginners
Basic on J2ee  J2EE is a platform that helps us to develop and deploy enterprise application.It follows the component based architecure. So... to achieve the low level funcinality required for the components. My question now
php question
: PHP Basic Tutorials Thanks
Basic Facts about Android Application
Android is the latest buzzword in the arena of mobile application. The question arise in our minds that 'what are the basic facts of Mobile Android Application?'. We have seen in the past one and a half decade the boom in mobile use
basic html
basic html  what is the difference between html4 and html5
basic doubts
basic doubts  can i write two beans within a same xml file..? Also can i write two xml files within a same package
Core Java Interview Question, Interview Question
. Question: What are the two basic ways in which classes that can be run as threads ... Core Java Interview Question Page 23       Question: To what value is a variable
Project Question - Development process
Project Question  hello sir ,i have project in visual basic 6.0 ,i want to convert it in to visual basic.net2008 how i can convert it. plz Help Me its very very urgent
basic program
basic program  hii actully i am goin for technical interview on java as fresher so please tell me what these two basic lines means : public static void main(String arg) and System.out.print(); please give me meaning of each
A basic program
A basic program  Write a program that will print out the first 10 numbers, their squares and their cubes. Write a program that displays the first 100 terms of the triangular sequence. This is the sequence that goes
question
question   sir plz tell me what should i give in title box. just i want java program for the question typed in this area
question
question   sir plz tell me what should i give in title box. just i want java program for the question typed in this area
Question
Question   When there is an exception in my program how java runtime system handles
help me to solve this question
Course Code Course Name Session Semester STIA1013 Basic Programming... Name : Basic Programming Lecturer Id Lecturer Name Session Semester... Husin STIA1013 Basic Programming 124 Husin Hassan STIA2023
question
question  dear sir/madam my question is how to compare two text format in java..we are java beginners..so we need the complete source code for above mentioned question...we have to compare each and every word
question
question  Dear sir i had some typing mistake at previous question so its my humble request to let me know the steps to start the tomcat6 under the tomcat directory
basic function of computer system
basic function of computer system  What is the basic function of computer system
jdbc interview question
Resultset contains results of the SQL query. There are 3 basic types of resultset
question
question  Gud morning sir, I have asked u some question regarding jsp in saturaday for that i didnot find any answere in which u send me the some of the links.U have asked me the specify some details. There is a entity name
Question?
Question?  My question is how to: Add a menu bar to the program with a File menu. In the File menu, add a submenu (JMenuItem) called About. When the user clicks on the About menu item, display a JOptionPane message dialog
Basic Validators provided by the framework.
Basic Validators provided by the framework.  What are Validators? and What are Basic Validators provided by the framework

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.