mySQL insert into table data from another table

Question

I was wondering if there is a way to do this purely in sql   q1   SELECT campaign id  from number  received msg  date received       FROM  received txts  WHERE  campaign id     8   INSERT INTO action 2 members  campaign id  mobile  vote  vote date          VALUES q1 campaign id  q1 from number  q1 received msg  q1 date received     Note  q1 would return about 30k rows   Is there any way to do what I am attempting above in straight sql  To just pull the data straight from one table  basically a raw data table  and insert into another table  basically a processed data table

User · Accepted Answer

INSERT INTO action 2 members  campaign id  mobile  vote  vote date    SELECT campaign id  from number  received msg  date received   FROM  received txts   WHERE  campaign id     8

User · Answer

INSERT INTO preliminary image  style id pre image status file extension reviewer id  uploader id is deleted last updated    SELECT  4827499  pre image status file extension reviewer id  uploader id  0  last updated FROM preliminary image WHERE style id 4827488   Analysis  We can use above query if we want to copy data from one table to another table in mysql   Here source and destination table are same  we can use different tables also  Few columns we are not copying like style id and is deleted so we selected them hard coded from another table Table we used in source also contains auto increment field so we left that column and it get inserted automatically with execution of query    Execution results  1 queries executed  1 success  0 errors  0 warnings  Query  insert into preliminary image  style id pre image status file extension reviewer id uploader id is deleted last updated  select      5 row s  affected  Execution Time   0 385 sec Transfer Time    0 sec Total Time       0 386 sec

User · Answer

for whole row       insert into xyz select   from xyz2 where id  1    for selected column   insert into xyz t id v id f name  select t id v id f name from xyz2 where id  1

User · Answer

INSERT INTO Table1 SELECT   FROM Table2

User · Answer

Answered by zerkms is the correct method  But  if someone looking to insert more extra column in the table then you can get it from the following   INSERT INTO action 2 members   campaign id    mobile    email    vote    vote date    current time   SELECT  campaign id    from number    example domain xyz    received msg    date received   1502309889 FROM  received txts  WHERE  campaign id     8    In the above query  there are 2 extra columns named email  amp  current time

User · Answer

This query is for add data from one table to another table using  foreign key let qry    quot INSERT INTO  tb customer master    My Referral Code    City Id    Cust Name    Reg Date Time    Mobile Number    Email Id    Gender    Cust Age    Profile Image    Token    App Type    Refer By Referral Code    Status   values    quot    randomstring generate 7     quot      quot    req body City Id    quot      quot    req body Cust Name    quot      quot    req body Reg Date Time    quot     quot    req body Mobile Number    quot     quot    req body Email Id    quot     quot    req body Gender    quot     quot    req body Cust Age    quot     quot    req body Profile Image    quot     quot    req body Token    quot     quot    req body App Type    quot     quot    req body Refer By Referral Code    quot     quot    req body Status    quot    quot                           connection query qry   err  rows    gt                                if  err    res send err    else                                   let insert    quot INSERT INTO  tb customer and transaction master    Cust Id  values    quot    rows insertId    quot    quot                                   connection query insert   err    gt                                        if  err                                            res json err                                        else                                           res json  quot Customer added quot

[sql] mySQL :: insert into table, data from another table?

Examples related to sql

Examples related to mysql