PRAKTEK MYSQL
Membuat tb_pengguna
Menambahkan UNIQUE pada field email
Membuat Index pada field nama dan no telp
Mengedit Data type pada field no_telp
Memasukan data ke dalam tabel tb_pengguna
Menampilkan semua data tb_pengguna
Membuat tabel tb_team
Membust tabel tb_koordinator
Menambahkan PRIMARY KEY dan FOREIGN KEY pada tabel tb_team dan tb_koordinator
Memasukkan data pada tb_team dan tb_koordinator
INNER JOIN
LEFT JOIN
Rename tb_pengguna tb_anggota
Add colum team into tb_anggota
Add relation between tb_anggota and tb_team
Truncate all table
tb_anggota
tb_koordinator
tb_team
Insert 5 data into tb_koordinator
insert 6 with 2 NULL data into tb_team
insert 60 data into tb_anggota with some NULL data on field team
Get Data From All Tables With Null Data From Table Tb_koordinator
Get Data only field fullname from tb_koordinator and fullname from tb_anggota without null data
Get Data only field fullname from tb_koordinator and fullname from tb_anggota with null data
Count the number of Members Based on fullname on tb_koordinator that has members more than or Equal To 5
Create View From Data On Point 26
Create Temporary Table From Data On Point 26
Truncate Table Temporary
Add Column jenis_kelamin Using Data Type Enum
Update Data tb_anggota For Column jenis_kelamin
Get Data From 3 All Table Sort by fullname from tb_anggota alphabetically
Komentar
Posting Komentar