SQL tutorial 34: How to copy /Insert data into a table from another table using INSERT INTO SELECT

How To copy or Insert data from one table to another
Inserting data into a table from another table
Tutorial Consist: How to copy entire data from one table to another. How to copy selected data using column name and How to copy selected data using WHERE clause
How to use INSERT INTO SELECT statement with WHERE Clause

Links

Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage

Contacts
E-Mail
Twitter
Instagram
Facebook.
Linkedin.

Thanks for liking, commenting, sharing and watching more of our videos

[iranpopslover]

this is maneeesh ! I like how happy you get when you say your own name

[prasantamohanty]

Very good and thanks lot,
Keep posting such types of videos.

[debasishdutta]

Thanks bro I m watching your video now and really enjoying your content.

[sourabhchakraborty]

Dear Sir,

Can you suggest the Best Books for understanding these stuffs.
You are doing very good job sir.
Thankyou so much for this.

[kasaramonimallesh]

Hi Manish, Could you please make video on the Merge Into .

[tyagrajsonawane]

Hi Manish you showed how to insert data from one table to another .Lets take example of yours I want to load exact table except i want to insert first 3 CHAR of column FIRSTNAME then how to do this?? any suggestion

[PrabhatKumar-dubp]

i want to count delimeter in row in sql

[sanchitagorai]

Can I put first name in select statement passing only string as per requirement inserting same data for other person in same table

[Markki]

i have a question sir, i want to add another condition on the where clause like this "tbl1.field1 = tbl2.field1", where can i declare this next condition?? on the where of SELECT statement or on the where of INSERT INTO statement?? thank you for the answer in advance... 

[tejashrimote]

hi Manish, your explanation is very nice n understandable but you video has no sound

[siddhanttripathy]

how to copy the coloums from 1 table to other?

[vivekkasera]

Thank you so much manish sir...for video
i have a question ...like i want to update contact column want to add +91 infront of all contacts... how can i do for whole column...plz do reply me.

[ANIMABAIN]

If there is no table available then we can create a table and copy the data from other tables like: create table table_name as select * from table_name; create table table_name as select column1, column2....column_names from table_name; :)

[baddoumohamed]

good job ...whath about mysqli haw i can do it

[shitaljadhav]

How to copy table data from another scheme.

[srajanjain]

Auto generated caption is saying "This is Money" : )