Pengantar Bahasa Query:Tugas 1 - Revision history

Kangtain: Kangtain moved page Materi/Pengantar Bahasa Query/Tugas 1 to Pengantar Bahasa Query:Tugas 1 over redirect

2022-11-19T16:14:05Z

Kangtain moved page Materi/Pengantar Bahasa Query/Tugas 1 to Pengantar Bahasa Query:Tugas 1 over redirect

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

Kangtain at 22:37, 18 November 2022

2022-11-18T22:37:18Z

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

	~~{{DISPLAYTITLE:Tugas 1}}~~
	[[Category:Matkul]]		[[Category:Matkul]]
	[[Category:Materi]]		[[Category:Materi]]
	[[Category:Pengantar Bahasa Query]]		[[Category:Pengantar Bahasa Query]]

Kangtain at 09:36, 16 November 2022

2022-11-16T09:36:23Z

← Older revision		Revision as of 16:36, 16 November 2022
Line 41:		Line 41:

	{{DISPLAYTITLE:Tugas 1}}		{{DISPLAYTITLE:Tugas 1}}
			[[Category:Matkul]]
			[[Category:Materi]]
			[[Category:Pengantar Bahasa Query]]

Kangtain at 10:01, 4 September 2022

2022-09-04T10:01:43Z

← Older revision		Revision as of 17:01, 4 September 2022
Line 40:		Line 40:
	</syntaxhighlight>		</syntaxhighlight>

	{{DISPLAYTITLE:~~Open Database Connectivity~~}}		{{DISPLAYTITLE:Tugas 1}}

Kangtain at 10:01, 4 September 2022

2022-09-04T10:01:13Z

← Older revision		Revision as of 17:01, 4 September 2022
Line 1:		Line 1:
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	CREATE DATABASE mustain_db;		CREATE DATABASE mustain_db;
			</syntaxhighlight>

	~~</syntaxhighlight>~~<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	use mustain_db;		use mustain_db;
			</syntaxhighlight>

	~~</syntaxhighlight>~~<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	CREATE TABLE nama(		CREATE TABLE nama(
	-> npm char(15),		-> npm char(15),
Line 14:		Line 16:
	-> umur real		-> umur real
	-> );		-> );
			</syntaxhighlight>

	~~</syntaxhighlight>~~<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	SHOW TABLES;		SHOW TABLES;
			</syntaxhighlight>

	~~</syntaxhighlight>~~<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
	INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)		INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)
	-> values		-> values
	-> ('625374987','Mustain','Semarang','2000-09-20','S1','22');		-> ('625374987','Mustain','Semarang','2000-09-20','S1','22');
	</syntaxhighlight>Atau<syntaxhighlight lang="sql">		</syntaxhighlight>

			Atau

			<syntaxhighlight lang="sql">
	INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur) -> values -> ('625374987','Dika','Semarang','2000-09-20','S1','22');		INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur) -> values -> ('625374987','Dika','Semarang','2000-09-20','S1','22');
	</syntaxhighlight>Memperlihatkan Field yang sudah di input<syntaxhighlight lang="sql">		</syntaxhighlight>

			Memperlihatkan Field yang sudah di input

			<syntaxhighlight lang="sql">
	SELECT * FROM TKP_Pagi;		SELECT * FROM TKP_Pagi;
	</syntaxhighlight>		</syntaxhighlight>

			{{DISPLAYTITLE:Open Database Connectivity}}

Kangtain: Kangtain moved page Pengantar Bahasa Query:Tugas 1 to Materi/Pengantar Bahasa Query/Tugas 1

2022-09-04T09:46:09Z

Kangtain moved page Pengantar Bahasa Query:Tugas 1 to Materi/Pengantar Bahasa Query/Tugas 1

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

Kangtain at 19:14, 22 August 2022

2022-08-22T19:14:09Z

← Older revision		Revision as of 02:14, 23 August 2022
Line 22:		Line 22:
	-> values		-> values
	-> ('625374987','Mustain','Semarang','2000-09-20','S1','22');		-> ('625374987','Mustain','Semarang','2000-09-20','S1','22');
	</syntaxhighlight>Atau		</syntaxhighlight>Atau<syntaxhighlight lang="sql">
	INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur)		INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur) -> values -> ('625374987','Dika','Semarang','2000-09-20','S1','22');
	-> values		</syntaxhighlight>Memperlihatkan Field yang sudah di input<syntaxhighlight lang="sql">
	-> ('625374987','Dika','Semarang','2000-09-20','S1','22');		SELECT * FROM TKP_Pagi;
			</syntaxhighlight>
	Memperlihatkan Field yang sudah di input
	SELECT * FROM TKP_Pagi;

Kangtain at 19:12, 22 August 2022

2022-08-22T19:12:05Z

← Older revision		Revision as of 02:12, 23 August 2022
Line 1:		Line 1:
	CREATE DATABASE mustain_db;		<syntaxhighlight lang="sql">
			CREATE DATABASE mustain_db;

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

	CREATE TABLE nama(		</syntaxhighlight><syntaxhighlight lang="sql">
	-> npm char(15),		CREATE TABLE nama(
	-> nama char(30),		-> npm char(15),
	-> kota_asal char(20),		-> nama char(30),
	-> tgl_lahir datetime,		-> kota_asal char(20),
	-> jenjang char(2),		-> tgl_lahir datetime,
	-> umur real		-> jenjang char(2),
	-> );		-> umur real
			-> );

	SHOW TABLES;		</syntaxhighlight><syntaxhighlight lang="sql">
			SHOW TABLES;

	INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)		</syntaxhighlight><syntaxhighlight lang="sql">
	-> values		INSERT INTO nama (npm, nama, kota_asal, tgl_lahir, jenjang, umur)
	-> ('625374987','Mustain','Semarang','2000-09-20','S1','22');		-> values
			-> ('625374987','Mustain','Semarang','2000-09-20','S1','22');
	Atau		</syntaxhighlight>Atau
	INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur)		INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur)
	-> values		-> values

Kangtain at 08:53, 2 February 2022

2022-02-02T08:53:50Z

← Older revision		Revision as of 15:53, 2 February 2022
Line 22:		Line 22:
	-> values		-> values
	-> ('625374987','Dika','Semarang','2000-09-20','S1','22');		-> ('625374987','Dika','Semarang','2000-09-20','S1','22');

			Memperlihatkan Field yang sudah di input
			SELECT * FROM TKP_Pagi;

Kangtain at 08:51, 2 February 2022

2022-02-02T08:51:56Z

← Older revision		Revision as of 15:51, 2 February 2022
Line 17:		Line 17:
	-> values		-> values
	-> ('625374987','Mustain','Semarang','2000-09-20','S1','22');		-> ('625374987','Mustain','Semarang','2000-09-20','S1','22');

			Atau
			INSERT INTO TKP_Pagi(NPM, Nama, Kota_Asal, Tanggal_Lahir, Jenjang, Umur)
			-> values
			-> ('625374987','Dika','Semarang','2000-09-20','S1','22');