Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `siswa`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id nis nisn nama_lengkap kelas nama_panggilan jenis_kelamin tempat_lahir tanggal_lahir agama kewarganegaraan anak_ke saudara_kandung saudara_tiri saudara_angkat bahasa_dirumah gol_darah alamat_jalan rt_rw desa_kelurahan kecamatan kabupaten_kota provinsi kode_pos no_telepon bertempat_tinggal_pada jarak_ke_madrasah status_siswa foto
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 2
2 121235090037230001 3117995050 AHMAD HAKIKI NULL HAKIKI L JEMBER 2011-05-03 Islam NULL 1 2 0 0 Indonesia NULL JL. KARANGANYAR KARANGREJO, GUMUKMAS, JEMBER, JAWA... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230001_1791937524.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 3
3 121235090037230002 104165911 AIDA SYAFIRA NULL FIRA P JEMBER NULL Islam NULL 1 2 0 0 Indonesia NULL KARANGREJO KARANGREJO, GUMUKMAS, JEMBER, JAWA TIMU... \ Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230002_1791937792.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 4
4 121235090037230003 102599554 AMIRO CAHYA KAMILA NULL CAHYA P JEMBER 2010-03-21 Islam NULL 2 2 0 0 Indonesia NULL JL. KARANGANYAR KARANGREJO, GUMUKMAS, JEMBER, JAWA... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230003_1793176289.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 5
5 121235090037230004 111021123 ANDRIS ARDIANSYAH ARIFQI NULL ANDIS L JEMBER NULL Islam NULL 1 2 0 0 Indonesia NULL JOMBANG JEMBER JOMBANG, JOMBANG, JEMBER, JAWA TIMU... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230004_1793176363.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 6
6 121235090037230005 118559498 ANGGA MAULANA NULL ANGGA L JEMBER NULL Islam NULL 1 2 0 0 Indonesia NULL karangrejo KARANGREJO, GUMUKMAS, JEMBER, JAWA TIMU... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230005_1793176472.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 7
7 121235090037230006 103739310 AUDIYAH DEFIAN ANANDITA NULL DEFIAN P JEMBER NULL Islam NULL 2 2 0 0 Indonesia NULL Dusun Bendorejo KARANGREJO, GUMUKMAS, JEMBER, JAWA... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230006_1793176569.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 8
8 121235090037230007 106934861 BAGUS SETIAWAN NULL BAGUS L JEMBER 0000-00-00 Islam Indonesia 2 3 0 0 Indonesia karangrejo KARANGREJO, GUMUKMAS, JEMBER, JAWA TIMU... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 9
9 121235090037230008 3111152681 CAMELYA NADYA SHOFWA NULL NADYA P JEMBER 2023-07-17 Islam NULL 1 2 1 0 Indonesia NULL karangrejo KARANGREJO, GUMUKMAS, JEMBER, JAWA TIMU... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230008_1793176692.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 10
10 121235090037230009 107933543 DAVINA DWI AMALIA NULL DAVINA L JEMBER 2010-12-27 Islam NULL 1 2 0 0 Indonesia NULL Dusun Bendoerjo KARANGREJO, GUMUKMAS, JEMBER, JAWA... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230009_1793176781.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 11
11 121235090037230010 115503620 DIFA NOR HAFIZA NULL DIFA P JEMBER 2011-06-04 Islam NULL 3 3 0 0 Indonesia NULL Dusun Karanganyar KARANGREJO, GUMUKMAS, JEMBER, JA... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif siswa_121235090037230010_1793176899.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 12
12 121235090037230011 3117884701 FAHMI AINUL YAQIN NULL FAHMI L JEMBER 2023-07-17 Islam NULL 1 3 0 0 Indonesia NULL karanganyar KARANGREJO, GUMUKMAS, JEMBER, JAWA TIM... Karangrejo Gumukmas Jember NULL NULL NULL NULL Aktif siswa_121235090037230011_1793177005.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 13
13 121235090037230012 3117345951 HUSNUL KHOTIMAH NAYLA AZZURA NULL NAYLA P JEMBER 2011-01-05 Islam NULL 1 2 0 0 Indonesia NULL PULOREJO MENAMPU GUMUKMAS JEMBER MENAMPU, GUMUKMAS... Karangrejo Gumukmas Jember NULL NULL NULL Orang Tua NULL Aktif default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 14
14 121235090037230013 113025816 IMELDA AYU SETYARINI NULL IMEL P JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia Dusun Karanganyar KARANGREJO, GUMUKMAS, JEMBER, JA... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 15
15 121235090037230014 103024973 KEVIN ADITYA SAPUTRA NULL KEVIN L JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia DUSUN KARANGANYAR KARANGREJO, GUMUKMAS, JEMBER, JA... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 16
16 121235090037230015 104378300 LAILATUL NAHARIL HASANAH NULL LAILA P JEMBER 0000-00-00 Islam Indonesia 3 5 0 0 Indonesia Dusun Karanganyar KARANGREJO, GUMUKMAS, JEMBER, JA... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 17
17 121235090037230016 3105529278 M ADITIYA MAULANA NULL ADIT L JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia pulorejo menampu gumukmas jember MENAMPU, GUMUKMAS... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 18
18 121235090037230017 3101992479 M. DAVA ARDIANSYAH FAUZY NULL DAVA L JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia KARANGREJO KARANGREJO, GUMUKMAS, JEMBER, JAWA TIMU... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 19
19 121235090037230018 104350660 MAULIDA PUTRI RAMADINAH NULL NADIN P JEMBER 0000-00-00 Islam Indonesia 1 3 0 0 Indonesia karangrejo KARANGREJO, GUMUKMAS, JEMBER, JAWA TIMU... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 20
20 121235090037230019 3123863529 MAULINA AZIZAH NULL LINA P JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia SUMBERSARI MAYANGAN, GUMUKMAS, JEMBER, JAWA TIMUR,... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 21
21 121235090037230020 119649392 MAULINA FAUZIYAH NULL LINA P JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia JL. KARANGANYAR KARANGREJO, GUMUKMAS, JEMBER, JAWA... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 22
22 121235090037230021 3103043084 MOH. RAFA H. PRATAMA NULL RAFA L JEMBER 0000-00-00 Islam Indonesia 1 0 0 0 Indonesia JL. KARANGANYAR KARANGREJO, GUMUKMAS, JEMBER, JAWA... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 23
23 121235090037230022 104139327 MUHAMMAD ADI PUTRA NULL ADI L JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia Pulorejo MENAMPU, GUMUKMAS, JEMBER, JAWA TIMUR, 68... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 24
24 121235090037230023 107030718 MUHAMMAD ARIF QOMARUDDIN NULL ARIF L JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia Dusun Karanganyar KARANGREJO, GUMUKMAS, JEMBER, JA... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 25
25 121235090037230024 3101766859 MUHAMMAD FARIS AINUR ROHIM NULL FARIS L JEMBER 0000-00-00 Islam Indonesia 1 2 0 0 Indonesia pulorejo menampu gumukmas jember MENAMPU, GUMUKMAS... Jawa Timur default.jpg
Edit Edit Copy Copy Delete Delete
DELETE FROM siswa WHERE `siswa`.`id` = 26
26 121235090037230025 103526386 MUHAMMAD NAFAN ADI PRASTYO NULL NAFAN L JEMBER 0000-00-00 Islam Indonesia 1 3 0 0 Indonesia Desa Karanganyar KARANGREJO, GUMUKMAS, JEMBER, JAW... Jawa Timur default.jpg
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query