server.tail1f4806.ts.net / 127.0.0.1 / candyold / siswa

There are no favorite tables.

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (169 total, Query took 0.0003 seconds.)

SELECT * FROM `siswa`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id_siswa	id_kelas	idpk	nis	no_peserta	nama	level	ruang	sesi	username	password	foto	server	jenis_kelamin	tempat_lahir	tanggal_lahir	agama	kebutuhan_khusus	alamat	rt	rw	dusun	kelurahan	kecamatan	kode_pos	jenis_tinggal	alat_transportasi	hp	email	skhun	no_kps	nama_ayah	tahun_lahir_ayah	pendidikan_ayah	pekerjaan_ayah	penghasilan_ayah	nohp_ayah	nama_ibu	tahun_lahir_ibu	pendidikan_ibu	pekerjaan_ibu	penghasilan_ibu	nohp_ibu	nama_wali	tahun_lahir_wali	pendidikan_wali	pekerjaan_wali	penghasilan_wali	angkatan	nisn	peserta_didik_id	semester_id	rombongan_belajar_id	status	online
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 1	1	X TKR	TKR	2526 10 003	2526 10 003	Agung	X	R1	1	252610003	asat001		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 2	2	X TKR	TKR	2526 10 004	2526 10 004	Anggi Nisfaul Barid	X	R1	1	252610004	asat002		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 3	3	X TKR	TKR	2526 10 025	2526 10 025	Ardiansyah	X	R1	1	252610025	asat003		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 4	4	X TKR	TKR	2526 10 026	2526 10 026	Asep Muhamad Paturahman	X	R1	1	252610026	asat004		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 5	5	X TKR	TKR	2526 10 028	2526 10 028	Dian	X	R1	1	252610028	asat005		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 6	6	X TKR	TKR	2526 10 029	2526 10 029	Dicka Pratama Putra	X	R1	1	252610029	asat006		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 7	7	X TKR	TKR	2526 10 006	2526 10 006	Dimas Nabil Abdul Patah	X	R1	1	252610006	asat007		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 8	8	X TKR	TKR	2526 10 030	2526 10 030	Fardan	X	R1	1	252610030	asat008		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 9	9	X TKR	TKR	2526 10 007	2526 10 007	Ilham	X	R1	1	252610007	asat009		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 10	10	X TKR	TKR	2526 10 008	2526 10 008	Isman Romansyah	X	R1	1	252610008	asat010		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 11	11	X TKR	TKR	2526 10 093	2526 10 093	M. Dadan Rivaldi	X	R1	1	252610093	asat011		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	1
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 12	12	X TKR	TKR	2526 10 096	2526 10 096	M. Hilman Mubarok	X	R1	1	252610096	asat012		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 13	13	X TKR	TKR	2526 10 095	2526 10 095	M. Ikhsan Suhendi	X	R1	1	252610095	asat013		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 14	14	X TKR	TKR	2526 10 010	2526 10 010	M. Rizqi Muiz Nur Alfarizi	X	R1	1	252610010	asat014		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 15	15	X TKR	TKR	2526 10 011	2526 10 011	Maulana Malik Ibrahim	X	R1	1	252610011	asat015		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 16	16	X TKR	TKR	2526 10 034	2526 10 034	Misfahul Fauzi	X	R1	1	252610034	asat016		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 17	17	X TKR	TKR	2526 10 012	2526 10 012	Mohamad Rizal	X	R1	1	252610012	asat017		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 18	18	X TKR	TKR	2526 10 013	2526 10 013	Muhamad Abdul Al-Awaludin	X	R1	1	252610013	asat018		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 19	19	X TKR	TKR	2526 10 035	2526 10 035	Muhamad Aslam	X	R1	1	252610035	asat019		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 20	20	X TKR	TKR	2526 10 036	2526 10 036	Muhamad Ayub Maulana Yusup	X	R1	1	252610036	asat020		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 21	21	X TKR	TKR	2526 10 037	2526 10 037	Muhamad Basit	X	R1	1	252610037	asat021		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 22	22	X TKR	TKR	2526 10 014	2526 10 014	Muhamad Fahri	X	R1	1	252610014	asat022		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 23	23	X TKR	TKR	2526 10 038	2526 10 038	Muhamad Latip	X	R1	1	252610038	asat023		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 24	24	X TKR	TKR	2526 10 016	2526 10 016	Muhamad Pajri	X	R1	1	252610016	asat024		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0
Edit	Copy	Delete DELETE FROM siswa WHERE `siswa`.`id_siswa` = 25	25	X TKR	TKR	2526 10 039	2526 10 039	Muhamad Rijki Murpauji	X	R1	1	252610039	asat025		SR01	NULL		NULL	Islam	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL		NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	aktif	0

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view