Arsip: RELASI database MySQL

more 11 years ago
itoru
Master² skLian, mw tnya nih
cara bkin Relasi antar Tabel d database mySQL gmn y ???.,.,
kLo d ms.Acces kn enak tinggl RelationShip
Mohon bmbingannya :lol: . . . .

more 11 years ago
donald
ini copy paste dari manual_mysql.chm :
SELECT * FROM t1 LEFT JOIN (t2, t3, t4)
ON (t2.a=t1.a AND t3.b=t1.b AND t4.c=t1.c)

more 11 years ago
Manz
Kalau secara query :
[sql]select a., b.
from table_a a
inner join table_b b on b.keyfield = a.keyfield[/sql]
Kalau secara fisik :
[sql]create table table_a
(
keyfield int not null,
contentfield varchar(100),
constraint pk_1 primary key (keyfield)
);
create table table_b
(
keyfield_a int not null,
keyfield_b int not null,
contentfield varchar(100),
constraint pk_2 primary key (keyfield_b),
constraint fk_1 foreign key (keyfield_a)
references table_a (keyfield)
on update cascade
on delete cascade
);[/sql]
we hope this can help you :mrgreen:

more 11 years ago
itoru
Tu Scriptny pasang dimana ??? .,.,di mySQL ny y ??
Trus . . . Kalo Relasi yg gk mkek Script ad gk PakDe² skLian ?? ...
yg maen sistem Setting gtu mksdny ??
:D

more 11 years ago
Manz
@itoru ... kalo pengen gampangnya ajah gak mau belajar sekerip nya tinggal drag n drop ajah ... coba refer ke heidiSQL ...
tapi kalo ada masalah .. ntar dikau gak bisa resolving nya ... pastinya jadi pusyink liat sekerip yang dibuat oleh heidiSQL :mrgreen:
better sih, learn from scratch alias belajar dari 0 (nol) alias belajar lah sekerip SQL nya .. biar tambah pengetahuan dan maknyosss ... bukan sekadar drag n drop palagi kalo pake wizards

more 11 years ago
itoru
@Manz = hehe...bnr jg sih pakde .,.,., ya deh .,.,ane coba Scriptny .,.,
Btw, psang tuh Script dmn ny pakde ?? .,.,ane mkek XAMPP ...
maklum msih Newbie soal MySQL ...... :D ....
more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 2 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 3 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 10 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 10 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 10 years ago
Random Topic
- Install komponen tanpa me remove komponen lain
by hawkeye in Tutorial & Community Project more 12 years ago - [Tanya] Selisih Tanggal dalam detik
by s0t4 in Tip n Trik Pemrograman more 11 years ago - Firebird di sebuah network
by wati in FireBird more 10 years ago - Help Me.....
by yuan_carlos in Hal umum tentang Pascal Indonesia more 15 years ago - Tips lengkap membuat aplikasi untuk mengakses Web Service
by EkoIndri in Delphi.NET more 15 years ago - [help] menampilkan data database pada combobox
by binyo in Lain-lain more 10 years ago - Program delphi untuk Barcode
by onsir in MySQL more 15 years ago - [Help]Gagal Search Data (Muncul peringatan)
by agusantoso in Tip n Trik Pemrograman more 11 years ago - baru bener
by gudal in MySQL more 17 years ago - beda tabel beda fungsi..?
by nurez in OOT more 17 years ago