Insert data ke database (PostgreSQL) Sesuai Existing Record

 

Assalamualaikum,

Saya punya data di excel yang berisi data data dan email(source). Saya ada database tabel member yang berisi data member dan email (target). Tasknya adalah insert data dari excel ke tabel member dengan kondisi :

1. Yang di excel sudah saya import ke tabel temporary supaya mudah query.

2. Query di tabel member dengan where email jika email di tabel member ada di tabel temporary  maka lakukan insert data sesuai data existing di tabel member yg beda adalah kodenga. Contoh


Tabel member

no_id      nama          email                                kode_temp

1                Indra            [email protected]            2

2                Indra            [email protected]         256


Bisa dengan java atau bisa dengan procedure di postgre.


Data akan dikasih oleh yang terpilih.

PostgreSQL

Project Class: Micro (Under 500rb)
Published Budget: Rp 100,000
Finish Days: 3
Published Date: 21/01/2019 21:47:39 WIB
Start Date: 22/01/2019 09:03:29 WIB
Project Status: Closed
Accepted Worker: Lutfi Ghazali (zillucks)
Accepted Budget: Rp 100,000
Project Ending: Completed
Finish Date: 26/01/2019 19:52:00 WIB

Project Owner

anadrep
    
10.00/10.00
166 Point
#1,585 dari 177,491
Rated Worker: 10.00/10.00

good worker

Accepted Worker

zillucks
Kab. Jember
    
10.00/10.00
137 Point
#1,412 dari 177,491
Rated Owner: 10.00/10.00

Terima kasih telah mempercayakan job ini kepada saya. Semoga bisa bekerja sama lagi di lain kesempatan

  User Bids

zillucks
    
10.00/10.00

Iswanto
    
9.73/10.00

jajang.umara
    
9.78/10.00

afsanur1
    
10.00/10.00

anlichandra
    
9.55/10.00

agunahwan
    
10.00/10.00

widodooraono
    
9.60/10.00

cachcorp
    
10.00/10.00

AbdulHamid
    
10.00/10.00

rafiudd
    
0.00/10.00

Recommended Workers

Iswanto

18,517 points
389 projects
    
9.73/10.00

steven.comptia

22,688 points
609 projects
    
9.96/10.00

imzers

10,787 points
54 projects
    
9.87/10.00

idlamalif

10,208 points
137 projects
    
9.88/10.00

MCandraEkaSaputra

10,594 points
71 projects
    
9.87/10.00

Recommended Services

Pembuatan bot line

Rp 1,500,000
6 sales
    
10.00/10.00

Pembuatan template website & Slicing PSD to HTML

Rp 300,000
9 sales
    
10.00/10.00

Pembuatan Bot Telegram & Web Admin

Rp 1,500,000
3 sales
    
10.00/10.00

Script Full Code Mutasi Bank

Rp 4,500,000
2 sales
    
9.50/10.00

Open Projects

Revisi template wordpress

Rp 3,000,000Owner: ahmadkarimhh2
Deadline: 14 days

mengubah tampilan website

Open to SuggestionsOwner: udinkatingan
Deadline: 3 days

Intergrasi espay kedalam website

Open to SuggestionsOwner: andikapratama
Deadline: 3 days

Membuat module reward point opencart, kalau cocok bisa long term

Open to SuggestionsOwner: Susanto
Deadline: 14 days

pembuatan web donasi

Open to SuggestionsOwner: kimny88
Deadline: 30 days