Mikroprosessor

org 0h
Pembacaan_saklar:
acall Ulang
sjmp Pembacaan_saklar  
Ulang:
Mov dptr, #Teks
acall Tampil
Tampil:
clr a
Movc a, @a+dptr    
cjne a, #13h, Kirim  
ret
Kirim:
acall  Terima
Acall Tunda
inc dptr
sjmp Tampil
Terima:
Mov sbuf, a
jnb ti, $
clr ti
Ret
Tunda:
Mov r7, #0afh
Tnd:
Mov r6, #0afh
djnz r6, $
djnz r7, Tnd
ret
Teks:
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,3EH,49H,49H,49H,32H,00H ;G
DB 00H,3FH,40H,40H,40H,3FH,00H ;U
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,01H,01H,7FH,01H,01H,00H ;T
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7FH,02H,04H,08H,7FH,00H ;N
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,7FH,20H,10H,20H,7FH,00H ;W
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,01H,01H,7FH,01H,01H,00H ;T
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,7FH,09H,09H,09H,0EH,00H ;P
DB 00H,3FH,40H,40H,40H,3FH,00H ;U
db 00h,7Fh,9h,19h,29h,46h,00h ;R
DB 00H,7FH,49H,49H,49H,36H,00H ;B
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,7FH,51H,51H,51H,71H,00H ;6
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,08H,08H,08H,08H,08H,00H ;-
DB 00H,7FH,09H,09H,09H,0EH,00H ;P
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,3EH,41H,41H,41H,3EH,00H ;0
DB 00H,01H,01H,79H,05H,03H,00H ;7
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,30H,40H,40H,3FH,01H,00H ;J
DB 00H,7FH,40H,40H,40H,40H,00H ;L
DB 00H,00H,60H,60H,60H,00H,00H ;.
DB 00H,7FH,40H,40H,40H,40H,00H ;L
DB 00H,3FH,40H,40H,40H,3FH,00H ;U
DB 00H,7FH,08H,14H,22H,41H,00H ;K
DB 00H,3FH,40H,40H,40H,3FH,00H ;U
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,46H,49H,49H,49H,3DH,00H ;g
DB 00H,3EH,40H,40H,20H,7EH,00H ;u
DB 00H,26H,49H,49H,49H,32H,00H ;s
DB 00H,08H,7FH,48H,00H,00H,00H ;t
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,3FH,40H,38H,40H,3FH,00H ;w
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,08H,7FH,48H,00H,00H,00H ;t
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,7DH,12H,12H,0BH,00H,00H ;p
DB 00H,3EH,40H,40H,20H,7EH,00H ;u
DB 00H,7FH,04H,02H,01H,01H,00H ;r
DB 00H,7FH,48H,48H,48H,30H,00H ;b
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,3EH,49H,49H,49H,31H,00H ;6
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,26H,49H,49H,49H,32H,00H ;s
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,08H,08H,08H,08H,08H,00H ;-
DB 00H,7DH,12H,12H,0BH,00H,00H ;p
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,3EH,41H,41H,41H,3EH,00H ;0
DB 00H,01H,01H,79H,05H,03H,00H ;7
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,20H,40H,3CH,00H,00H ;j
DB 00H,10H,10H,10H,10H,10H,00H ;l
DB 00H,30H,30H,00H,00H,00H,00H ;.
DB 00H,00H,00H,7FH,00H,00H,00H ;l
DB 00H,3EH,40H,40H,20H,7EH,00H ;u
DB 00H,7FH,10H,28H,44H,44H,00H ;k
DB 00H,3EH,40H,40H,20H,7EH,00H ;u
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,7EH,02H,1CH,20H,7EH,00H ;N
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,7FH,08H,14H,22H,41H,00H ;K
DB 00H,3FH,40H,40H,40H,3FH,00H ;U
DB 00H,EFH,11H,11H,29H,46H,00H ;R
DB 00H,7FH,40H,40H,40H,40H,00H ;L
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7FH,40H,40H,40H,40H,00H ;L
DB 00H,7FH,40H,40H,40H,40H,00H ;L
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,7FH,08H,08H,08H,7FH,00H ;H
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,42H,61H,51H,49H,46H,00H ;2
DB 00H,4EH,49H,49H,49H,31H,00H ;5
DB 00H,01H,01H,71H,05H,03H,00H ;7
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,08H,08H,08H,08H,08H,00H ;-
DB 00H,7FH,09H,09H,09H,0EH,00H ;P
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,3EH,41H,41H,41H,3EH,00H ;0
DB 00H,01H,01H,79H,05H,03H,00H ;7
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,30H,40H,40H,3FH,01H,00H ;J
DB 00H,7FH,40H,40H,40H,40H,00H ;L
DB 00H,00H,60H,60H,60H,00H,00H ;.
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,7EH,49H,49H,49H,41H,00H ;E
DB 00H,01H,01H,7FH,01H,01H,00H ;T
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,7FH,49H,49H,49H,36H,00H ;B
DB 00H,3FH,40H,40H,40H,3FH,00H ;U
DB 00H,7EH,41H,41H,22H,1CH,00H ;D
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,26H,49H,49H,49H,32H,00H ;s
DB 00H,7FH,10H,28H,44H,44H,00H ;k
DB 00H,3EH,40H,40H,20H,7EH,00H ;u
DB 00H,7FH,04H,02H,01H,01H,00H ;r
DB 00H,10H,10H,10H,10H,10H,00H ;l
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,00H,00H,7FH,00H,00H,00H ;l
DB 00H,00H,00H,7FH,00H,00H,00H ;l
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,7FH,08H,08H,08H,70H,00H ;h
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,42H,61H,51H,49H,46H,00H ;2
DB 00H,4EH,49H,49H,49H,31H,00H ;5
DB 00H,01H,01H,79H,05H,03H,00H ;7
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,26H,49H,49H,49H,32H,00H ;s
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,08H,08H,08H,08H,08H,00H ;-
DB 00H,7DH,12H,12H,0BH,00H,00H ;p
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,3EH,41H,41H,41H,3EH,00H ;0
DB 00H,01H,01H,79H,05H,03H,00H ;7
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,20H,40H,3CH,00H,00H ;j
DB 00H,00H,00H,7FH,00H,00H,00H ;l
DB 00H,30H,30H,00H,00H,00H,00H ;.
DB 00H,26H,49H,49H,49H,32H,00H ;s
DB 00H,3DH,49H,49H,49H,26H,00H ;e
DB 00H,08H,7FH,48H,00H,00H,00H ;t
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,7FH,48H,48H,48H,30H,00H ;b
DB 00H,3EH,40H,40H,20H,7EH,00H ;u
DB 00H,78H,48H,48H,48H,7FH,00H ;d
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,01H,01H,7FH,01H,01H,00H ;T
DB 00H,EFH,11H,11H,29H,46H,00H ;R
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7FH,08H,08H,08H,7FH,00H ;H
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,7FH,02H,04H,08H,7FH,00H ;N
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,30H,40H,40H,3FH,01H,00H ;J
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,7FH,02H,04H,08H,7FH,00H ;N
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,EFH,11H,11H,29H,46H,00H ;R
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7FH,08H,14H,22H,41H,00H ;K
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,7FH,49H,49H,49H,36H,00H ;B
DB 00H,EFH,11H,11H,29H,46H,00H ;R
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,7EH,49H,49H,49H,41H,00H ;E
DB 00H,7FH,02H,04H,02H,7FH,00H ;M
DB 00H,7FH,49H,49H,49H,36H,00H ;B
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,EFH,11H,11H,29H,46H,00H ;R
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7FH,02H,04H,08H,7FH,00H ;N
DB 00H,3EH,49H,49H,49H,32H,00H ;G
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,0BH,0AH,09H,7FH,08H,00H ;4
DB 00H,41H,49H,49H,49H,36H,00H ;3
DB 00H,4FH,49H,49H,49H,31H,00H ;5
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,08H,08H,08H,08H,08H,00H ;-
DB 00H,7FH,09H,09H,09H,0EH,00H ;P
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,00H,42H,7FH,40H,00H,00H ;1
DB 00H,3EH,41H,41H,41H,3EH,00H ;0
DB 00H,01H,01H,79H,05H,03H,00H ;7
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,30H,40H,40H,3FH,01H,00H ;J
DB 00H,7FH,40H,40H,40H,40H,00H ;L
DB 00H,00H,60H,60H,60H,00H,00H ;.
DB 00H,30H,40H,40H,3FH,01H,00H ;J
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,7FH,02H,04H,02H,7FH,00H ;M
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7FH,02H,04H,08H,7FH,00H ;N
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,3EH,49H,49H,49H,32H,00H ;G
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7FH,02H,04H,08H,7FH,00H ;N
DB 00H,01H,01H,7FH,01H,01H,00H ;T
DB 00H,00H,00H,7FH,00H,00H,00H ;I
DB 00H,7FH,02H,04H,08H,7FH,00H ;N
DB 00H,3EH,49H,49H,49H,32H,00H ;G
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,3EH,49H,49H,49H,32H,00H ;G
DB 00H,3EH,49H,49H,49H,32H,00H ;G
DB 00H,00H,60H,60H,60H,00H,00H ;
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,7EH,49H,49H,49H,41H,00H ;E
DB 00H,7FH,02H,04H,08H,7FH,00H ;N
DB 00H,01H,01H,7FH,01H,01H,00H ;T
DB 00H,3EH,41H,41H,41H,3EH,00H ;O
DB 00H,46H,49H,49H,49H,31H,00H ;S
DB 00H,7DH,11H,11H,11H,7DH,00H ;A
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,08H,7FH,48H,00H,00H,00H ;t
DB 00H,7FH,04H,02H,01H,01H,00H ;r
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,7FH,08H,08H,08H,70H,00H ;h
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,20H,40H,3CH,00H,00H ;j
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,7FH,04H,02H,01H,01H,00H ;r
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,7FH,10H,28H,44H,44H,00H ;k
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,7FH,48H,48H,48H,30H,00H ;b
DB 00H,7FH,04H,02H,01H,01H,00H ;r
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,26H,49H,49H,49H,32H,00H ;s
DB 00H,3DH,49H,49H,49H,26H,00H ;e
DB 00H,7DH,01H,7DH,01H,7DH,00H ;m
DB 00H,7FH,48H,48H,48H,30H,00H ;b
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,7FH,04H,02H,01H,01H,00H ;r
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,46H,49H,49H,49H,3DH,00H ;g
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,00H,44H,7FH,40H,00H,00H ;1
DB 00H,0BH,0AH,09H,7FH,08H,00H ;4
DB 00H,41H,49H,49H,49H,36H,00H ;3
DB 00H,4FH,49H,49H,49H,31H,00H ;5
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,00H,20H,40H,3CH,00H,00H ;j
DB 00H,00H,00H,7FH,00H,00H,00H ;l
DB 00H,30H,30H,00H,00H,00H,00H ;.
DB 00H,00H,20H,40H,3CH,00H,00H ;j
DB 00H,31H,49H,49H,49H,7DH,00H ;a
DB 00H,7DH,01H,7DH,01H,7DH,00H ;m
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,46H,49H,49H,49H,3DH,00H ;g
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,08H,7FH,48H,00H,00H,00H ;t
DB 00H,00H,00H,7DH,00H,00H,00H ;i
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,46H,49H,49H,49H,3DH,00H ;g
DB 00H,00H,00H,00H,00H,00H,00H ;SPASI
DB 00H,46H,49H,49H,49H,3DH,00H ;g
DB 00H,46H,49H,49H,49H,3DH,00H ;g
DB 00H,30H,30H,00H,00H,00H,00H ;.
DB 00H,26H,49H,49H,49H,32H,00H ;s
DB 00H,3DH,49H,49H,49H,26H,00H ;e
DB 00H,7FH,02H,01H,01H,7DH,00H ;n
DB 00H,08H,7FH,48H,00H,00H,00H ;t
DB 00H,1CH,22H,22H,22H,1CH,00H ;o
DB 00H,26H,49H,49H,49H,32H,00H ;s
DB 00H,31H,49H,49H,49H,7DH,00H ;a




