How to copy data from one table to another new table in MySQL?

mysql copy data from one table to another database
mysql create table from another table without data
how to copy data from one table to another in mysql using php
mysql move data from one table to another
mysql copy table with foreign keys
mysql copy rows from one table to another
mysql dump data from one table to another
copy table from one database to another

I want to copy data from one table to another in MySQL.

Table 1 (Existing table):

aid    
st_id
from_uid
to_gid
to_uid
created
changed
subject
message
link

Table 2 (New Table)

st_id
uid
changed
status
assign_status

I want to copy some fields of data from TABLE 1 into TABLE 2.

Can this be done using MySQL queries?

This will do what you want:

INSERT INTO table2 (st_id,uid,changed,status,assign_status)
SELECT st_id,from_uid,now(),'Pending','Assigned'
FROM table1

If you want to include all rows from table1. Otherwise you can add a WHERE statement to the end if you want to add only a subset of table1.

I hope this helps.

How to copy data from one table to another new table in MySQL , How do I copy data from one table to another in MySQL? The complete command of copying data from an existing table to the new one is as follows: CREATE TABLE new_table SELECT col1, col2, col3 FROM existing_table WHERE conditions; Note that the statement above just copies the table and its data.

If you don't want to list the fields, and the structure of the tables is the same, you can do:

INSERT INTO `table2` SELECT * FROM `table1`;

or if you want to create a new table with the same structure:

CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl;

Reference for insert select; Reference for create table select

How to copy data from one table to another table in sql server,from , How do I import data from one table to another table? You can easily copy data into new table in MySQL using SELECT INTO. This helps you create temporary tables quickly. The SELECT INTO statement copies data from one table and inserts it into a new table.  The SELECT INTO statement selects data from one table and inserts it into a new table.

You can easily get data from another table. You have to add fields only you want.

The mysql query is:

INSERT INTO table_name1(fields you want)
  SELECT fields you want FROM table_name2

where, the values are copied from table2 to table1

SQL SELECT INTO Statement, How do I copy records from one table to another? If you want to copy data from one table to another in the same database, use INSERT INTO SELECT statement in MySQL. It’s a very quick process to copy large amount data from a table and insert into the another table in same MySQL database. In the example of INSERT SELECT syntax, we’ll copy data from posts table and insert into the posts_new table. You can also specify a predefined value in the SELECT statement.

CREATE TABLE newTable LIKE oldTable;

Then, to copy the data over

INSERT INTO newTable SELECT * FROM oldTable;

Simplest way to copy data from one table to another new table in , How copy data from old table to new table in SQL? I want to copy data from one table to another in MySQL. Table 1 (Existing table): aid st_id from_uid to_gid to_uid created changed subject message link Table 2 (New Table) st_id uid changed status assign_status I want to copy some fields of data from TABLE 1 into TABLE 2. Can this be done using MySQL queries?

The best option is to use INSERT...SELECT statement in mysql.

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

How to Copy Data Between Tables in MySQL Databases, To copy data from one table to another table, firstly we will create a table. Creating first table − mysql> CREATE table FirstTable -> ( -> id int, This is a great set of two commands that allow the creation and population of a new table with the structure and data of an existing table. This provides a quick means of making a point-in-time copy of a table and is a safe, easy way to make a quick copy of a table for testing an application in development on live data without risking a

How to duplicate a MySQL table, including indexes and data , MySQL provides a powerful option for copying data from one table to another This will Duration: 4:26 Posted: Nov 23, 2017 As an added method for keeping the original data safe, or to maintain database performance on the original data source, you can copy from one table to another database entirely.

Copy from one MySQL table to another MySQL table of same , If you want to copy a table from one database to another database: CREATE TABLE destination_db.new_table LIKE source_db.old_table;  Click the tab for the table with the columns you want to copy and select those columns. From the Edit menu, click Copy. Click the tab for the table into which you want to copy the columns. Select the column you want to follow the inserted columns and, from the Edit menu, click Paste. To copy data from one table to another. Follow the directions for copying column definitions above.

Copy data into new table in MySQL, Suppose you have mydb.mytb and you want to create mydb.mytbcopy. I have five​(5) approaches to doing this copy. APPROACH #1.

Comments
  • Is this a one time job or you plan to do it regularly?
  • @@jdias: until now it's one time job..
  • @jdias To clarify, if it's not a one time job, what should a MySQL noob look into doing instead?
  • Probably views to avoid duplicating data.
  • Possible duplicate of Copy data into another table
  • Great, glad to see this is the same as what I've been used to in T-SQL.
  • One more reason to love MySQL, very intuitive!
  • If You want to copy all table1 data then you must create new table2 before copy @SANDEEP
  • why [AS] is in square brackets, what is done by AS in here
  • It denotes that the word is optional. It is written that way because I copied and pasted from the docs; it does not add anything. I think the AS is mandatory in other SQL dialects.
  • Intuitive :) I like it. It is a normal SELECT statement, preceded with one line of "INSERT INTO".
  • Doesn't work. Per the docs, "MySQL Server doesn't support the SELECT ... INTO TABLE Sybase SQL extension"
  • While this code may answer the question, it would be better to explain how it solves the problem and why to use it. Code-only answers are not useful in the long run.