HomeОбразованиеRelated VideosMore From: Manish Sharma

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

327 ratings | 35812 views
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 tut 32 Insert Using SQL Developer http://youtu.be/YYQCSV6MzTk Tut 33 Insert Using INSERT DML : http://youtu.be/uQXgqFtxI_k Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 Amazon Wishlist: http://bit.ly/wishlist-amazon Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com
Html code for embedding videos on your blog
Text Comments (14)
Leandro Barbosa (3 months ago)
Great Work, man! it works!
Thanks a lot
vivek kasera (1 year ago)
Thank you so much manish sir...for video i have a question ...like i want to update contact column .....i want to add +91 infront of all contacts... how can i do for whole column...plz do reply me.
Prabhat Kumar (1 year ago)
i want to count delimeter in row in sql
Sourabh Chakraborty (2 years ago)
Dear Sir, Can you suggest the Best Books for understanding these stuffs. You are doing very good job sir. Thankyou so much for this.
PRASANT MOHANTY (2 years ago)
Very good and thanks lot, Keep posting such types of videos.
Reza Ghazanfari (2 years ago)
this is maneeesh ! I like how happy you get when you say your own name
KARTHIK K (2 years ago)
thank you for the wonderful tutorial.
Tyagraj Sonawane (2 years ago)
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
Mks (3 years ago)
thanks....cool stuff
ada life (3 years ago)
how i can use this in php ? 
Mark Lawrence Saballe (4 years ago)
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... 
Manish Sharma (4 years ago)
+Mark Lawrence Saballe You can use AND or OR operators.
ahsanul haque (4 years ago)
many many thanks

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.