POLITEKNIK KODIKLATAD

JURUSAN TEKNIK KOMUNIKASI

DISUSUN OLEH  :

Nama        :    Serda Ryan Yudha Kuntara.     (20190431-E)            

TEKNIK KOMUNIKASI D4 ANGKATAN IV

BATU,        JULI 2020

1.         Tujuan                       :  Agar dapat menguasai pemrograman lewat CMD

2.         Alat dan Bahan       : 

1. COMMAND PROMPT

3.                Percobaan :


Microsoft Windows [Version 10.0.18362.900]
(c) 2019 Microsoft Corporation. All rights reserved.

C:\Users\ADMIN>cd..

C:\Users>cd..

C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin

C:\xampp\mysql\bin>mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.16 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> CREATE DATABASE RYAN ;
ERROR 1007 (HY000): Can't create database 'ryan'; database exists
MySQL [(none)]> CREATE DATABASE KYUYANG ;
Query OK, 1 row affected (0.00 sec)

MySQL [(none)]> USE KYUYANG
Database changed
MySQL [KYUYANG]> CREATE TABLE POLTEKAD (
    -> NAMA_BAMASIS varchar (50),
    -> NRP varchar (20),
    -> JENIS_KELAMIN enum ("L","P"),
    -> SATUAN varchar (50),
    -> primary key (NRP)
    -> );
Query OK, 0 rows affected (0.52 sec)

MySQL [KYUYANG]> INSERT INTO POLTEKAD
    -> VALUES("RYAN","21170084540398","L","YONKAV8") ;
Query OK, 1 row affected (0.12 sec)

MySQL [KYUYANG]> SELECT * FROM POLTEKAD ;
+--------------+----------------+---------------+---------+
| NAMA_BAMASIS | NRP            | JENIS_KELAMIN | SATUAN  |
+--------------+----------------+---------------+---------+
| RYAN         | 21170084540398 | L             | YONKAV8 |
+--------------+----------------+---------------+---------+

1 row in set (0.00 sec)

PENULISAN DI COMMAND PROMT :