Visit Jeremy's Blog.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 11-10-2014, 10:16 AM   #1
Senior Member
Registered: Jul 2009
Distribution: Debian Squeeze
Posts: 1,267

Rep: Reputation: 32
Combine two SQL tables

Lets say I have a table in a database that runs the SQL language, I also have data on another table that I would like to combine with the exiting table. There are similar columns in the new table to that of the existing one and I would like for the database to merge the data in the two tables without creating duplicates. (For instance merging the data in a row instead of appending it whenever it detects an ID number in that row, instead of placing a new row altogether). What command would I use to go about doing this.
Old 11-10-2014, 10:42 PM   #2
Registered: Jul 2012
Location: München
Distribution: Debian, CentOS/RHEL
Posts: 587

Rep: Reputation: 72
Uhm, weren't you supposed to be looking at SQL instead of Linux? See here.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Script to dump SQL tables Alexrkkl Linux - Newbie 5 12-28-2011 12:10 PM
Combine output of select statements on different tables. linuxlover.chaitanya Linux - Newbie 2 11-16-2011 02:25 AM
SQL Fetching Date from Two Tables devUnix Programming 3 11-12-2011 08:38 AM
LXer: Combine memory and disk seamlessly with ITTIA DB SQL LXer Syndicated Linux News 0 10-07-2009 04:20 AM
SQL query, comparing tables ngomong Programming 3 07-07-2002 08:44 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:09 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration