Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.39 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All
rights reserved.
Oracle is a registered trademark of Oracle Corporation
and/or its
affiliates. Other names may be trademarks of their
respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the
current input statement.
mysql> create database db_dml_lanjutan;
Query OK, 1 row affected (0.19 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cdcol |
| coba lagi |
| db_coba |
| db_dml_lanjutan |
| db_latihan1 |
| db_les_private |
| dntg |
| komik_coba1 |
| mysql |
| performance_schema |
| phpmyadmin |
| tes_db |
| test |
| user coba |
| web |
| webauth |
+--------------------+
17 rows in set (0.30 sec)
mysql> use database db_dml_lanjutan;
ERROR 1049 (42000): Unknown database 'database'
mysql> use db_dml_lanjutan;
Database changed
mysql> create table pengajar;
ERROR 1113 (42000): A table must have at least 1 column
mysql> create table pengajar (nip char(4), nama
varchar(40), kota_asal varchar (
50), sks int(2), gaji double);
Query OK, 0 rows affected (0.33 sec)
mysql> primary key(nip);
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 'prima
ry key(nip)' at line 1
mysql> create table pengajar (nip char(4), nama
varchar(40), kota_asal varchar (
50), sks int(2), gaji double, primary key (nip));
ERROR 1050 (42S01): Table 'pengajar' already exists
mysql> alter table pengajar add primary key(nip);
Query OK, 0 rows affected (0.19 sec)
Records: 0
Duplicates: 0 Warnings: 0
mysql> insert into pengajar values
("0101","ahmad
rio","tangerang","4","3000000"
);
Query OK, 1 row affected (0.08 sec)
mysql> insert into pengajar values
("0102","iwan
kurniawan","serang","2","200000
0");
Query OK, 1 row affected (0.37 sec)
mysql> insert into pengajar values
("0103","asep
kusnandar","tengerang","4","300
0000");
Query OK, 1 row affected (0.01 sec)
mysql> insert into pengajar values
("0104","wati
irawati","bandungng","3","25000
00");
Query OK, 1 row affected (0.02 sec)
mysql> insert into pengajar values
("0105","neng
sukesih","bandunng","2","200000
0");
Query OK, 1 row affected (0.00 sec)
mysql> insert into pengajar values
("0106","maya
putriah","jakarta","2","2000000
");
Query OK, 1 row affected (0.36 sec)
mysql> desc pengajar
-> ;
+-----------+-------------+------+-----+---------+-------+
| Field |
Type | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| nip |
char(4) | NO | PRI | |
|
| nama |
varchar(40) | YES | | NULL
| |
| kota_asal | varchar(50) | YES | |
NULL | |
| sks |
int(2) | YES | |
NULL | |
| gaji |
double | YES | |
NULL | |
+-----------+-------------+------+-----+---------+-------+
5 rows in set (0.85 sec)
mysql> select pengajar;
ERROR 1054 (42S22): Unknown column 'pengajar' in 'field
list'
mysql> select * from pengajar;
+------+----------------+-----------+------+---------+
| nip | nama | kota_asal | sks | gaji
|
+------+----------------+-----------+------+---------+
| 0101 | ahmad rio
| tangerang | 4 | 3000000 |
| 0102 | iwan kurniawan | serang |
2 | 2000000 |
| 0103 | asep kusnandar | tengerang | 4 | 3000000 |
| 0104 | wati irawati
| bandungng | 3 | 2500000 |
| 0105 | neng sukesih
| bandunng | 2 | 2000000 |
| 0106 | maya putriah
| jakarta | 2 | 2000000 |
+------+----------------+-----------+------+---------+
6 rows in set (0.01 sec)
mysql> select * from pengajar order by gaji;
+------+----------------+-----------+------+---------+
| nip | nama | kota_asal | sks | gaji
|
+------+----------------+-----------+------+---------+
| 0102 | iwan kurniawan | serang |
2 | 2000000 |
| 0105 | neng sukesih
| bandunng | 2 | 2000000 |
| 0106 | maya putriah
| jakarta | 2 | 2000000 |
| 0104 | wati irawati
| bandungng | 3 | 2500000 |
| 0101 | ahmad rio
| tangerang | 4 | 3000000 |
| 0103 | asep kusnandar | tengerang | 4 | 3000000 |
+------+----------------+-----------+------+---------+
6 rows in set (0.38 sec)
mysql> select avg(gaji) from p[engAJAR
-> ;
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 '[engA
JAR' at line 1
mysql> select avg(gaji) from pengajar;
+--------------------+
| avg(gaji) |
+--------------------+
| 2416666.6666666665 |
+--------------------+
1 row in set (0.02 sec)
mysql> select min(gaji) from pengajar;
+-----------+
| min(gaji) |
+-----------+
| 2000000 |
+-----------+
1 row in set (0.00 sec)
mysql> select sum(gaji) from pengajar;
+-----------+
| sum(gaji) |
+-----------+
| 14500000 |
+-----------+
1 row in set (0.00 sec)
mysql>
Komentar
Posting Komentar