Pengantar Bahasa Query:UTS 2 - Revision history

Kangtain: Kangtain moved page Materi/Pengantar Bahasa Query/UTS 2 to Pengantar Bahasa Query:UTS 2 over redirect

2022-11-19T16:14:57Z

Kangtain moved page Materi/Pengantar Bahasa Query/UTS 2 to Pengantar Bahasa Query:UTS 2 over redirect

← Older revision	Revision as of 23:14, 19 November 2022
(No difference)

Kangtain at 22:55, 18 November 2022

2022-11-18T22:55:09Z

← Older revision		Revision as of 05:55, 19 November 2022
Line 69:		Line 69:
	</syntaxhighlight>		</syntaxhighlight>

	~~{{DISPLAYTITLE:UTS 2}}~~
	[[Category:Materi]]		[[Category:Materi]]
	[[Category:Matkul]]		[[Category:Matkul]]
	[[Category:Pengantar Bahasa Query]]		[[Category:Pengantar Bahasa Query]]

Kangtain at 09:40, 16 November 2022

2022-11-16T09:40:15Z

← Older revision		Revision as of 16:40, 16 November 2022
Line 70:		Line 70:

	{{DISPLAYTITLE:UTS 2}}		{{DISPLAYTITLE:UTS 2}}
			[[Category:Materi]]
			[[Category:Matkul]]
			[[Category:Pengantar Bahasa Query]]

Kangtain at 10:03, 4 September 2022

2022-09-04T10:03:14Z

← Older revision		Revision as of 17:03, 4 September 2022
Line 2:		Line 2:
	<syntaxhighlight lang="shell">		<syntaxhighlight lang="shell">
	sudo mysql -u root		sudo mysql -u root
			</syntaxhighlight>

	~~</syntaxhighlight>~~<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	CREATE DATABASE mustain;		CREATE DATABASE mustain;
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	use mustain;		use mustain;
			</syntaxhighlight>

	~~</syntaxhighlight>~~<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	CREATE TABLE nilai ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );		CREATE TABLE nilai ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');
	</syntaxhighlight>		</syntaxhighlight>
Line 18:		Line 26:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');
	</syntaxhighlight><syntaxhighlight lang="sql">		</syntaxhighlight>

			<syntaxhighlight lang="sql">
	INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');
	</syntaxhighlight>		</syntaxhighlight>

	*Memperlihatkan data yang sudah di input		*Memperlihatkan data yang sudah di input
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	SELECT * FROM nilai		SELECT * FROM nilai
	</syntaxhighlight>		</syntaxhighlight>

			{{DISPLAYTITLE:UTS 2}}

Kangtain: Kangtain moved page Pengantar Bahasa Query:UTS 2 to Materi/Pengantar Bahasa Query/UTS 2

2022-09-04T09:46:42Z

Kangtain moved page Pengantar Bahasa Query:UTS 2 to Materi/Pengantar Bahasa Query/UTS 2

← Older revision	Revision as of 16:46, 4 September 2022
(No difference)

Kangtain at 23:44, 22 August 2022

2022-08-22T23:44:43Z

@@ Line 1: / Line 1: @@
   sudo mysql -u root
- CREATE DATABASE mustain;
+</syntaxhighlight><syntaxhighlight lang="sql">
 CREATE DATABASE mustain;
- use mustain;
+</syntaxhighlight><syntaxhighlight lang="sql">
 use mustain;
 *Memperlihatkan data yang sudah di input
- SELECT * FROM nilai
+<syntaxhighlight lang="sql">

Kangtain at 14:04, 2 March 2022

2022-03-02T14:04:18Z

Kangtain at 07:15, 2 March 2022

2022-03-02T07:15:14Z

← Older revision		Revision as of 14:15, 2 March 2022
Line 30:		Line 30:

	INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');		INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');

			*Memperlihatkan data yang sudah di input
			SELECT * FROM npm1121040022

Kangtain: Created page with " sudo mysql -u root CREATE DATABASE mustain; use mustain; CREATE TABLE npm1121040022 ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real ); INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85'); INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85'); INSERT INTO..."

2022-03-02T03:02:09Z

Created page with " sudo mysql -u root CREATE DATABASE mustain; use mustain; CREATE TABLE npm1121040022 ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real ); INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85'); INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85'); INSERT INTO..."

New page

sudo mysql -u root

CREATE DATABASE mustain;

use mustain;

CREATE TABLE npm1121040022 ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');

INSERT INTO npm1121040022(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');

← Older revision		Revision as of 21:04, 2 March 2022
Line 5:		Line 5:
	use mustain;		use mustain;

	CREATE TABLE ~~npm1121040022~~ ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );		CREATE TABLE nilai ( npm char(15), nama char(30), kelas char(10), nilai1 real, nilai2 real, nilai3 real );

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.022','AGUS PUDJIONO','KBS-04.2','85','70','85');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.023','DHAMELIA MARTA SIWI','KBP-04.1','65','60','85');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.028','PERTIWI SARI','KBP-04.1','70','85','90');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.030','NGATINI','KBS-04.2','90','90','85');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.037','NUR BADRIYAH','KBS-04.2','95','90','85');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.039','NUR CAHYO NINGSIH','KBP-04.1','75','75','85');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.043','FITRIANTI','KBS-04.1','65','50','59');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.046','AGUSTINA VIRYANTI','KBS-04.2','80','80','70');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.056','NOVI ASMININGRUM','KBP-04.2','48','50','65');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.060','FRANGKY YOHANES TORAR','KBP-04.1','60','90','50');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.909','EKA MADYAWATI','KBS-04.2','75','70','70');

	INSERT INTO ~~npm1121040022~~(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');		INSERT INTO nilai(npm, nama, kelas, nilai1, nilai2, nilai3) values ('20032.04C.988','NIKMAH WATI','KBS-04.1','75','50','50');

	*Memperlihatkan data yang sudah di input		*Memperlihatkan data yang sudah di input
	SELECT * FROM ~~npm1121040022~~		SELECT * FROM nilai