API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 5th, 2019
162
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.94 KB | None | 0 0
raw download clone embed print report
  1. Welcome to the MySQL monitor. Commands end with ; or \g.
  2. Your MySQL connection id is 7
  3. Server version: 5.7.26-0ubuntu0.18.04.1 (Ubuntu)
  4.  
  5. Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
  6.  
  7. Oracle is a registered trademark of Oracle Corporation and/or its
  8. affiliates. Other names may be trademarks of their respective
  9. owners.
  10.  
  11. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  12.  
  13. mysql> create database informatika;
  14. Query OK, 1 row affected (0.00 sec)
  15.  
  16. mysql> show databases;
  17. +--------------------+
  18. | Database |
  19. +--------------------+
  20. | information_schema |
  21. | db_perpus |
  22. | informatika |
  23. | mysql |
  24. | performance_schema |
  25. | sys |
  26. +--------------------+
  27. 6 rows in set (0.00 sec)mysql> use informatika;
  28. Database changed
  29.  
  30. mysql> create table mahasiswa( nim INT(20) NOT NULL PRIMARY KEY, nama varchar(30) NOT NULL, alamat text);
  31. Query OK, 0 rows affected (0.31 sec)
  32.  
  33. mysql> create table jadwal(nama varchar(30) NOT NULL, nim INT(20) NOT NULL PRIMARY KEY, mata_kuliah varchar(30), jam TIME, hari DATE, kelas varchar(10));
  34. Query OK, 0 rows affected (0.28 sec)
  35.  
  36. create table nilai_akhir(nim INT(20) NOT NULL PRIMARY KEY, nama varchar(30) NOT NULL, prodi varchar(10), mata_kuliah varchar(20), nilai INT(100), huruf text, sks varchar(10), ipk varchar(10));
  37. Query OK, 0 rows affected (0.26 sec)
  38.  
  39. mysql> show tables;
  40. +-----------------------+
  41. | Tables_in_informatika |
  42. +-----------------------+
  43. | jadwal |
  44. | mahasiswa |
  45. | nilai_akhir |
  46. +-----------------------+
  47. 3 rows in set (0.00 sec)
  48.  
  49. mysql> desc mahasiswa;
  50. +--------+-------------+------+-----+---------+-------+
  51. | Field | Type | Null | Key | Default | Extra |
  52. +--------+-------------+------+-----+---------+-------+
  53. | nim | int(20) | NO | PRI | NULL | |
  54. | nama | varchar(30) | NO | | NULL | |
  55. | alamat | text | YES | | NULL | |
  56. +--------+-------------+------+-----+---------+-------+
  57. 3 rows in set (0.00 sec)
  58.  
  59. mysql> desc jadwal;
  60. +-------------+-------------+------+-----+---------+-------+
  61. | Field | Type | Null | Key | Default | Extra |
  62. +-------------+-------------+------+-----+---------+-------+
  63. | nama | varchar(30) | NO | | NULL | |
  64. | nim | int(20) | NO | PRI | NULL | |
  65. | mata_kuliah | varchar(30) | YES | | NULL | |
  66. | jam | time | YES | | NULL | |
  67. | hari | date | YES | | NULL | |
  68. | kelas | varchar(10) | YES | | NULL | |
  69. +-------------+-------------+------+-----+---------+-------+
  70. 6 rows in set (0.00 sec)
  71.  
  72. mysql> desc nilai_akhir;
  73. +-------------+-------------+------+-----+---------+-------+
  74. | Field | Type | Null | Key | Default | Extra |
  75. +-------------+-------------+------+-----+---------+-------+
  76. | nim | int(20) | NO | PRI | NULL | |
  77. | nama | varchar(30) | NO | | NULL | |
  78. | prodi | varchar(10) | YES | | NULL | |
  79. | mata_kuliah | varchar(20) | YES | | NULL | |
  80. | nilai | int(100) | YES | | NULL | |
  81. | huruf | text | YES | | NULL | |
  82. | sks | varchar(10) | YES | | NULL | |
  83. | ipk | varchar(10) | YES | | NULL | |
  84. +-------------+-------------+------+-----+---------+-------+
  85. 8 rows in set (0.00 sec)
  86.  
  87. mysql> insert into mahasiswa values
  88. -> ('2018150001','Dobleh','Cilacap'),
  89. -> ('2018150002','Jamal','Tegal'),
  90. -> ('2018150003','Taufik','Banyumas'),
  91. -> ('2018150004','Kabur','Wonosobo');
  92. Query OK, 4 rows affected (0.06 sec)
  93. Records: 4 Duplicates: 0 Warnings: 0
  94.  
  95. mysql> select * from jadwal;
  96. Empty set (0.02 sec)
  97.  
  98. mysql> alter table jadwal change column hari hari varchar(10);
  99. Query OK, 0 rows affected (0.78 sec)
  100. Records: 0 Duplicates: 0 Warnings: 0
  101.  
  102. mysql> desc jadwal;
  103. +-------------+-------------+------+-----+---------+-------+
  104. | Field | Type | Null | Key | Default | Extra |
  105. +-------------+-------------+------+-----+---------+-------+
  106. | nama | varchar(30) | NO | | NULL | |
  107. | nim | int(20) | NO | PRI | NULL | |
  108. | mata_kuliah | varchar(30) | YES | | NULL | |
  109. | jam | time | YES | | NULL | |
  110. | hari | varchar(10) | YES | | NULL | |
  111. | kelas | varchar(10) | YES | | NULL | |
  112. +-------------+-------------+------+-----+---------+-------+
  113. 6 rows in set (0.00 sec)
  114.  
  115. mysql> insert into jadwal values ('Dobleh','2018150001','Basis Data','08:00:00','senin','1'),('Jamal','2018150002','Basis Data','10:30:00','selasa','2'), ('Taufik','2018150003','Basis Data','07:30:00','rabu','3'),('Kabur','2018150004','Basis Data','09:00:00','kamis','4');
  116. Query OK, 4 rows affected (0.04 sec)
  117. Records: 4 Duplicates: 0 Warnings: 0
  118.  
  119. mysql> desc nilai_akhir;
  120. +-------------+-------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+-------------+-------------+------+-----+---------+-------+
  121. | nim | int(20) | NO | PRI | NULL | |
  122. | nama | varchar(30) | NO | | NULL | |
  123. | prodi | varchar(10) | YES | | NULL | |
  124. | mata_kuliah | varchar(20) | YES | | NULL | |
  125. | nilai | int(100) | YES | | NULL | |
  126. | huruf | text | YES | | NULL | |
  127. | sks | varchar(10) | YES | | NULL | |
  128. | ipk | varchar(10) | YES | | NULL | |
  129. +-------------+-------------+------+-----+---------+-------+
  130. 8 rows in set (0.00 sec)
  131.  
  132. mysql> insert into nilai_akhir values ('2018150001','Dobleh','TI','BasisData','80','a','20','4'), ('2018150002','Jamal','TI','Basis Data','70','b','19','3'), ('2018150003','Taufik','TI','Basis Data','85','a','22','4'), ('2018150004','Kabur','TI','Basis Data','90','a','22','4');Query OK, 4 rows affected (0.05 sec)
  133. Records: 4 Duplicates: 0 Warnings: 0
  134.  
  135. mysql> select * from mahasiswa;
  136. +------------+--------+----------+
  137. | nim | nama | alamat |
  138. +------------+--------+----------+
  139. | 2018150001 | Dobleh | Cilacap |
  140. | 2018150002 | Jamal | Tegal |
  141. | 2018150003 | Taufik | Banyumas |
  142. | 2018150004 | Kabur | Wonosobo |
  143. +------------+--------+----------+
  144. 4 rows in set (0.00 sec)
  145.  
  146. mysql> select * from jadwal;
  147. +--------+------------+-------------+----------+--------+-------+
  148. | nama | nim | mata_kuliah | jam | hari | kelas |
  149. +--------+------------+-------------+----------+--------+-------+
  150. | Dobleh | 2018150001 | Basis Data | 08:00:00 | senin | 1 |
  151. | Jamal | 2018150002 | Basis Data | 10:30:00 | selasa | 2 |
  152. | Taufik | 2018150003 | Basis Data | 07:30:00 | rabu | 3 |
  153. | Kabur | 2018150004 | Basis Data | 09:00:00 | kamis | 4 |
  154. +--------+------------+-------------+----------+--------+-------+
  155. 4 rows in set (0.01 sec)
  156.  
  157. mysql> select * from nilai_akhir;
  158. +------------+--------+-------+-------------+-------+-------+------+------+
  159. | nim | nama | prodi | mata_kuliah | nilai | huruf | sks | ipk |
  160. +------------+--------+-------+-------------+-------+-------+------+------+
  161. | 2018150001 | Dobleh | TI | Basis Data | 80 | a | 20 | 4 |
  162. | 2018150002 | Jamal | TI | Basis Data | 70 | b | 19 | 3 |
  163. | 2018150003 | Taufik | TI | Basis Data | 85 | a | 22 | 4 |
  164. | 2018150004 | Kabur | TI | Basis Data | 90 | a | 22 | 4 |
  165. +------------+--------+-------+-------------+-------+-------+------+------+
  166. 4 rows in set (0.00 sec)
  167.  
  168. mysql> select * from mahasiswa where nama='Dobleh';
  169. +------------+--------+---------+
  170. | nim | nama | alamat |
  171. +------------+--------+---------+
  172. | 2018150001 | Dobleh | Cilacap |
  173. +------------+--------+---------+
  174. 1 row in set (0.09 sec)
  175.  
  176. mysql> select * from mahasiswa where nama>'Dobleh';
  177. +------------+--------+----------+
  178. | nim | nama | alamat |
  179. +------------+--------+----------+
  180. | 2018150002 | Jamal | Tegal |
  181. | 2018150003 | Taufik | Banyumas |
  182. | 2018150004 | Kabur | Wonosobo |
  183. +------------+--------+----------+
  184. 3 rows in set (0.02 sec)
  185.  
  186. mysql> select * from mahasiswa where nama<'Kabur';
  187. +------------+--------+---------+
  188. | nim | nama | alamat |
  189. +------------+--------+---------+
  190. | 2018150001 | Dobleh | Cilacap |
  191. | 2018150002 | Jamal | Tegal |
  192. +------------+--------+---------+
  193. 2 rows in set (0.00 sec)
  194.  
  195. mysql> select * from mahasiswa where nama<='Kabur';
  196. +------------+--------+----------+
  197. | nim | nama | alamat |
  198. +------------+--------+----------+
  199. | 2018150001 | Dobleh | Cilacap |
  200. | 2018150002 | Jamal | Tegal |
  201. | 2018150004 | Kabur | Wonosobo |
  202. +------------+--------+----------+
  203. 3 rows in set (0.00 sec)
  204.  
  205. mysql> select * from mahasiswa where nama!='Kabur';
  206. +------------+--------+----------+
  207. | nim | nama | alamat |
  208. +------------+--------+----------+
  209. | 2018150001 | Dobleh | Cilacap |
  210. | 2018150002 | Jamal | Tegal |
  211. | 2018150003 | Taufik | Banyumas |
  212. +------------+--------+----------+
  213. 3 rows in set (0.00 sec)
  214. select mahasiswa.nim, mahasiswa.nama, mahasiswa.alamat, jadwal.nama, jadwal.nim, jadwal.mata_kuliah, jadwal.jam, jadwal.hari, jadwal.kelas, nilai_akhir.nim, nilai_akhir.nama, nilai_akhir.prodi, nilai_akhir.mata_kuliah, nilai_akhir.nilai, nilai_akhir.huruf, nilai_akhir.sks, nilai_akhir.ipk from mahasiswa left join jadwal on mahasiswa.nim=jadwal.nim left join nilai_akhir on jadwal.nim=nilai_akhir.nim;
  215. +------------+--------+----------+--------+------------+-------------+----------+--------+-------+------------+--------+-------+-------------+-------+-------+------+------+
  216. | nim | nama | alamat | nama | nim | mata_kuliah | jam | hari | kelas | nim | nama | prodi | mata_kuliah | nilai | huruf | sks | ipk |
  217. +------------+--------+----------+--------+------------+-------------+----------+--------+-------+------------+--------+-------+-------------+-------+-------+------+------+
  218. | 2018150001 | Dobleh | Cilacap | Dobleh | 2018150001 | Basis Data | 08:00:00 | senin | 1 | 2018150001 | Dobleh | TI | Basis Data |80 | a | 20 | 4 |
  219. | 2018150002 | Jamal | Tegal | Jamal | 2018150002 | Basis Data | 10:30:00 | selasa | 2 | 2018150002 | Jamal | TI | Basis Data |70 | b | 19 | 3 |
  220. | 2018150003 | Taufik | Banyumas | Taufik | 2018150003 | Basis Data | 07:30:00 | rabu | 3 | 2018150003 | Taufik | TI | Basis Data |85 | a | 22 | 4 |
  221. | 2018150004 | Kabur | Wonosobo | Kabur | 2018150004 | Basis Data | 09:00:00 | kamis | 4 | 2018150004 | Kabur | TI | Basis Data |90 | a | 22 | 4 |
  222. +------------+--------+----------+--------+------------+-------------+----------+--------+-------+------------+--------+-------+-------------+-------+-------+------+------+
  223. 4 rows in set (0.06 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!