db 00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,13h ;spasi
db 00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,00h,13h ;spasi
end

Belajar Database

Database:

cd C:\apache\mysql\bin

C:\apache\mysql\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.47-max-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+-------------------+
| Database          |
+-------------------+
| Saya              |
| akademik          |
| db_PTmajuterus    |
| db_akademik       |
| db_kampus         |
| db_pegawai        |
| db_perpustakaan   |
| dbjualan          |
| dbkampus          |
| dbpenjualan       |
| dbsistempenjualan |
| mahasiswa         |
| mysql             |
| penjualan         |
| perpustakaan      |
| test              |
+-------------------+
16 rows in set (0.05 sec)

mysql> create database dpenjualan;
Query OK, 1 row affected (0.00 sec)

mysql> use dpenjualan;
Database changed
mysql> create table pelanggan(kode_pelanggan varchar(5), nama_pelanggan varchar(
30), alamat varchar(100),telp varchar (12));
Query OK, 0 rows affected (0.08 sec)

mysql> desc pelanggan;
+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| kode_pelanggan | varchar(5)   | YES  |     | NULL    |       |
| nama_pelanggan | varchar(30)  | YES  |     | NULL    |       |
| alamat         | varchar(100) | YES  |     | NULL    |       |
| telp           | varchar(12)  | YES  |     | NULL    |       |
+----------------+--------------+------+-----+---------+-------+
4 rows in set (0.06 sec)

