Arsip: RELASI database MySQL

more 9 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 9 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 9 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 9 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 9 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 9 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
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- TTable Contain Filter?
by ekosch in Tip n Trik Pemrograman more 13 years ago - Mainmenu & toolbar
by sandy in Hal umum tentang Pascal Indonesia more 10 years ago - conect 2 pc melalui Akses Point
by umarbakri in Hal umum tentang Pascal Indonesia more 14 years ago - Baca Primary key di mysql pakai Ado object
by ho2sly in MySQL more 13 years ago - Gimana cara proteksi paling aman ?
by EkoIndri in Tip n Trik Pemrograman more 15 years ago - [tanya] caranya menidiablekan input keyboard
by krizzna in Tip n Trik Pemrograman more 14 years ago - Bantuin Normalisasi plz...
by holmes in OOT more 14 years ago - Sepele tapi GAGAL!!
by fcomputer in Bedah Kasus more 11 years ago - [ask]gimana buat form supaya memiliki style windows XP
by R960XT in Form Enhancement & Graphical Controls more 14 years ago - code huffman
by andi_meno in Hal umum tentang Pascal Indonesia more 13 years ago