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

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

How to copy table data from another scheme.

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

how to copy the coloums from 1 table to other?

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

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

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; :)

GREAT

how can I do this by php?

thanks too much bro

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

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

Great Work, man!
it works!

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.

i want to count delimeter in row in sql

Dear Sir,

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

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

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

thank you for the wonderful tutorial.

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

thanks....cool stuff

how i can use this in php ? 

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... 

many many thanks