mysql> insert into pelanggan values('P00087','rodesri','Di Bumi','Gak Ada');
Query OK, 1 row affected (0.05 sec)

mysql> insert into pelanggan(nama_pelanggan,telp,alamat,kode_pelanggan) values('
Rona','Rahasia Dong','Disamping Rumah Rodesri','P0002');
Query OK, 1 row affected (0.00 sec)

mysql> select * from pelanggan;
+----------------+----------------+-------------------------+--------------+
| kode_pelanggan | nama_pelanggan | alamat                  | telp         |
+----------------+----------------+-------------------------+--------------+
| P0008          | rodesri        | Di Bumi                 | Gak Ada      |
| P0002          | Rona           | Disamping Rumah Rodesri | Rahasia Dong |
+----------------+----------------+-------------------------+--------------+
2 rows in set (0.05 sec)

mysql> insert into pelanggan values('P0003','Agus','Di Mars','008'),
    -> ('P0004','Andreas','Di Pluto','001'),
    -> ('P0005','Hikma','Matahari','Gak Ada');
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select * from pelanggan;
+----------------+----------------+-------------------------+--------------+
| kode_pelanggan | nama_pelanggan | alamat                  | telp         |
+----------------+----------------+-------------------------+--------------+
| P0008          | rodesri        | Di Bumi                 | Gak Ada      |
| P0002          | Rona           | Disamping Rumah Rodesri | Rahasia Dong |
| P0003          | Agus           | Di Mars                 | 008          |
| P0004          | Andreas        | Di Pluto                | 001          |
| P0005          | Hikma          | Matahari                | Gak Ada      |
+----------------+----------------+-------------------------+--------------+
5 rows in set (0.00 sec)

mysql> select * from pelanggan where telp='Gak Ada';
+----------------+----------------+----------+---------+
| kode_pelanggan | nama_pelanggan | alamat   | telp         |
+----------------+----------------+----------+---------+
| P0008               | rodesri              | Di Bumi   | Gak Ada |
| P0005               | Hikma              | Matahari | Gak Ada |
+----------------+----------------+----------+---------+
2 rows in set (0.06 sec)

mysql> select * from pelanggan where kode_pelanggan='P0004';
+----------------+----------------+----------+------+
| kode_pelanggan | nama_pelanggan | alamat   | telp |
+----------------+----------------+----------+------+
| P0004          | Andreas        | Di Pluto | 001  |
+----------------+----------------+----------+------+
1 row in set (0.00 sec)

mysql> select * from pelanggan order by nama_pelanggan;
+----------------+----------------+-------------------------+--------------+
| kode_pelanggan | nama_pelanggan | alamat                  | telp         |
+----------------+----------------+-------------------------+--------------+
| P0003          | Agus           | Di Mars                 | 008          |
| P0004          | Andreas        | Di Pluto                | 001          |
| P0005          | Hikma          | Matahari                | Gak Ada      |
| P0008          | rodesri        | Di Bumi                 | Gak Ada      |
| P0002          | Rona           | Disamping Rumah Rodesri | Rahasia Dong |
+----------------+----------------+-------------------------+--------------+
5 rows in set (0.05 sec)

mysql> select * from pelanggan order by nama_pelanggan desc;
+----------------+----------------+-------------------------+--------------+
| kode_pelanggan | nama_pelanggan | alamat                  | telp         |
+----------------+----------------+-------------------------+--------------+
| P0002          | Rona           | Disamping Rumah Rodesri | Rahasia Dong |
| P0008          | rodesri        | Di Bumi                 | Gak Ada      |
| P0005          | Hikma          | Matahari                | Gak Ada      |
| P0004          | Andreas        | Di Pluto                | 001          |
| P0003          | Agus           | Di Mars                 | 008          |
+----------------+----------------+-------------------------+--------------+
5 rows in set (0.00 sec)

mysql> select * from pelanggan order by nama_pelanggan;
+----------------+----------------+-------------------------+--------------+
| kode_pelanggan | nama_pelanggan | alamat                  | telp         |
+----------------+----------------+-------------------------+--------------+
| P0003          | Agus           | Di Mars                 | 008          |
| P0004          | Andreas        | Di Pluto                | 001          |
| P0005          | Hikma          | Matahari                | Gak Ada      |
| P0008          | rodesri        | Di Bumi                 | Gak Ada      |
| P0002          | Rona           | Disamping Rumah Rodesri | Rahasia Dong |
+----------------+----------------+-------------------------+--------------+
5 rows in set (0.00 sec)

mysql> update pelanggan set nama_pelanggan='Gulo', alamat='Di Matahari', telp='0
02' where kode_pelanggan='P0004';
Query OK, 1 row affected (0.05 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from pelanggan;
+----------------+----------------+-------------------------+--------------+
| kode_pelanggan | nama_pelanggan | alamat                  | telp         |
+----------------+----------------+-------------------------+--------------+
| P0008          | rodesri        | Di Bumi                 | Gak Ada      |
| P0002          | Rona           | Disamping Rumah Rodesri | Rahasia Dong |
| P0003          | Agus           | Di Mars                 | 008          |
| P0004          | Gulo           | Di Matahari             | 002          |
| P0005          | Hikma          | Matahari                | Gak Ada      |
+----------------+----------------+-------------------------+--------------+
5 rows in set (0.05 sec)

mysql> delete from pelanggan where kode_pelanggan='P0003';
Query OK, 1 row affected (0.00 sec)

mysql> select * from pelanggan;
+----------------+----------------+-------------------------+--------------+
| kode_pelanggan | nama_pelanggan | alamat                  | telp         |
+----------------+----------------+-------------------------+--------------+
| P0008          | rodesri        | Di Bumi                 | Gak Ada      |
| P0002          | Rona           | Disamping Rumah Rodesri | Rahasia Dong |
| P0004          | Gulo           | Di Matahari             | 002          |
| P0005          | Hikma          | Matahari                | Gak Ada      |
+----------------+----------------+-------------------------+--------------+
4 rows in set (0.00 sec)

mysql>