Langsung Saja Teman-teman SBD L yang cerewet terutama NIM 672010110 (ha-ha-ha)
nyoh silakan copy query ke SQL kalian
select*from mahasiswa
create table mahasiswa
(
nim varchar(20) primary key not null,
nama varchar(50),
tempat_lahir varchar(50),
TTL datetime,
matakuliah1 varchar(20),
matakuliah2 varchar(20),
uang_semester int
)
insert into mahasiswa values('672010010','ALVIN ADRIAN PUTRA','Kupang','1992-10-02 00:00:00.000','SBDA','ASDB',1150000)
insert into mahasiswa values('672010110','HARESTU PRAMADHANA','Salatiga','1992-12-22 00:00:00.000','SBDB','ASDI',1000000)
insert into mahasiswa values('672010208','YONIF DWI PRASETYO','Salatiga','1991-01-04 00:00:00.000','SBDA','ASDI',500000)
insert into mahasiswa values('682010007','YOHANNA AMELIA','Solo','1992-09-13 00:00:00.000','SBDA','ASDB',750000)
insert into mahasiswa values('682010066','INDRA PERMANA KUSUMA','Salatiga','1991-08-12 00:00:00.000','SBDC','ASDI',1150000)
insert into mahasiswa values('692010009','CHRISTIAN RAHARDJO','Solo','1992-01-31 00:00:00.000','SBDB','ASDB',1150000)
insert into mahasiswa values('702010142','ARI WIDODO','Temanggung','1991-07-07 00:00:00.000','SBDC','ASDC',800000)
insert into mahasiswa values('702010151','WONO ADVEN','Salatiga','1992-03-01 00:00:00.000','SBDA','ASDB',150000)
select*from mahasiswa
Senin, 14 Maret 2011
Query For SBDL
Langganan:
Posting Komentar (Atom)
0 komentar:
Posting Komentar