PERINTAH DASAR MYSQL

Enter password://DIMINTA UNTUK MEMASUKKAN PASSWORD

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.1.30-community-log MySQL Community Server (GPL)

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

mysql> create databases tugas;// PERINTAH UNTUK MEMBUAT DATABASE

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near 'datab

ases tugas' at line 1//INI PERINGATAN KESALAHAN DALAM PENULISAN SINTAX

mysql> create database tugas; //PERINTAH UNTUK MEMBUAT DATABASE

Query OK, 1 row affected (0.06 sec)// PEMBERITAHUAN JIKA QUERY BISA DI GUNAKAN 

 

mysql> show databases;//PERINTAHAN UNTUK MENAMPILKAN DATABASE YANG SUDAH ADA

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| tugas              |

+--------------------+

3 rows in set (0.14 sec)

mysql> use tugas;//UNTUK MENGAKTIFKAN DATABASE TUGAS

Database change//PERINTAH KALAU DATA BASE  BISA DIGUNAKAN

mysql> create table karyawan(nomor_pegawai int not null primary key,

    -> nama varchar(30) not null,

    -> bagian char(15) not null,                 

    -> jabatan varchar(30) not null,

    -> alamat varchar(50) not null);// PERINTAH UNTUK MEMBUAT TABLE KARYAWAN BESERTA FORMAT TABLE

Query OK, 0 rows affected (0.16 sec)// MENJELASKAN KALAU TABLE YANG TELAH DI BUAT TADI BUDAH ADA.

mysql> desc karyawan;//UNTUK MENAMPILKAN ATAU MENJELASKAN TABLE YANG SUDAH DI BUAT

+---------------+-------------+------+-----+---------+-------+

| Field         | Type        | Null | Key | Default | Extra |

+---------------+-------------+------+-----+---------+-------+

| nomor_pegawai | int(11)     | NO   | PRI | NULL    |       |

| nama          | varchar(30) | NO   |     | NULL    |       |

| bagian        | char(15)    | NO   |     | NULL    |       |

| jabatan       | varchar(30) | NO   |     | NULL    |       |

| alamat        | varchar(50) | NO   |     | NULL    |       |

+---------------+-------------+------+-----+---------+-------+

5 rows in set (0.05 sec)

mysql> insert into karyawan values("1002","HEBBY ZAKKIYA","MARKETING","ANGGOTA",

"solok selatan");//perintah untuk mengisikan data kedalam table yang sudah

Query OK, 1 row affected (0.05 sec)// keterangan yang menjelaskan bahwa query ok

mysql> insert into karyawan values("1016","HADRIAN ERLANDA","DESAIN GRAFIS","KOO

RDINATOR","GADUT");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1008","SILVIA TAKARINA","PEMEGANG SAHAM","DI

REKTUR","BALAI BARU");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1018","LUSI EFERENTI","KESEKRETARIATAN","ANG

GOTA","MANINJAU");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1010","FEBBY AULIA FATMA","PEMASARAN","KOORD

INATOR","PARIAMAN");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1014","PUTRI NURMAYANTI","KESEKRETARIATAN","

ANGGOTA","MANINJAU");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1020","HERWAN FAHRIZAL","KEAMANAN","SECURITY

","SOLOK");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1006","AFIT RIANTO","KEAMANAN","SECURITY","P

ASAMAN BARAT");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1004","VICO ALDO SAPUTRA","PEMASARAN","ANGGO

TA","JL BEROK");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1014","DESI RAHMA AYU","AKUNTAN","ANGGOTA","

PASAR BARU");

ERROR 1062 (23000): Duplicate entry '1014' for key 'PRIMARY'

mysql> insert into karyawan values("1016","DESI RAHMA AYU","AKUNTAN","ANGGOTA","

PASAR BARU");

ERROR 1062 (23000): Duplicate entry '1016' for key 'PRIMARY'

mysql> insert into karyawan values("1022","ENISMAR","AKUNTAN","ANGGOTA","PASAR B

ARU");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1026","MUHAMAND RIDO","AKUNTAN","ANGGOTA","T

ARUKO");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1028","SMASUL AMRINUDIN","PEMASARAN","ANGGOT

A","PASAR BARU");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1030","RISVADIA","DESAIN GRAFIS","ANGGOTA","

PASAR BARU");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1032","CARVEIN THOMAS","DESAIN GRAFIS","ANGG

OTA","JATI BARAT");

Query OK, 1 row affected (0.00 sec)

mysql> insert into karyawan values("1024","YULIANA KARNOVA","PEMASARAN","ANGGOTA

","PASAR BARU");

Query OK, 1 row affected (0.00 sec)

mysql> select * from karyawan;// perintah untuk menapilkan semua record yang telah diinputkan

+---------------+-------------------+-----------------+-------------+-----------

----+

| nomor_pegawai | nama              | bagian          | jabatan     | alamat

    |

+---------------+-------------------+-----------------+-------------+-----------

----+

|          1002 | HEBBY ZAKKIYA     | MARKETING       | ANGGOTA     | solok sela

tan |

|          1016 | HADRIAN ERLANDA   | DESAIN GRAFIS   | KOORDINATOR | GADUT

    |

|          1008 | SILVIA TAKARINA   | PEMEGANG SAHAM  | DIREKTUR    | BALAI BARU

    |

|          1018 | LUSI EFERENTI     | KESEKRETARIATAN | ANGGOTA     | MANINJAU

    |

|          1010 | FEBBY AULIA FATMA | PEMASARAN       | KOORDINATOR | PARIAMAN

    |

|          1014 | PUTRI NURMAYANTI  | KESEKRETARIATAN | ANGGOTA     | MANINJAU

    |

|          1020 | HERWAN FAHRIZAL   | KEAMANAN        | SECURITY    | SOLOK

    |

|          1006 | AFIT RIANTO       | KEAMANAN        | SECURITY    | PASAMAN BA

RAT |

|          1004 | VICO ALDO SAPUTRA | PEMASARAN       | ANGGOTA     | JL BEROK

    |

|          1022 | ENISMAR           | AKUNTAN         | ANGGOTA     | PASAR BARU

    |

|          1026 | MUHAMAND RIDO     | AKUNTAN         | ANGGOTA     | TARUKO

    |

|          1028 | SMASUL AMRINUDIN  | PEMASARAN       | ANGGOTA     | PASAR BARU

    |

|          1030 | RISVADIA          | DESAIN GRAFIS   | ANGGOTA     | PASAR BARU

    |

|          1032 | CARVEIN THOMAS    | DESAIN GRAFIS   | ANGGOTA     | JATI BARAT

    |

|          1024 | YULIANA KARNOVA   | PEMASARAN       | ANGGOTA     | PASAR BARU

    |

+---------------+-------------------+-----------------+-------------+-----------

----+

15 rows in set (0.02 sec)

mysql>