Recent
`phpmyadmin`.`pma__savedsearches`
`phpmyadmin`.`pma__pdf_pages`
`phpmyadmin`.`pma__history`
`phpmyadmin`.`pma__bookmark`
`phpmyadmin`.`pma__table_coords`
`phpmyadmin`.`pma__designer_settings`
`phpmyadmin`.`pma__table_uiprefs`
`phpmyadmin`.`pma__usergroups`
`phpmyadmin`.`pma__navigationhiding`
`phpmyadmin`.`pma__userconfig`
Favorites
There are no favorite tables.
New
data_bnl
db
db_closing
db_multi_dc
db_rekap
ic
idm_b
information_schema
inv_dc
mysql
new_data_master
performance_schema
phpmyadmin
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.
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: idm_b
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
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
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
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
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
nik
regby
wil
toko
nama_toko
am
as
so_terakhir
p_s
k_so
p_sb1
t_sb1
f_sb1
n_sb1
s_sb1
keter_sb1
p_sb2
t_sb2
f_sb2
n_sb2
s_sb2
keter_sb2
itt
sb_i_nk_m
sb_nk_m
sb_i_nk_p
sb_nk_p
sb_i_nkl
sb_nkl
sr_i_nk_m
sr_nk_m
sr_i_nk_p
sr_nk_p
sr_i_nkl
sr_nkl
kgr
kte
tbr
tco
jmlh_container
irgr
kfb
atk
fkrs
tco1
irtr
gkr
jml_galon
rpc
bbap
sbap
icr
tb
re
cctv
kunci_b
kunci_k
p_router
s_wdcp
k_gps
alarm
dvr
tgs
rs
lb
rak_k
rak_c
rak_s
nk_plu1
nk_plu_desk1
qty_nk1
rp_nk1
ket_nk1
nk_plu2
nk_plu_desk2
qty_nk2
rp_nk2
ket_nk2
nk_plu3
nk_plu_desk3
qty_nk3
rp_nk3
ket_nk3
nk_plu4
nk_plu_desk4
qty_nk4
rp_nk4
ket_nk4
nk_plu5
nk_plu_desk5
qty_nk5
rp_nk5
ket_nk5
nl_plu1
nl_plu_desk1
qty_nl1
rp_nl1
ket_nl1
nl_plu2
nl_plu_desk2
qty_nl2
rp_nl2
ket_nl2
nl_plu3
nl_plu_desk3
qty_nl3
rp_nl3
ket_nl3
nl_plu4
nl_plu_desk4
qty_nl4
rp_nl4
ket_nl4
nl_plu5
nl_plu_desk5
qty_nl5
rp_nl5
ket_nl5
file_sb1
file_sb2
files_nl1
files_nl2
files_nl3
files_nl4
files_nl5
file_gudang_toko
file_ba_sb
item_akurat
item_non_akurat
KODE_ADJUST
tgl
regdate
*
IdRw
LOKASI
KODE_SO
KOR_IC
KOR_DC
JMLH_PRE_ADJUST
FINAL_ITEM_NK
FINAL_SEL_QTY_NK
FINAL_SEL_RP_NK
FINAL_ITEM_NL
FINAL_SEL_QTY_NL
FINAL_SEL_RP_NL
BUKTI_FINAL_ADJUST
RegBy
RegDate
*
IdRw
PLU
DESC
QTY
TOKO
RegDate
*
IdRw
PLU
DESC
QTY
TOKO
RegDate
*
IdRw
PLU
DESC
QTY
TOKO
RegDate
*
IdRw
PLU
DESC
QTY
TOKO
RegDate
*
idRow
KODE_ADJUST
BASO
LHSO1
LHSO2
LHSO3
BA
RegDate
*
IdKaryawan
NIK
Nama
Lok_Kerja
Total_nrb_tolakan
Item_nrb_tolakan
Total_nrb_pro
BULAN
*
id
user_id
method
payload
activity
link
agen
created_at
*
IdToko
KdToko
NamaToko
TglBuka
IdBase
Posko
BBM_KM
JarakPP
FlagAktif
RegDate
*
ID_BA
KD_TOKO
TGL_SO
RP_NKL
PER_NKL
TAGIHAN_DRY
TAGIHAN_BUAH
NIK
NAMA
JAM
JENIS
LOKASI
RegDate
FlagDel
DelBy
DelDate
*
kode_kunjungan
channel_lost
*
IdRw
PLU
DESC
QTY
TOKO
RegDate
*
IdFoto
KD_TOKO
gudang1
gudang2
gudang3
karton1
karton2
karton3
retur1
retur2
retur3
dis_toko1
dis_toko2
dis_toko3
dis_ice1
dis_ice2
dis_ice3
foto_personil
regby
KODE_ADJUST
STATUS_ADM
STATUS_BRANGKAS
STATUS_ADJUST
FLAG_RESET
LOCATION
regdate
*
IdRw
SHOP
TGL_SO
LAST_TGL_SO
KOR_SO
A1
A2
A3
A4
A5
A6
A7
FILE_BA
NO_BA
TGL_BA
RegBy
RegDate
*
IdKondisi
IdKaryawan
gambar_dc
gambar_tkerja
RegDate
*
ID_INV_DC
DIV
PRDCD
DESC
QTY_NKL
RP_NKL
GUDANG
TANGGAL_SO
LOKASI
TAG_FIKTIF
AMBIL_BARANG
NRB_FIKTIF
LEBIH_KIRIM
LAIN
NIK
NAMA
MOTIF
CCTV
BA_KESAKSIAN
BA_PENGAKUAN
HASIL_ADJUST
BUKTI_FOTO
STATUS_LHP
NO_LHP
PENGUNGKAPAN
PERMASALAHAN
SEHARUSNYA
AKIBAT
PENYELESAIAN
BUKTI
RegDate
*
ID_JADWAL
SHOP
TANGGAL
FlagAktif
*
ID_JADWAL
SHOP
TGL
FLAG_DONE
DONE_DATE
FILE_DONE
RegDate
*
SHOP
NRB
TGL_NRB
NO_TTD
NO_MDO
DRIVER
KETERANGAN
FOTO
RegBy
RegDate
*
KODE_SO
NIK
KERTAS_SO
REVISI
*
IdRekap
IdKaryawan
Struk
FlagAudit
TanggalAudit
FlagAktif
Ket_Audit
RegDate
*
IdDetail
IdRekap
IdToko
Tanggal
RegDate
*
SHOP
TGL_SO
KON_RPH
KON_TDK_RPH
LM_SO_K_8
LM_SO_L_8
PRSNL_SO_K_3
PRSNL_SO_L_3
JRK_K_1
JRK_L_1
LUAS_SEDANG
LUAS_BESAR
RAK_K_50
RAK_L_50
ST_K_500
ST_L_500
P_TOK_SB
P_TOK_RTE
P_TOK_RTD
P_TOK_BUAH
P_TOK_POINT
TOK_FRSH
TOK_POINT
TOK_HYBRD
TOK_MTH_STR
SPD_10_25
SPD_25_40
RegDate
*
kode_kunjungan
toko
nama_toko
tgl_kunjungan
nik
nama
merk_cctv
status_dvr
alasan_ta
sejak_ta
ba_ta
no_comp_ta
alasan_rsk
lain_rsk
no_comp_rsk
user_as
password_as
user_acl
password_acl
user_guest
password_guest
user_admin
password_admin
kondisi_hdd
kapasitas_hdd
durasi_awal
durasi_akhir
total_hari
jenis_selisih
selisih_jam_dvr
jmlh_dvr
no_dat_dvr
settingan_rekaman
kondisi_rekaman
jmlh_channel
resolusi
jmlh_channel_lost
tampilan_monitor
posisi_dvr
kerangkeng_dvr
kondisi_dvr
kunci_gembok_dvr
kendala
foto_dvr
foto_kondisi_hdd
foto_kapasitas_hdd
foto_durasi
foto_jmlh_dvr
foto_no_dat_dvr
foto_settingan_rekaman
foto_kondisi_rekaman
foto_jlmh_channel
foto_posisi_dvr
foto_kerangkeng_dvr
foto_kondisi_dvr
RegBy
RegDate
*
ID
Group
Link
URL
Flag_Modal
Icon
RegDate
*
IdLogin
IdKaryawan
username
password
Role
tipe
LastLogin
FlagEnable
StatusLogin
*
IdLogin
IdKaryawan
username
password
Role
Tipe
LastLogin
FlagEnable
StatusLogin
UserAgen
theme
*
IdBase
Base
RegDate
*
IdKaryawan
NIK
Nama
IdBase
Kendaraan
Merk
NoPol
Tujuan
Lok_Kerja
FlagAktif
TelegramID
RegDate
*
IdKaryawan
NIK
Nama
IdBase
Kendaraan
Merk
NoPol
Tujuan
Lok_Kerja
FlagAktif
TelegramID
RegDate
*
IdToko
KdToko
NamaToko
TglBuka
IdBase
Posko
BBM_KM
JarakPP
FlagAktif
RegDate
*
IdMenu
Link
Role
*
IdRow
IdToko
No_NRB
PLU
DESK
QTY
Status
Beban_Ke
Bukti
RegBy
RegDate
*
IdRow
IdToko
No_NRB
TGL_NRB
PLU
DESK
QTY
Jenis_Tolakan
Det_Alasan_Tolakan
PLU2
QTY2
Tgl_Exp
FOTO_FISIK
FOTO_NRB
FOTO_BA
RegBy
Location
RegDate
*
RW_ID
kode_kunjungan
SHOP
TGL
PRDCD
QTY
HASIL
CEK_TYPE
RegBy
RegDate
*
KODE_SO
PRDCD
QTY
RP
KET
PRDCD2
*
KODE_SO
PRDCD
QTY
RP
KET
PRDCD2
*
Id
TOKO
NO_NRB
TGL_NRB
GUDANG
MENU_NRB
REF_NO_NPB
REF_TGL_NPB
REF_QTY_NPB
PRDCD
QTY
GROSS_JUAL
TGL_SO
QTY_SO
Beban_DC
Beban_Toko
RegBy
RegDate
*
IdRw
KODE_SO
NIK_IC
NAMA_IC
STTS
WAKTU
NIK_DC
NAMA_DC
FOTO_KELOMPOK
RegDate
*
IdRw
KODE_SO
Gudang
Jmlh_PIC
Foto_PIC
DC_NIK
DC_NAMA
FILE_BA1
FILE_BA2
FILE_BA3
FILE_BB1
FILE_BB2
FILE_BB3
FILE_BB4
FILE_BB5
FILE_BB6
FILE_BB7
TARGET_SO
ITEM_TITIPAN
DRAFT_SO
PERSIAPAN_SO
MULAI_SO
NO_DRAFT
FLAG_PERSIAPAN
FLAG_PENDAMPINGAN
FLAG_ADJUST
RegBy
RegDate
*
KODE_SO
PRE_ADJUST
ITEM_NK
SEL_QTY_NK
SEL_RP_NK
ITEM_NL
SEL_QTY_NL
SEL_RP_NL
BUKTI
RegDate
*
IdRw
SHOP
PLU
DESC
QTY
EXP
RegDate
*
IdRekap
SHOP
SHIFT
ARMADA
DRIVER
KOLI
NO_TTD
TGL_ST
NO_NRB
FOTO
RegBy
RegDate
*
IdRekap
IdKaryawan
IdToko
Tanggal
FlagAudit
TanggalAudit
FlagAktif
RegDate
*
SHOP
NRB
NO_MDO
DRIVER
KETERANGAN
RegBy
RegDate
*
IdScan
DOCNO
Tanggal
*
DOCNO
TIPE
PLU
DESK
QTY
TGL_EXP
LAST_RETUR
RegBy
RegDate
*
DOCNO
PRDCD
DESC
QTY
*
kode_kunjungan
bt
tanggal_bt
jam_bt
cb
tanggal_cb
jam_cb
stb
tanggal_stb
jam_stb
pt1
tanggal_pt1
jam_pt1
mm
tanggal_mm
jam_mm
cs
tanggal_cs
jam_cs
ts
tanggal_ts
jam_ts
tpjr
tanggal_tpjr
jam_tpjr
bkh1
tanggal_bkh1
jam_bkh1
pbtc
tanggal_pbtc
jam_pbtc
RegDate
*
SHOP
NRB
PLU
DESC
QTY_KURANG
QTY_LEBIH
RegBy
RegDate
*
IdRw
KODE_ADJUST
SALES
KAS_TOKO
RRAK
FISIK
MODAL_KASIR
BON_RRAK
BA_VARIANCE
LAIN_LAIN
RegBy
RegDate
*
RW_ID
SHOP
PRDCD
DESC
LPP
RG_JMLH
RG_TGL_EXP
RG_KONDISI
BK_JMLH
BK_TGL_EXP
BK_KONDISI
LR_JMLH
LR_TGL_EXP
LR_KONDISI
RD_JMLH
RD_TGL_EXP
RD_KONDISI
RegDate
*
RW_ID
SHOP
PRDCD
DESC
PKM
LPP
OVER15
SPD
DSI
TRN_PJG_HR
SELF_LIFE_HR
KRITERIA_ITEM
LOKASI_CEK
LOKASI_EXP
TGL_EXP
KONDISI
QTY
FOTO
RegDate
*
IdSurat
NIK
NAMA
SHOP
DOCNO
KASUS
RegBy
RegDate
*
kode_kunjungan
Temuan
Tanggal
Jam
Channel
Modus
Masalah
PRDCD
DESC
Pelaku
RegDate
*
IdRw
KODE_SO
PLU
ALAMAT
KASUS
ALAMAT_SEBENARNYA
FOTO
RegBy
RegDate
*
KdToko
NamaToko
TGL_NRB
No_NRB
PLU
QTY
PLU2
QTY2
Jenis_Tolakan
Det_Alasan_Tolakan
Tgl_Exp
RegDate
REF
*
ID_JADWAL
SHOP
DESC
TANGGAL
FlagAktif
*
ID_JADWAL
SHOP
WIL
DESC
AS
AM
TGL
FLAG_DONE
DONE_DATE
FILE_DONE
RegDate
*
IdKaryawan
NIK
Nama
IdBaseKaryawan
BaseKaryawan
NoPol
Kendaraan
Tujuan
Merk
*
KODE_SO
NIK
Nama
KERTAS_SO
REVISI
*
TANGGAL
TOTAL_STRUK
FlagAudit
TanggalAudit
Ket_Audit
RegDate
*
SHOP
WIL
DESC
TGL_SO
KONDISI_SO
LAMA_SO
JMLH_PERSONIL
JARAK_SO
TIPE_GUDANG
JMLH_RAK
STOK_TOKO
P_TOK_SB
P_TOK_RTE
P_TOK_RTD
P_TOK_BUAH
P_TOK_POINT
TOK_FRSH
TOK_POINT
TOK_HYBRD
TOK_MTH_STR
SPD_TOKO
*
IdLogin
IdKaryawan
NIK
Nama
username
password
Role
tipe
TelegramID
LastLogin
FlagEnable
StatusLogin
*
IdMenu
ID
Group
Link
URL
Flag_Modal
Icon
Role
*
SHOP
DESC
WIL
B1_KOR
B1_TGL
B1_NL
B1_NK
B1_NKL
B2_KOR
B2_TGL
B2_NKL
B3_KOR
B3_TGL
B3_NKL
B4_KOR
B4_TGL
B4_NKL
*
IdRow
IdToko
KdToko
NamaToko
No_NRB
PLU
DESK
QTY
Status
Beban_Ke
Bukti
RegBy
NIK
Nama
RegDate
*
IdRow
IdToko
KdToko
NamaToko
TGL_NRB
No_NRB
PLU
DESK
QTY
RP
PLU2
desc2
QTY2
RP2
Jenis_Tolakan
Det_Alasan_Tolakan
Tgl_Exp
RegBy
NIK
Nama
FOTO_FISIK
FOTO_NRB
REF
Location
RegDate
*
KODE_SO
PRDCD
DESC
QTY
RP
KET
PRDCD2
DESC2
*
KODE_SO
PRDCD
DESC
QTY
RP
KET
PRDCD2
DESC2
*
Id
TOKO
NO_NRB
TGL_NRB
GUDANG
MENU_NRB
REF_NO_NPB
REF_TGL_NPB
REF_QTY_NPB
PRDCD
QTY
GROSS_JUAL
TGL_SO
QTY_SO
Beban_DC
Beban_Toko
RegBy
RegDate
SINGKAT
*
IdRw
KODE_SO
NIK_IC
NAMA_IC
STTS
WAKTU
NIK_DC
NAMA_DC
FOTO_KELOMPOK
RegDate
Gudang
FLAG_PERSIAPAN
FLAG_PENDAMPINGAN
FLAG_ADJUST
TGL_SO
KOR_SO
*
SHOP
WIL
DESC
TGL_SO
T_POINT
KRITERIA
JML_PRSNL
*
Posko
*
KdToko
NamaToko
No_NRB
PLU
Jenis_Tolakan
Det_Alasan_Tolakan
PLU2
QTY2
Tgl_Exp
RegDate
REF
*
IdRekap
IdKaryawan
Struk
FlagAudit
Ket_Audit
TanggalAudit
FlagAktif
RegDate
IdDetail
IdToko
Tanggal
*
IdRekap
IdDetail
IdKaryawan
NIK
Nama
IdBaseKaryawan
BaseKaryawan
NoPol
Kendaraan
Tanggal
Tujuan
IdToko
KdToko
NamaToko
IdBaseToko
BaseToko
Posko
Perhitungan
Lintas
Komp_KM
KM_Sebenarnya
TotalJarak
TotalRupiah
FlagAudit
Ket_Audit
TanggalAudit
Struk
Merk
RegDate
SO_TERAKHIR
SO_LALU
FLAG_AUDIT
REF
*
TOKO
DESC
AS
AM
NO_NRB
TGL_NRB
REF_TGL_NPB
REF_NO_NPB
MENU_NRB
ITEM
QTY
GROSS_JUAL
BEBAN_DC_QTY
BEBAN_DC_RP
BEBAN_TOKO_QTY
BEBAN_TOKO_RP
PER_QTY_DC
PER_QTY_TOKO
RegBy
RegDate
*
WIL
SHOP
DESC
NIK
Nama
KODE_ADJUST
SALES
KAS_TOKO
RRAK
TOTAL
FISIK
SELISIH
MODAL_KASIR
BON_RRAK
BA_VARIANCE
LAIN_LAIN
TOTAL_KETSEL
TOTAL_SELISIH
RegDate
*
IdToko
KdToko
NamaToko
TglBuka
IdBaseToko
BaseToko
Posko
BBM_KM
JarakPP
Rupiah
select table
adjust_so_bic
adjust_so_dc
bck_tbl_cukai_rokok
bc_tbl_cukai_rokok3
bc_tbl_cukai_rokok_2
bc_tbl_cukai_rokok_3
bukti_adjust_so_toko
count_nrb_by_user
logs_access
mascek
tbl_ba_pemanggilan
tbl_channel_lost
tbl_cukai_rokok
tbl_foto_kondisi_so
tbl_gagal_so
tbl_gambar_kondisi
tbl_inv_dc
tbl_jadwal_investigasi
tbl_jadwal_inv_nbr
tbl_kedatangan_nrb
tbl_kertas_kerja_revisi_so_dc
tbl_klaim
tbl_klaim_det
tbl_kriteria_so
tbl_kunjungan_cctv
tbl_link
tbl_login
tbl_login_v2
tbl_mas_base
tbl_mas_karyawan
tbl_mas_karyawan_new
tbl_mas_toko
tbl_menu_user
tbl_nrb_pro
tbl_nrb_tolakan
tbl_pareto_cctv
tbl_pareto_nk_so_dc
tbl_pareto_nl_so_dc
tbl_pembebanan_nrb
tbl_pendampingan_so_dc
tbl_persiapan_so_dc
tbl_pre_adjust_so_dc
tbl_regis_toko
tbl_rekap_nrb
tbl_rekap_transport_ic
tbl_retur_rokok
tbl_scan
tbl_scan_bazzar_mpp
tbl_scan_detail
tbl_security_nkl
tbl_selisih_nrb_rokok
tbl_so_brankas
tbl_so_exp_toko
tbl_so_exp_toko_new
tbl_surat_jalan_nrb_tol
tbl_temuan_cctv
tbl_temuan_so_dc
tbv_fisik_regis
tbv_jadwal_investigasi
tbv_jadwal_inv_nbr
tbv_karyawan
tbv_kertas_kerja_revisi_so_dc
tbv_klaim_cair
tbv_kriteria_so
tbv_login
tbv_menu_management
tbv_mon_4x_so
tbv_nrb_pro
tbv_nrb_tolakan
tbv_pareto_nk_so_dc
tbv_pareto_nl_so_dc
tbv_pembebanan_nrb
tbv_pendampingan_so_dc
tbv_penentuan_so
tbv_posko
tbv_regis_nrb_tol
tbv_rekap_transport_ic
tbv_rekap_tr_ic
tbv_resume_pembebanan_nrb
tbv_so_brankas
tbv_toko
.
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
adjust_so_bic
adjust_so_dc
bck_tbl_cukai_rokok
bc_tbl_cukai_rokok3
bc_tbl_cukai_rokok_2
bc_tbl_cukai_rokok_3
bukti_adjust_so_toko
count_nrb_by_user
logs_access
mascek
tbl_ba_pemanggilan
tbl_channel_lost
tbl_cukai_rokok
tbl_foto_kondisi_so
tbl_gagal_so
tbl_gambar_kondisi
tbl_inv_dc
tbl_jadwal_investigasi
tbl_jadwal_inv_nbr
tbl_kedatangan_nrb
tbl_kertas_kerja_revisi_so_dc
tbl_klaim
tbl_klaim_det
tbl_kriteria_so
tbl_kunjungan_cctv
tbl_link
tbl_login
tbl_login_v2
tbl_mas_base
tbl_mas_karyawan
tbl_mas_karyawan_new
tbl_mas_toko
tbl_menu_user
tbl_nrb_pro
tbl_nrb_tolakan
tbl_pareto_cctv
tbl_pareto_nk_so_dc
tbl_pareto_nl_so_dc
tbl_pembebanan_nrb
tbl_pendampingan_so_dc
tbl_persiapan_so_dc
tbl_pre_adjust_so_dc
tbl_regis_toko
tbl_rekap_nrb
tbl_rekap_transport_ic
tbl_retur_rokok
tbl_scan
tbl_scan_bazzar_mpp
tbl_scan_detail
tbl_security_nkl
tbl_selisih_nrb_rokok
tbl_so_brankas
tbl_so_exp_toko
tbl_so_exp_toko_new
tbl_surat_jalan_nrb_tol
tbl_temuan_cctv
tbl_temuan_so_dc
tbv_fisik_regis
tbv_jadwal_investigasi
tbv_jadwal_inv_nbr
tbv_karyawan
tbv_kertas_kerja_revisi_so_dc
tbv_klaim_cair
tbv_kriteria_so
tbv_login
tbv_menu_management
tbv_mon_4x_so
tbv_nrb_pro
tbv_nrb_tolakan
tbv_pareto_nk_so_dc
tbv_pareto_nl_so_dc
tbv_pembebanan_nrb
tbv_pendampingan_so_dc
tbv_penentuan_so
tbv_posko
tbv_regis_nrb_tol
tbv_rekap_transport_ic
tbv_rekap_tr_ic
tbv_resume_pembebanan_nrb
tbv_so_brankas
tbv_toko
.
select column
select table
adjust_so_bic
adjust_so_dc
bck_tbl_cukai_rokok
bc_tbl_cukai_rokok3
bc_tbl_cukai_rokok_2
bc_tbl_cukai_rokok_3
bukti_adjust_so_toko
count_nrb_by_user
logs_access
mascek
tbl_ba_pemanggilan
tbl_channel_lost
tbl_cukai_rokok
tbl_foto_kondisi_so
tbl_gagal_so
tbl_gambar_kondisi
tbl_inv_dc
tbl_jadwal_investigasi
tbl_jadwal_inv_nbr
tbl_kedatangan_nrb
tbl_kertas_kerja_revisi_so_dc
tbl_klaim
tbl_klaim_det
tbl_kriteria_so
tbl_kunjungan_cctv
tbl_link
tbl_login
tbl_login_v2
tbl_mas_base
tbl_mas_karyawan
tbl_mas_karyawan_new
tbl_mas_toko
tbl_menu_user
tbl_nrb_pro
tbl_nrb_tolakan
tbl_pareto_cctv
tbl_pareto_nk_so_dc
tbl_pareto_nl_so_dc
tbl_pembebanan_nrb
tbl_pendampingan_so_dc
tbl_persiapan_so_dc
tbl_pre_adjust_so_dc
tbl_regis_toko
tbl_rekap_nrb
tbl_rekap_transport_ic
tbl_retur_rokok
tbl_scan
tbl_scan_bazzar_mpp
tbl_scan_detail
tbl_security_nkl
tbl_selisih_nrb_rokok
tbl_so_brankas
tbl_so_exp_toko
tbl_so_exp_toko_new
tbl_surat_jalan_nrb_tol
tbl_temuan_cctv
tbl_temuan_so_dc
tbv_fisik_regis
tbv_jadwal_investigasi
tbv_jadwal_inv_nbr
tbv_karyawan
tbv_kertas_kerja_revisi_so_dc
tbv_klaim_cair
tbv_kriteria_so
tbv_login
tbv_menu_management
tbv_mon_4x_so
tbv_nrb_pro
tbv_nrb_tolakan
tbv_pareto_nk_so_dc
tbv_pareto_nl_so_dc
tbv_pembebanan_nrb
tbv_pendampingan_so_dc
tbv_penentuan_so
tbv_posko
tbv_regis_nrb_tol
tbv_rekap_transport_ic
tbv_rekap_tr_ic
tbv_resume_pembebanan_nrb
tbv_so_brankas
tbv_toko
.
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
adjust_so_bic
adjust_so_dc
bck_tbl_cukai_rokok
bc_tbl_cukai_rokok3
bc_tbl_cukai_rokok_2
bc_tbl_cukai_rokok_3
bukti_adjust_so_toko
count_nrb_by_user
logs_access
mascek
tbl_ba_pemanggilan
tbl_channel_lost
tbl_cukai_rokok
tbl_foto_kondisi_so
tbl_gagal_so
tbl_gambar_kondisi
tbl_inv_dc
tbl_jadwal_investigasi
tbl_jadwal_inv_nbr
tbl_kedatangan_nrb
tbl_kertas_kerja_revisi_so_dc
tbl_klaim
tbl_klaim_det
tbl_kriteria_so
tbl_kunjungan_cctv
tbl_link
tbl_login
tbl_login_v2
tbl_mas_base
tbl_mas_karyawan
tbl_mas_karyawan_new
tbl_mas_toko
tbl_menu_user
tbl_nrb_pro
tbl_nrb_tolakan
tbl_pareto_cctv
tbl_pareto_nk_so_dc
tbl_pareto_nl_so_dc
tbl_pembebanan_nrb
tbl_pendampingan_so_dc
tbl_persiapan_so_dc
tbl_pre_adjust_so_dc
tbl_regis_toko
tbl_rekap_nrb
tbl_rekap_transport_ic
tbl_retur_rokok
tbl_scan
tbl_scan_bazzar_mpp
tbl_scan_detail
tbl_security_nkl
tbl_selisih_nrb_rokok
tbl_so_brankas
tbl_so_exp_toko
tbl_so_exp_toko_new
tbl_surat_jalan_nrb_tol
tbl_temuan_cctv
tbl_temuan_so_dc
tbv_fisik_regis
tbv_jadwal_investigasi
tbv_jadwal_inv_nbr
tbv_karyawan
tbv_kertas_kerja_revisi_so_dc
tbv_klaim_cair
tbv_kriteria_so
tbv_login
tbv_menu_management
tbv_mon_4x_so
tbv_nrb_pro
tbv_nrb_tolakan
tbv_pareto_nk_so_dc
tbv_pareto_nl_so_dc
tbv_pembebanan_nrb
tbv_pendampingan_so_dc
tbv_penentuan_so
tbv_posko
tbv_regis_nrb_tol
tbv_rekap_transport_ic
tbv_rekap_tr_ic
tbv_resume_pembebanan_nrb
tbv_so_brankas
tbv_toko
.
select column
select table
adjust_so_bic
adjust_so_dc
bck_tbl_cukai_rokok
bc_tbl_cukai_rokok3
bc_tbl_cukai_rokok_2
bc_tbl_cukai_rokok_3
bukti_adjust_so_toko
count_nrb_by_user
logs_access
mascek
tbl_ba_pemanggilan
tbl_channel_lost
tbl_cukai_rokok
tbl_foto_kondisi_so
tbl_gagal_so
tbl_gambar_kondisi
tbl_inv_dc
tbl_jadwal_investigasi
tbl_jadwal_inv_nbr
tbl_kedatangan_nrb
tbl_kertas_kerja_revisi_so_dc
tbl_klaim
tbl_klaim_det
tbl_kriteria_so
tbl_kunjungan_cctv
tbl_link
tbl_login
tbl_login_v2
tbl_mas_base
tbl_mas_karyawan
tbl_mas_karyawan_new
tbl_mas_toko
tbl_menu_user
tbl_nrb_pro
tbl_nrb_tolakan
tbl_pareto_cctv
tbl_pareto_nk_so_dc
tbl_pareto_nl_so_dc
tbl_pembebanan_nrb
tbl_pendampingan_so_dc
tbl_persiapan_so_dc
tbl_pre_adjust_so_dc
tbl_regis_toko
tbl_rekap_nrb
tbl_rekap_transport_ic
tbl_retur_rokok
tbl_scan
tbl_scan_bazzar_mpp
tbl_scan_detail
tbl_security_nkl
tbl_selisih_nrb_rokok
tbl_so_brankas
tbl_so_exp_toko
tbl_so_exp_toko_new
tbl_surat_jalan_nrb_tol
tbl_temuan_cctv
tbl_temuan_so_dc
tbv_fisik_regis
tbv_jadwal_investigasi
tbv_jadwal_inv_nbr
tbv_karyawan
tbv_kertas_kerja_revisi_so_dc
tbv_klaim_cair
tbv_kriteria_so
tbv_login
tbv_menu_management
tbv_mon_4x_so
tbv_nrb_pro
tbv_nrb_tolakan
tbv_pareto_nk_so_dc
tbv_pareto_nl_so_dc
tbv_pembebanan_nrb
tbv_pendampingan_so_dc
tbv_penentuan_so
tbv_posko
tbv_regis_nrb_tol
tbv_rekap_transport_ic
tbv_rekap_tr_ic
tbv_resume_pembebanan_nrb
tbv_so_brankas
tbv_toko
.
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
adjust_so_bic
adjust_so_dc
bck_tbl_cukai_rokok
bc_tbl_cukai_rokok3
bc_tbl_cukai_rokok_2
bc_tbl_cukai_rokok_3
bukti_adjust_so_toko
count_nrb_by_user
logs_access
mascek
tbl_ba_pemanggilan
tbl_channel_lost
tbl_cukai_rokok
tbl_foto_kondisi_so
tbl_gagal_so
tbl_gambar_kondisi
tbl_inv_dc
tbl_jadwal_investigasi
tbl_jadwal_inv_nbr
tbl_kedatangan_nrb
tbl_kertas_kerja_revisi_so_dc
tbl_klaim
tbl_klaim_det
tbl_kriteria_so
tbl_kunjungan_cctv
tbl_link
tbl_login
tbl_login_v2
tbl_mas_base
tbl_mas_karyawan
tbl_mas_karyawan_new
tbl_mas_toko
tbl_menu_user
tbl_nrb_pro
tbl_nrb_tolakan
tbl_pareto_cctv
tbl_pareto_nk_so_dc
tbl_pareto_nl_so_dc
tbl_pembebanan_nrb
tbl_pendampingan_so_dc
tbl_persiapan_so_dc
tbl_pre_adjust_so_dc
tbl_regis_toko
tbl_rekap_nrb
tbl_rekap_transport_ic
tbl_retur_rokok
tbl_scan
tbl_scan_bazzar_mpp
tbl_scan_detail
tbl_security_nkl
tbl_selisih_nrb_rokok
tbl_so_brankas
tbl_so_exp_toko
tbl_so_exp_toko_new
tbl_surat_jalan_nrb_tol
tbl_temuan_cctv
tbl_temuan_so_dc
tbv_fisik_regis
tbv_jadwal_investigasi
tbv_jadwal_inv_nbr
tbv_karyawan
tbv_kertas_kerja_revisi_so_dc
tbv_klaim_cair
tbv_kriteria_so
tbv_login
tbv_menu_management
tbv_mon_4x_so
tbv_nrb_pro
tbv_nrb_tolakan
tbv_pareto_nk_so_dc
tbv_pareto_nl_so_dc
tbv_pembebanan_nrb
tbv_pendampingan_so_dc
tbv_penentuan_so
tbv_posko
tbv_regis_nrb_tol
tbv_rekap_transport_ic
tbv_rekap_tr_ic
tbv_resume_pembebanan_nrb
tbv_so_brankas
tbv_toko
.
select column
select table
adjust_so_bic
adjust_so_dc
bck_tbl_cukai_rokok
bc_tbl_cukai_rokok3
bc_tbl_cukai_rokok_2
bc_tbl_cukai_rokok_3
bukti_adjust_so_toko
count_nrb_by_user
logs_access
mascek
tbl_ba_pemanggilan
tbl_channel_lost
tbl_cukai_rokok
tbl_foto_kondisi_so
tbl_gagal_so
tbl_gambar_kondisi
tbl_inv_dc
tbl_jadwal_investigasi
tbl_jadwal_inv_nbr
tbl_kedatangan_nrb
tbl_kertas_kerja_revisi_so_dc
tbl_klaim
tbl_klaim_det
tbl_kriteria_so
tbl_kunjungan_cctv
tbl_link
tbl_login
tbl_login_v2
tbl_mas_base
tbl_mas_karyawan
tbl_mas_karyawan_new
tbl_mas_toko
tbl_menu_user
tbl_nrb_pro
tbl_nrb_tolakan
tbl_pareto_cctv
tbl_pareto_nk_so_dc
tbl_pareto_nl_so_dc
tbl_pembebanan_nrb
tbl_pendampingan_so_dc
tbl_persiapan_so_dc
tbl_pre_adjust_so_dc
tbl_regis_toko
tbl_rekap_nrb
tbl_rekap_transport_ic
tbl_retur_rokok
tbl_scan
tbl_scan_bazzar_mpp
tbl_scan_detail
tbl_security_nkl
tbl_selisih_nrb_rokok
tbl_so_brankas
tbl_so_exp_toko
tbl_so_exp_toko_new
tbl_surat_jalan_nrb_tol
tbl_temuan_cctv
tbl_temuan_so_dc
tbv_fisik_regis
tbv_jadwal_investigasi
tbv_jadwal_inv_nbr
tbv_karyawan
tbv_kertas_kerja_revisi_so_dc
tbv_klaim_cair
tbv_kriteria_so
tbv_login
tbv_menu_management
tbv_mon_4x_so
tbv_nrb_pro
tbv_nrb_tolakan
tbv_pareto_nk_so_dc
tbv_pareto_nl_so_dc
tbv_pembebanan_nrb
tbv_pendampingan_so_dc
tbv_penentuan_so
tbv_posko
tbv_regis_nrb_tol
tbv_rekap_transport_ic
tbv_rekap_tr_ic
tbv_resume_pembebanan_nrb
tbv_so_brankas
tbv_toko
.
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
adjust_so_bic
adjust_so_dc
bck_tbl_cukai_rokok
bc_tbl_cukai_rokok3
bc_tbl_cukai_rokok_2
bc_tbl_cukai_rokok_3
bukti_adjust_so_toko
count_nrb_by_user
logs_access
mascek
tbl_ba_pemanggilan
tbl_channel_lost
tbl_cukai_rokok
tbl_foto_kondisi_so
tbl_gagal_so
tbl_gambar_kondisi
tbl_inv_dc
tbl_jadwal_investigasi
tbl_jadwal_inv_nbr
tbl_kedatangan_nrb
tbl_kertas_kerja_revisi_so_dc
tbl_klaim
tbl_klaim_det
tbl_kriteria_so
tbl_kunjungan_cctv
tbl_link
tbl_login
tbl_login_v2
tbl_mas_base
tbl_mas_karyawan
tbl_mas_karyawan_new
tbl_mas_toko
tbl_menu_user
tbl_nrb_pro
tbl_nrb_tolakan
tbl_pareto_cctv
tbl_pareto_nk_so_dc
tbl_pareto_nl_so_dc
tbl_pembebanan_nrb
tbl_pendampingan_so_dc
tbl_persiapan_so_dc
tbl_pre_adjust_so_dc
tbl_regis_toko
tbl_rekap_nrb
tbl_rekap_transport_ic
tbl_retur_rokok
tbl_scan
tbl_scan_bazzar_mpp
tbl_scan_detail
tbl_security_nkl
tbl_selisih_nrb_rokok
tbl_so_brankas
tbl_so_exp_toko
tbl_so_exp_toko_new
tbl_surat_jalan_nrb_tol
tbl_temuan_cctv
tbl_temuan_so_dc
tbv_fisik_regis
tbv_jadwal_investigasi
tbv_jadwal_inv_nbr
tbv_karyawan
tbv_kertas_kerja_revisi_so_dc
tbv_klaim_cair
tbv_kriteria_so
tbv_login
tbv_menu_management
tbv_mon_4x_so
tbv_nrb_pro
tbv_nrb_tolakan
tbv_pareto_nk_so_dc
tbv_pareto_nl_so_dc
tbv_pembebanan_nrb
tbv_pendampingan_so_dc
tbv_penentuan_so
tbv_posko
tbv_regis_nrb_tol
tbv_rekap_transport_ic
tbv_rekap_tr_ic
tbv_resume_pembebanan_nrb
tbv_so_brankas
tbv_toko
.
select column