PHP MYSQL Combine Two Tables into one

PHP MYSQL Combine Two Tables into one

Len Farneth

12 лет назад

91,634 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

The Chosen
The Chosen - 25.01.2022 06:07

Good job bro JESUS IS COMING SOON;PREPARE

Ответить
Jerwin
Jerwin - 21.09.2021 05:23

Do you have any solution in this one "how about this problem? after creating the new table, is it updating automatically when the other table have new data inserted??"

Ответить
Thomas Angel
Thomas Angel - 08.09.2021 04:43

Wow! since 2012 and still useful. Thank you ):(

Ответить
Basher Macapantao
Basher Macapantao - 18.07.2021 09:01

Thank you..

Ответить
scott adam
scott adam - 15.12.2020 13:23

You video is poor

Ответить
Hyderabad Apical
Hyderabad Apical - 04.04.2020 16:02

But getting errors

Ответить
Hyderabad Apical
Hyderabad Apical - 04.04.2020 16:01

I have to combine 3 table

Ответить
Travel Guide
Travel Guide - 11.08.2019 17:26

This is what I was looking for. Thankyou Len

Ответить
Real Estate Faster
Real Estate Faster - 07.08.2019 20:40

Thanking You..God Bless You..!! Exact i want to did this operation that you perform..

Ответить
QWAS DIGITAL
QWAS DIGITAL - 27.07.2019 12:02

Thanks..was a lovely info...much useful

Ответить
Trupti Pawar
Trupti Pawar - 02.04.2019 09:59

Thank you sir!Its to much helpfull

Ответить
febry firmansyah
febry firmansyah - 08.10.2018 04:36

thank you bro, surely solve my problem...

Ответить
Eli0Techi
Eli0Techi - 11.08.2018 22:00

Thank you so much,
I'm searching this for days.

Ответить
kaneez fatima
kaneez fatima - 07.08.2018 05:19

nice video sir ,i have one question ,i have two table A and B ,how can i edit data from both table at a time using php mysql

Ответить
kaneez fatima
kaneez fatima - 23.02.2018 15:46

very nice video sir ,sir i have 2 table ,i want to joint both and view in one how can i joint this two
table A) name,rollno,class,subject and table B) date ,attendance status , how to can joint this table using php mysql ??? plz

Ответить
Programming w/ Professor Sluiter
Programming w/ Professor Sluiter - 02.02.2018 19:14

Seems like a very cool trick, HOWEVER, duplicating data violates some pretty fundamental principles of database design. There is room for tons of errors in the future.

Ответить
Sagar Waghmare
Sagar Waghmare - 26.12.2017 11:42

well sir i want to join two table and fetch email and password from one table and o_email and o_password from two table can you tell me how to do it

Ответить
Tias
Tias - 08.12.2017 15:16

thanks a lot bro , this very helpful

Ответить
Kunal Kasyap
Kunal Kasyap - 03.09.2017 14:24

how can i link a database with user login page using php

Ответить
Andres Perez
Andres Perez - 03.09.2017 12:52

Still a helpful video in 2017! Thanks!

Ответить
Shaik khadarvali
Shaik khadarvali - 29.07.2017 10:20

hiii how can we move the data from one table another table by using php

Ответить
Borufan Tube
Borufan Tube - 09.05.2017 15:21

Thank you. It help me clearly. Thank you

Ответить
Fahmid Hasan
Fahmid Hasan - 01.05.2017 13:39

Perfect!

Ответить
Mohamed Mohamed
Mohamed Mohamed - 02.03.2017 22:15

Thank you :):):):):):):)

Ответить
Yesha Croe
Yesha Croe - 02.03.2017 03:45

Just make a query that works. okaaaaaaay

Ответить
Wasim AbbaCi
Wasim AbbaCi - 27.01.2017 01:41

useful tutorial

Ответить
Rafay Aziz
Rafay Aziz - 13.01.2017 13:38

Hi i want to join two different parameter in mysql which are taking data inputs from wordpress site (plilugins)
both are home addresses and names of people i want to join these two different input of same parameters(names and addresses) into one so both uses it simultaniouly is it possible by what you have done in this video

Ответить
Liaqat Ali
Liaqat Ali - 23.12.2016 15:00

kindly share query for insert and update in joint tables

Ответить
C Furnell
C Furnell - 27.09.2016 21:33

Excellent Thanks

Ответить
Praveen Palkhade
Praveen Palkhade - 27.09.2016 14:28

i have two script in single database. both script have one sign up form for each. i just want to merge or make it one or over right same database for another script database table automatically so that user don't need to sign up again and cycle will complete. pls guide how i can do it .....

Ответить
koreamedia
koreamedia - 22.07.2016 13:41

after creating the new table, is it updating automatically when the other table have new data inserted??

Ответить
Daniela Venegas
Daniela Venegas - 10.03.2016 10:48

Thanks man, you saved my day!!

Ответить
Richard RJ Jacob
Richard RJ Jacob - 03.07.2015 20:19

Very helpful, thanks!

Ответить
Arpan Das
Arpan Das - 19.06.2015 22:25

Excellent! Exactly what I was looking for.
Thank you very much :)

Ответить
appstreet
appstreet - 18.05.2015 03:34

how to group_concat rows with clickable links id

Ответить
Santiago Noval Corrimo
Santiago Noval Corrimo - 12.11.2014 17:19

You are great men!!!! I spend 2 hours reading and understanding combining two tables but you made it in just7:29 mins. AWESOME. tnx for the vid..

Ответить
Dennis Noriega
Dennis Noriega - 16.10.2014 19:00

does the newly created table updates if the previous two tables were updated?

Ответить
Ashiqul Islam
Ashiqul Islam - 19.08.2014 06:44

Nice

Ответить
Bhagyashree More
Bhagyashree More - 17.03.2014 19:47

thanx a lot sir it worked for me but i when i add new values to ma tables it is not refelctd in d join table plz can u solve dis problem...

Ответить
Joseph Branch
Joseph Branch - 07.02.2014 01:45

Thank you, I think I finally got it!

Ответить
arifiiin
arifiiin - 27.01.2014 04:25

Thank You, gan. its very helpful. You explain me much better than my lecturer :D

Ответить
Lalit Kakkar
Lalit Kakkar - 20.01.2014 14:27

thanks a lot for this video, but what if we want to export some columns into existing table it show match with product id

Ответить
Idriss benarafa
Idriss benarafa - 10.12.2013 00:05

I gotta say thank you vey much Sir.
I really appreciate ( I had to play the video HD and get really close to check the code but at the end it worked ) :) Thank you very much

Ответить
Dan Kelly
Dan Kelly - 02.10.2013 15:05

Awesome! Loved it

Ответить
Len Farneth
Len Farneth - 29.08.2013 19:19

No it will not update a new table (named C) if you have your SQL set to create or modify on table A that is the only place it will modify. If you take your newly combined table (table C) and use it to replace table A then you have a new table A with your combined records and any new records will then modify table A. I hope that helps.

Ответить
Amel
Amel - 29.08.2013 11:10

Great vid but i do have a question if i merge two tables into one table will the table still update when i update the original tables. I mean if i merge databse A and B into C and in two days i get something else in table A and B will it automaticly update in C? Sorry if this is a noob question :)

Ответить
Maij
Maij - 13.08.2013 02:54

very well explained. thanks.

Ответить