Dasar Data Base

Listing program dasar database with MySQL

create database Teknik_Informatika;
use Teknik_Informatika;
create table Informatika (nim varchar(15)primary key,nama varchar(20), alamat varchar(20), no_hp varchar(15),sex varchar(2));
show tables;
desc Informatika;
insert into Informatika values('1001530001','Puji Astuti','Jl.Kelinci 17','085740123456','P');
insert into Informatika values('1001530002','Hendarko','Jl.Kanguru 18','08123456789','L');
insert into Informatika values('1001530003','Lukito Sari','Jl.Sawi 05','083842666827','P');
insert into Informatika values('1001530004','Surya Saputra','Jl.Bayam 01','085226000111','L');
insert into Informatika values('1001530005','Fitri Aryani','Jl.Pramuka 03','085726006007','P');
insert into Informatika values('1001530006','Budiono','Jl.Bima 36','081802123111','L');
insert into Informatika values('1001530007','Salmet','Jl.Sriwijaya 30','085764002001','L');
insert into Informatika values('1001530008','Puji Sari','Jl.Pasopati 51','085227007627','P');
select*from Informatika;