Minggu, 18 Juni 2017

select 2 tabel banyak kondisi

select * from mahasiswa_pt_olds inner join mahasiswa_olds on mahasiswa_olds.id_pd=mahasiswa_pt_olds.id_pd where mahasiswa_pt_olds.tgl_masuk_sp LIKE '%2013' OR mahasiswa_pt_olds.tgl_masuk_sp LIKE '%2014' OR mahasiswa_pt_olds.tgl_masuk_sp LIKE '%2015' OR mahasiswa_pt_olds.tgl_masuk_sp LIKE '%2016' AND mahasiswa_pt_olds.id_sms IN ('cf0db66e-1426-4dbc-ab02-6cb9505e32a8','f023ae67-270c-433c-9754-a872e8978502','7f34bf48-f254-4138-82ba-02906faf9b55') ORDER BY `mahasiswa_pt_olds`.`tgl_masuk_sp` DESC

Minggu, 04 Juni 2017

cara remote git supaya bisa akses (pull, push)

git remote set-url origin git@localhost:repositories/root/#{myrepo}.git

git remote alamat project git kita