basic question

basic question

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 Tutorials/Questions & Answers:
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
Advertisements
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
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
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 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
basic
java core basic problem
java core basic problem  my question is: write a program that illustrates interface inheritance. interface P is extended by P1 and P2. interface... methode. class Q impliments P12 Instantiate Q and invoke each of its methods.Each
java core basic problem
java core basic problem  my question is: write a program that illustrates interface inheritance. interface P is extended by P1 and P2. interface... methode. class Q impliments P12 Instantiate Q and invoke each of its methods.Each
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
basic function of computer system
basic function of computer system  What is the basic function of computer system
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
Basic Validators provided by the framework.
Basic Validators provided by the framework.  What are Validators? and What are Basic Validators provided by the framework
Basic Java Tutorial
Basic Java Tutorial  Hi, Where is the url of Basic Java Tutorials on roseindia.net? Thanks   Hi, You can Learn Java in a Day also? Thanks
java and visual basic
java and visual basic  Hello, Please how does java and visual basic interact or talk
basic c/c++ questions
basic c/c++ questions  Are the Control statements like if(),while() in built functions? if no, why not as they satisfy all the properties of a function
basic c/c++ questions
basic c/c++ questions  Are the Control statements like if(),while() in built functions? if no, why not as they satisfy all the properties of a function
Question on pooling
Question on pooling  which server supports pooling?Application server or web server
Basic for iphone development??
Basic for iphone development??  hiii... I want to go for iphone development .. What are the basic for iphone development can some body.../index.html%23//appleref/doc/uid/TP40007593 from here you can study about iphone basic
visual basic coding...
visual basic coding...  Visual Basic Game Programming please help me to build visual basic code with four screens (spin,bet,help and exit... a)Develop a simple Slot machine Jackpot system. Be as creative as possible
basic java - Java Beginners
basic java  oops concept in java ?  Hi Friend, Please visit the following links: http://www.roseindia.net/java/beginners/oop-in-java.shtml http://www.roseindia.net/java/learn-java-in-a-day/oops.shtml Thanks
spring basic example
spring basic example  hi,, i cannot understand the flow of the spring mvc example. can you explain execution flow of the spring example project?? thanks
Voice Recognition in Visual Basic
Voice Recognition in Visual Basic  Sir, I'm BCA final year student and "voice recognition" is my major project,I want to make it by myself in "Visual Basic" How can it possible in 'V.B.net'. which initial step should i follow
This question in Jmeter
This question in Jmeter  hi..i want to send request(xml) 100 times but each time in request xml one element needs to change, otherwise request will be failed since its duplicate
Question on javascript
Question on javascript  This is not exactly what i wanted....If i enter in 2nd combobox as name of child then it should show child id in 1st combobox automatically and vice versa
C# question
Create a Solution by name Bank with Classes Account.cs, SavingsAccount.cs and savingsTest.cs to Demonstrate Abstract Classes in C#  1st question : Create a Solution by name Bank with Classes Account.cs, SavingsAccount.cs
question for c++
question for c++   write Program to swap between two numbers if first number is greater than second number and total of two numbers greater than 10
Inheritance question?
Inheritance question?  Q3)Create a class hierarchy as Company extended by AccountsDepartment. AccountsDepartment extended by AccountsReceivable... as AccountsPayable. please send the code of this question soon....plzzzzzzzz  
Inheritance question?
Inheritance question?  Q3)Create a class hierarchy as Company extended by AccountsDepartment. AccountsDepartment extended by AccountsReceivable... as AccountsPayable. please send the code of this question soon....plzzzzzzzz View
basic data science
basic data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: basic data science... the topic "basic data science". Also tell me which is the good training
basic python for data science
basic python for data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: basic... that I can learn the topic "basic python for data science". Also tell me
basic of data science
basic of data science  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: basic of data... the topic "basic of data science". Also tell me which is the good
ai basic course
ai basic course  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: ai basic course Try... "ai basic course". Also tell me which is the good training courses
basic ai course
basic ai course  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: basic ai course Try... "basic ai course". Also tell me which is the good training courses
basic artificial intelligence course
basic artificial intelligence course  Hi, I am beginner in Data...: basic artificial intelligence course Try to provide me good examples or tutorials links so that I can learn the topic "basic artificial intelligence
machine learning basic course
machine learning basic course  Hi, I am beginner in Data Science... learning basic course Try to provide me good examples or tutorials links so that I can learn the topic "machine learning basic course". Also tell me
ai basic programming
ai basic programming  Hi, I am beginner in Data Science and machine learning field. I am searching for the tutorials to learn: ai basic... the topic "ai basic programming". Also tell me which is the good training
machine learning basic program
machine learning basic program  Hi, I am beginner in Data Science... learning basic program Try to provide me good examples or tutorials links so that I can learn the topic "machine learning basic program". Also tell
Question in Eclipse ??
Question in Eclipse ??  ** Hello EveryOne , L Have Question in Eclipse ?!! Question is : A.( The square class) Design a class named Square that contains : 1.A private instance variable side of type double 2.A no-argument
Question in Eclipse
Question in Eclipse   ** Hello EveryOne , L Have Question in Eclipse ?!! Question is : A.( The square class) Design a class named Square that contains : 1.A private instance variable side of type double 2.A no-argument
Question in Java ??
Question in Java ??  Welcome every One ,I have Q in Java : Write aprogram that print the falewing table using SQRT method in the Math Class? Number 0 ,2, . . . ,18,20 squrfoot 00000 1.4142 5.2426 5.4721
jsp question
jsp question   sir plz tell me how can I create a page which is similar to feedback form in which if one option is empty then other option is inaccessible. for example it consists of name address etc. if name field is not filled
jsp question..
jsp question..  what should do in deployment descriptor after adding jstl jar files.. I am the the following message in console screen; The absolute cannot be resolved in either web.xml or the jar files deployed
jsp question..
jsp question..  what should do in deployment descriptor after adding jstl jar files.. I am the the following message in console screen; The absolute cannot be resolved in either web.xml or the jar files deployed

Ads