Recent
There are no recent tables.
Favorites
There are no favorite tables.
New
candyold
information_schema
mysql
performance_schema
phpmyadmin
rumahsakit
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: candyold
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
Debug SQL
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 :
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id_berita
id_mapel
sesi
ruang
jenis
ikut
susulan
no_susulan
mulai
selesai
nama_proktor
nip_proktor
nama_pengawas
nip_pengawas
catatan
tgl_ujian
*
id_file
id_mapel
nama_file
status_file
*
id_jawaban
id_siswa
id_mapel
id_soal
id_ujian
jawaban
jawabx
jenis
esai
nilai_esai
ragu
*
id_jawaban
id_siswa
id_tugas
jawaban
file
tgl_dikerjakan
tgl_update
nilai
status
*
id_jenis
nama
status
*
jurusan_id
nama_jurusan_sp
kurikulum
jurusan_sp_id
kurikulum_id
sekolah_id
*
id_kelas
level
nama
rombongan_belajar_id
semester_id
*
kode_level
keterangan
rombongan_belajar_id
*
id_log
id_siswa
type
text
date
*
id_mapel
kode
idpk
idguru
nama
jml_soal
jml_esai
tampil_pg
tampil_esai
bobot_pg
bobot_esai
level
opsi
kelas
date
status
kkm
soal_agama
*
kode_mapel
nama_mapel
mata_pelajaran_id
*
id_materi
id_guru
kelas
mapel
judul
materi
file
tgl_mulai
youtube
tgl
status
*
id_nilai
id_ujian
id_mapel
id_siswa
kode_ujian
ujian_mulai
ujian_berlangsung
ujian_selesai
jml_benar
jml_salah
nilai_esai
skor
total
status
ipaddress
hasil
jawaban
jawaban_esai
nilai_esai2
online
id_soal
id_opsi
id_esai
blok
*
id_nilai
id_ujian
id_mapel
id_siswa
kode_ujian
ujian_mulai
ujian_berlangsung
ujian_selesai
jml_benar
jml_salah
nilai_esai
skor
total
status
ipaddress
hasil
jawaban
jawaban_esai
nilai_esai2
online
id_soal
id_opsi
id_esai
blok
*
id_pengawas
nip
nama
jabatan
username
password
level
no_ktp
tempat_lahir
tgl_lahir
jenis_kelamin
agama
no_hp
email
alamat_jalan
rt_rw
dusun
kelurahan
kecamatan
kode_pos
nuptk
bidang_studi
jenis_ptk
tgs_tambahan
status_pegawai
status_aktif
status_nikah
sumber_gaji
ahli_lab
nama_ibu
nama_suami
nik_suami
pekerjaan
tmt
keahlian_isyarat
kewarganegaraan
npwp
foto
ptk_id
password2
ruang
*
id_pengumuman
type
judul
user
text
date
*
id_pk
program_keahlian
jurusan_id
*
jurusan_id
nama_jurusan
untuk_sma
untuk_smk
jenjang_pendidikan_id
*
kode_ruang
keterangan
*
oid
qid
q_option
q_option_match
score
*
qid
question_type
question
description
cid
lid
no_time_served
no_time_corrected
no_time_incorrected
no_time_unattempted
*
semester_id
tahun_ajaran_id
nama_semester
semester
periode_aktif
tanggal_mulai
tanggal_selesai
*
kode_server
nama_server
status
*
kode_sesi
nama_sesi
*
id
session_time
session_hash
*
id_setting
aplikasi
kode_sekolah
sekolah
jenjang
kepsek
nip
alamat
kecamatan
kota
telp
fax
web
email
logo
header
header_kartu
nama_ujian
versi
ip_server
waktu
server
id_server
url_host
token_api
sekolah_id
npsn
db_versi
bc
*
nama_data
data
jumlah
tanggal
status_sinkron
*
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
*
id_soal
id_mapel
nomor
soal
jenis
pilA
pilB
pilC
pilD
pilE
jawaban
file
file1
fileA
fileB
fileC
fileD
fileE
*
id_token
token
time
masa_berlaku
*
id_tugas
id_guru
kelas
mapel
judul
tugas
file
tgl_mulai
tgl_selesai
tgl
status
*
id_ujian
kode_nama
id_pk
id_guru
id_mapel
kode_ujian
nama
jml_soal
jml_esai
bobot_pg
opsi
bobot_esai
tampil_pg
tampil_esai
lama_ujian
tgl_ujian
tgl_selesai
waktu_ujian
selesai_ujian
level
kelas
sesi
acak
token
status
hasil
kkm
ulang
soal_agama
reset
ulang_kkm
btn_selesai
pelanggaran
select table
berita
file_pendukung
jawaban
jawaban_tugas
jenis
jurusan
kelas
level
log
mapel
mata_pelajaran
materi
nilai
nilai_temp
pengawas
pengumuman
pk
referensi_jurusan
ruang
savsoft_options
savsoft_qbank
semester
server
sesi
session
setting
sinkron
siswa
soal
token
tugas
ujian
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
berita
file_pendukung
jawaban
jawaban_tugas
jenis
jurusan
kelas
level
log
mapel
mata_pelajaran
materi
nilai
nilai_temp
pengawas
pengumuman
pk
referensi_jurusan
ruang
savsoft_options
savsoft_qbank
semester
server
sesi
session
setting
sinkron
siswa
soal
token
tugas
ujian
.
select column
select table
berita
file_pendukung
jawaban
jawaban_tugas
jenis
jurusan
kelas
level
log
mapel
mata_pelajaran
materi
nilai
nilai_temp
pengawas
pengumuman
pk
referensi_jurusan
ruang
savsoft_options
savsoft_qbank
semester
server
sesi
session
setting
sinkron
siswa
soal
token
tugas
ujian
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
berita
file_pendukung
jawaban
jawaban_tugas
jenis
jurusan
kelas
level
log
mapel
mata_pelajaran
materi
nilai
nilai_temp
pengawas
pengumuman
pk
referensi_jurusan
ruang
savsoft_options
savsoft_qbank
semester
server
sesi
session
setting
sinkron
siswa
soal
token
tugas
ujian
.
select column
select table
berita
file_pendukung
jawaban
jawaban_tugas
jenis
jurusan
kelas
level
log
mapel
mata_pelajaran
materi
nilai
nilai_temp
pengawas
pengumuman
pk
referensi_jurusan
ruang
savsoft_options
savsoft_qbank
semester
server
sesi
session
setting
sinkron
siswa
soal
token
tugas
ujian
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
berita
file_pendukung
jawaban
jawaban_tugas
jenis
jurusan
kelas
level
log
mapel
mata_pelajaran
materi
nilai
nilai_temp
pengawas
pengumuman
pk
referensi_jurusan
ruang
savsoft_options
savsoft_qbank
semester
server
sesi
session
setting
sinkron
siswa
soal
token
tugas
ujian
.
select column
select table
berita
file_pendukung
jawaban
jawaban_tugas
jenis
jurusan
kelas
level
log
mapel
mata_pelajaran
materi
nilai
nilai_temp
pengawas
pengumuman
pk
referensi_jurusan
ruang
savsoft_options
savsoft_qbank
semester
server
sesi
session
setting
sinkron
siswa
soal
token
tugas
ujian
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
berita
file_pendukung
jawaban
jawaban_tugas
jenis
jurusan
kelas
level
log
mapel
mata_pelajaran
materi
nilai
nilai_temp
pengawas
pengumuman
pk
referensi_jurusan
ruang
savsoft_options
savsoft_qbank
semester
server
sesi
session
setting
sinkron
siswa
soal
token
tugas
ujian
.
select column