Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL basic question
Login

Have Programming Question? Ask it here!
 
 
 
QuestionAsk Questions?

aftab mansuri
basic question
1 Answer(s)      2 years and 8 months ago
Posted in : SQL


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


Advertisement
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
basic html
basic html  what is the difference between html4 and html5
basic
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 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
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
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
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
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
Summary - Basic Elements
Java: Summary - Basic Elements In this section we will see how to comment your Java code. We will also see the Identifiers and Keyword of Java API. Properly commenting the Java code is very important. Commenting the programming code
Summary - Basic Elements
Java: Summary - Basic Elements In this section we will learn about commenting in Java. We will learn following things: a) Identifiers in Java. b) Object types in Java. c) Code commenting in Java d) Integer types in Java e) Keywords
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
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
java and visual basic
java and visual basic  Hello, Please how does java and visual basic interact or talk
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 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...//appleref/doc/uid/TP40007593 from here you can study about iphone basic development
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
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
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
Hibernate Basic Example not working
Hibernate Basic Example not working  I have implemented basic hibernate example from your site . In console i got output but database is not affected. hbm.xml <id name="id" type="long" column="id"> <generator
Need an example of basic code.
Need an example of basic code.   Im working on an art project that I want to use some code in, and I am proficient in python but that looks fairly simple so I was hoping java would look more impressive. So I just need a visual
Need an example of basic code.
Need an example of basic code.   Im working on an art project that I want to use some code in, and I am proficient in python but that looks fairly simple so I was hoping java would look more impressive. So I just need a visual
Need an example of basic code.
Need an example of basic code.   Im working on an art project that I want to use some code in, and I am proficient in python but that looks fairly simple so I was hoping java would look more impressive. So I just need a visual
BASIC Java - Java Tutorials
Basic Java Syntax This tutorial guide you about the basic syntax of the java programming language. For writing any program, you need to keep in mind the syntax of that programming language. Given below the points for syntax
Basic problem for Java experts
Basic problem for Java experts  This assignment will test your knowledge of Arrays Array searching Array sorting Array processing Specification An athletics club require a simple statistical analysis program for analysing lap
Summary - Basic GUI Elements
Java: Summary - Basic GUI Elements In this tutorial we will learn about Basic GUI elements in Java program. Following table summarizes the variable declarations. String s; // Any string. String t; // A string. //Interpreted
JSP basic doubt
JSP basic doubt  String user = request.getParameter("username"); in this "user" value is null or not how to validate? before going further action.   Hi Friend, Either you can do the following : 1)login.jsp: <
Basic CRUD operations
Basic CRUD operations  LOGIC SERVLET package com.tcs.ilp.h51.servlet; import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; import javax.servlet.RequestDispatcher; import
Basic CRUD operations
Basic CRUD operations  LOGIC SERVLET package com.tcs.ilp.h51.servlet; import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; import javax.servlet.RequestDispatcher; import
Basic CRUD operations
Basic CRUD operations  LOGIC SERVLET package com.tcs.ilp.h51.servlet; import java.io.IOException; import java.sql.SQLException; import java.util.ArrayList; import javax.servlet.RequestDispatcher; import
size of different basic data types
size of different basic data types   Write a simple program to find the size of different basic data types in java
top 20 basic programm of java
top 20 basic programm of java  what is the top 20 rule to learn the basic of java.   Learn Java through the following links: http://www.roseindia.net/java/ http://www.roseindia.net/java/beginners/index.shtml
Basic authentication
Basic authentication       Basic authentication is the process through which a web server authenticates... of the sites uses the basic authentication mechanism to protect the user from browsing
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 Filter
Basic Filter       Basic Filter Basic filter is used to implement some properties like filter element according to their index in set, elements which are in the progress
Basic Diffence between Swing-AWT - Swing AWT
Basic Diffence between Swing-AWT  What is Basic Diffence between Swing-AWT
php Basic Syntax
php Basic Syntax       In the given tutorial we will study how to write the basic syntax of php: <?php ?> The above mentioned tag will be included in each php file and each php coding
visual Basic - Design concepts & design patterns
visual Basic  send me a project. Design in visual basic. minimum length 25 pages of hard copy. please.......  please send me design in visual basic
java basic
Java basic
java basic
Advertisements
 

 

 

DMCA.com
Services

Home Privacy Policy
© All Rights are Reserved for Rose India