MYSQL - mysql copy table to another table example by creating new table

MYSQL - mysql copy table to another table example by creating new table

Hi,

I have a table with many fields and hue data is in it. I want to create a new table with all the data from this table. How to create a new table and select all the data into this new table?

Thanks

View Answers

May 7, 2015 at 12:31 PM

Hi,

You can use the query:

create table <newtable> select * from <old table>;

Example is:

create table employeebackup select * from employee;

Thanks









Related Tutorials/Questions & Answers:
Adding a flex table in another flex table column
Adding a flex table in another flex table column  how to add a flex table in another flex table column
table
table  multiplicatyion table
Advertisements
TABLE
TABLE   Why doesn't <TABLE WIDTH="100%"> use the full browser width
Table
Table  How i generate table in showMessageDialog. I want that i creat a table and run in showMessageDialogeprint("cprint("code sample");ode sample
Table
Table  How I generate table in showMessageDialog. E.g 3X1=3 3X2=6 3X3=9print("code sample
Table
Table  How i generate table in showMessageDialog. I want to creat a table and run in showMessageDialoge. Pl make a table programe which run..., JOptionpane, Integer.parseInt. Please use only these above methods to make table
creating table in hibernate
creating table in hibernate  how to create table by the help of hibernate   There are 2 alternatives to create table in hibernate: 1.) .hbm.xmlADS_TO_REPLACE_1 2.) Annotation. Example 1: via .hbm.xml
update one table from another table
update one table from another table  hello, i need to update one table fields by using another table fields. I have to tables Products.... for example TotalQuantity field from Products table should be updated if i
table
input from oracle table(my database table..) This is a very important table of my
table
table  Hi..I have a list of links which links to a table in the same page.If I click first link the table is displayed at the top, likewise if i click the last link the table is displayed at the last,i dont know how to set
Table
Table  How i generate table in JOptionpane.showMessageDialog... advance coding but i want u make the table using JOptionpane.showMessageDialog, import.javax.swing int Integer.parseInt(). Thats my limit. Pl generata a table
Table
Table  Why u dont understand sir?? I want to make a table program which generate a table on showMessageDialog. I have learnt these methods until now... methods to be used. Write a table program which use only and only these above methods
table?
table?  Hi, how could i make a table in javascript, which would look like this: AA CODON Number /1000 Fraction .. (this row... can't figure out, how to construct a table,with two fixed columns, one that reads
Table
Table  How i create table on showMessageDialog using JOptionpane... Exception{ BufferedReader br=new BufferedReader(new InputStreamReader(System.in)); StringBuffer buffer=new StringBuffer(); System.out.println
java coding for creating table in the console
java coding for creating table in the console  write a java program to create table
How to copy existing column along with data and column name into another existing table
How to copy existing column along with data and column name into another existing table  i want to copy the existing column along with data and column name also into another existing table... For ex; TableA : Address email
Adding button to each row for the table and adding row to another table
Adding button to each row for the table and adding row to another table  Hi I need to add button to each line in the table(Table data is retrived... row of the table
Copy One Database Table to Another
Copy One Database Table to Another   ... to another database table. That means we copy one table to a different table... Syntax for copy table: ?INSERT INTO <new_table_name> SELECT * FROM <
Creating a Hash Table
Creating a Hash Table : Java Util   ... table. What is the hash table and how to create that? Hash Table holds... for several values. Hash Table is created using an algorithm (hashing function
MySQLselect into new table Example code
MySQLselect into new table Example code  Hi, I have a big table in MySQL database and I want to create a new table with all the data in it. I have heard that there is SQL statement "mysql select into new table" which selects
HTML table example
HTML Table example In this page we will learn how to use HTML table tag... form on the web page. Here is an example of HTML Table... applications The above example shows how to use table tag
Creating Table in Echo3
. In this example of creating Table in Echo3 we have created a simple application... Creating Table in Echo3     ... in the nextapp.echo.app package. There are four constructors provided for creating a table in Echo3
take data from one table and insert same in another
take data from one table and insert same in another  I want to know when a new field update in table and the same data has to update in another table
multipications table
(called "size") and a button. When the button is clicked, another page appears.. Table (decide if this is HTML or JSP) Table shows the multipications table up to the "size" in the previous page. example: If 3 was clicked, then the output
table in java
table in java  please l want to make table and insert by user
How do we create new table apart from mapping with existing table ?
How do we create new table apart from mapping with existing table ?  Hi, How do we create new table apart from mapping with existing table ? Thanks
table header
table header  how set the header to the TableModel
Multiplication table
table is to be displayed: "); Scanner in = new Scanner(System.in); n = in.nextInt...Design and develop Multiplication table in Net beans  Design and develop a program that will print a multiplication table. The program should: Ask
How to compare two tables, and insert values which r not in one table to another table?
How to compare two tables, and insert values which r not in one table to another table?  Hi I need to compare two tables MainTable and OUTTable, The maintable may not have all the data so...if outtable have new data just
HEAP table
HEAP table  hiii, What is HEAP table?   hello,ADS_TO_REPLACE_1 This type of table is stored in the memory. Speed of execution of this table is very commendable
Table Heading in HTML
Table Heading in HTML       The Tutorial illustrates an example to create a Table in HTML. To create a Table, we define the table inside the <table> tag. A Table
center a table
center a table  How do I center a table
Multiplication table
Multiplication table Net Beans  Using Net beans Design and develop... for ending number than Display that particular multiplication table   ...(String args[]) { int n; System.out.print("Enter the number whose table
Table Creation
","Oct","Nov","Dec" }; JTable table = new JTable(rowData, columnNames); JScrollPane scrollPane = new JScrollPane(table); frame.add(scrollPane...Table Creation  hi! I want a table which looks like following can
SQLite Table
SQLite Table  how to create a table in sqlite xcode with a fix number of items
table in java
table in java  Could any one make compiler in java please reply me
table in java
table in java  Could any one make compiler in java please reply me
table in java
table in java  Could any one make compiler in java please reply me
Hash table
Hash table  Hi guys.. I have question about hash table How to implement a hash table of English words? with these methodsADS_TO_REPLACE_1 ïâ??· A method put(s), which adds the string s to the table, if it is not already
Multiplication table
number than Display that particular multiplication table   import...[]) { int n; System.out.print("Enter the number whose table is to be displayed: "); Scanner in = new Scanner(System.in); n = in.nextInt(); for(int i=1;i<=10;i
Table Creation
Table Creation  create the table for the following fields.its very urgent for me.plz help me S.No,Category( From the home page),Name of the Candidate( After registering and after selecting the category),Age,Title of the project
Photoshop Table Lamp Example
Photoshop Table Lamp Example       How to design a table lamp? This tutorial will help you in learning the steps to design a table lamp. This design has been made
Drop Table
illustrate an example from Drop Table. To grasp this example, we give you a simple demonstrative example to understand Drop Query in SQL. The create table... Drop Table       Drop
creating instance of table in jsp
creating instance of table in jsp  i face senario look kie as follows... file is obviously a jsp page and shows the output in table manner. 3) now i want to make the instance of the data present in that paarticular table.... how i do
Table Heading in HTML
Table Heading in HTML       The Tutorial illustrates an example to create a Table in HTML. To create a Table, we define the table inside the <table> tag. A Table
how to create a new table for the already existing user in the website
how to create a new table for the already existing user in the website  haiii....i want the code in jsp "how to create a new database for every user that has been already existing in the website?"....plzzzz help me
my table should be reseted to new value upon the selection of the combo box..
my table should be reseted to new value upon the selection of the combo box... DefaultTableModel(); table = new JTable(model); model.addColumn(" INVO... e) { } public void keyTyped(KeyEvent e) { }}); sc1 = new JScrollPane(table
Create a Table - Java Beginners
;Java Example Code - Creating table in JAVA... CreateTable{ JTable table; public static void main(String[] args) { new CreateTable(); } public CreateTable(){ JFrame frame = new JFrame("Create table
How To Insert A New Record to MS Access table database in GUI
How To Insert A New Record to MS Access table database in GUI  Hello, I've been working on the actionPerformed part of my java application that involves inserting a record into a 6-column table in my MS Access database table. I'm
Table & the Border attribute
Table & the Border attribute       The Tutorial illustrates an example from Table and the Border attribute. In this Tutorial, the code explains to create a table

Ads