•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 426,589 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,701 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 523 | Replies: 1
 |
•
•
Join Date: Apr 2008
Posts: 196
Reputation: 
Rep Power: 1
Solved Threads: 0
Junior Poster
Hi,
I have 2 tables "name1_" and "name_2". I want to compare them.
If name in "name_1" table is same as name in "name_2" table, then copy whole row into other table "name_3".
Thanks
I have 2 tables "name1_" and "name_2". I want to compare them.
If name in "name_1" table is same as name in "name_2" table, then copy whole row into other table "name_3".
Thanks
•
•
Join Date: Jun 2008
Posts: 58
Reputation:
Rep Power: 1
Solved Threads: 7
Junior Poster in Training
Try this...
if name_3 table is not yet created
if name_3 table is already created
if name_3 table is not yet created
create table name_3 as select name_1.* from name_1 inner join name_2 on name_1.name=name_2.name
if name_3 table is already created
insert into name_3 select name_1.* from name_1 inner join name_2 on name_1.name=name_2.name
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Optimizing tables to compare bilions of rows. How? (Database Design)
- Mysql match and return words in field w/ all rows (MySQL)
- compare 2 xml files with csharp (C#)
- Get All Rows In Column In A Where Statment (MS SQL)
Other Threads in the MySQL Forum
- Previous Thread: Update Inner Join help
- Next Thread: mysql backups.. help me i u know...
