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

Ads
 

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

Ads









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  How i generate table in showMessageDialog. I want that i creat a table and run in showMessageDialogeprint("cprint("code sample");ode sample
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
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
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
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  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
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
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
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
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
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
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
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 in java
table in java  please l want to make table and insert by user
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
table header
table header  how set the header to the TableModel
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
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
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 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
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
Drop Table
for a table.  Understand with Example The Tutorial 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 statement
SQLite Table
SQLite Table  how to create a table in sqlite xcode with a fix number of items

Ads