bicson.lalskomputer.my.id / 127.0.0.1 / idm_b / adjust_so_bic

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

No bookmarks

Label: Target database: Share this bookmark

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 :

Edit mode
Text fields

Customize edit mode.

Edit mode

Protect binary columns Disallow BLOB and BINARY columns from editing.
Show function fields Display the function fields in edit/insert mode.
Show field types Defines whether or not type fields should be initially displayed in edit/insert mode.
Number of inserted rows How many rows can be inserted at one time.
Foreign key dropdown order Sort order for items in a foreign-key dropdown box; `content` is the referenced data, `id` is the key value.	content-id id-content
Foreign key limit A dropdown will be used if fewer items are present.

Customize text input fields.

Text fields

CHAR columns editing Defines which type of editing controls should be used for CHAR and VARCHAR columns; `input` - allows limiting of input length, `textarea` - allows newlines in columns.
Minimum size for input field Defines the minimum size for input fields generated for CHAR and VARCHAR columns.
Maximum size for input field Defines the maximum size for input fields generated for CHAR and VARCHAR columns.
CHAR textarea columns Number of columns for CHAR/VARCHAR textareas.
CHAR textarea rows Number of rows for CHAR/VARCHAR textareas.
Textarea columns Textarea size (columns) in edit mode, this value will be emphasized for SQL query textareas (*2).
Textarea rows Textarea size (rows) in edit mode, this value will be emphasized for SQL query textareas (*2).
Bigger textarea for LONGTEXT Double size of textarea for LONGTEXT columns.

Column	Type	Value

nik	varchar(10)
regby	varchar(255)
wil	varchar(255)
toko	varchar(255)
nama_toko	varchar(255)
am	varchar(255)
as	varchar(255)
so_terakhir	varchar(50)
p_s	varchar(255)
k_so	varchar(255)
p_sb1	varchar(50)
t_sb1	int(11)
f_sb1	int(11)
n_sb1	int(11)
s_sb1	varchar(50)
keter_sb1	varchar(255)
p_sb2	varchar(255)
t_sb2	int(11)
f_sb2	int(11)
n_sb2	int(11)
s_sb2	int(11)
keter_sb2	varchar(255)
itt	int(11)
sb_i_nk_m	int(11)
sb_nk_m	int(11)
sb_i_nk_p	int(11)
sb_nk_p	int(11)
sb_i_nkl	int(11)
sb_nkl	int(11)
sr_i_nk_m	int(11)
sr_nk_m	int(11)
sr_i_nk_p	int(11)
sr_nk_p	int(11)
sr_i_nkl	int(11)
sr_nkl	int(11)
kgr	varchar(255)
kte	varchar(255)
tbr	varchar(255)
tco	varchar(255)
jmlh_container	int(11)
irgr	varchar(255)
kfb	varchar(255)
atk	varchar(255)
fkrs	varchar(255)
tco1	varchar(255)
irtr	varchar(255)
gkr	varchar(255)
jml_galon	bit(1)
rpc	varchar(255)
bbap	varchar(255)
sbap	varchar(255)
icr	varchar(255)
tb	varchar(255)
re	varchar(255)
cctv	varchar(255)
kunci_b	varchar(255)
kunci_k	varchar(255)
p_router	varchar(255)
s_wdcp	varchar(255)
k_gps	varchar(255)
alarm	varchar(255)
dvr	varchar(255)
tgs	varchar(255)
rs	varchar(255)
lb	varchar(255)
rak_k	varchar(255)
rak_c	varchar(255)
rak_s	varchar(255)
nk_plu1	int(11)
nk_plu_desk1	varchar(255)
qty_nk1	int(11)	0
rp_nk1	int(11)
ket_nk1	varchar(255)
nk_plu2	int(11)
nk_plu_desk2	varchar(255)
qty_nk2	int(11)
rp_nk2	int(11)
ket_nk2	varchar(255)
nk_plu3	int(11)
nk_plu_desk3	varchar(255)
qty_nk3	int(11)
rp_nk3	int(11)
ket_nk3	varchar(255)
nk_plu4	int(11)
nk_plu_desk4	varchar(255)
qty_nk4	int(11)
rp_nk4	int(11)
ket_nk4	varchar(255)
nk_plu5	int(11)
nk_plu_desk5	varchar(255)
qty_nk5	int(11)
rp_nk5	int(11)
ket_nk5	varchar(255)
nl_plu1	int(11)
nl_plu_desk1	varchar(255)
qty_nl1	int(11)
rp_nl1	int(11)
ket_nl1	varchar(255)
nl_plu2	int(11)
nl_plu_desk2	varchar(255)
qty_nl2	int(11)
rp_nl2	int(11)
ket_nl2	varchar(255)
nl_plu3	int(11)
nl_plu_desk3	varchar(255)
qty_nl3	int(11)
rp_nl3	int(11)
ket_nl3	varchar(255)
nl_plu4	int(11)
nl_plu_desk4	varchar(255)
qty_nl4	int(11)
rp_nl4	int(11)
ket_nl4	varchar(255)
nl_plu5	int(11)
nl_plu_desk5	varchar(255)
qty_nl5	int(11)
rp_nl5	int(11)
ket_nl5	varchar(255)
file_sb1	text
file_sb2	text
files_nl1	text
files_nl2	text
files_nl3	text
files_nl4	text
files_nl5	text
file_gudang_toko	text
file_ba_sb	text
item_akurat	int(11)	0
item_non_akurat	int(11)	0
KODE_ADJUST	varchar(255)
tgl	varchar(8)
regdate	datetime	current_timestamp()

Ignore

Column	Type	Value

nik	varchar(10)
regby	varchar(255)
wil	varchar(255)
toko	varchar(255)
nama_toko	varchar(255)
am	varchar(255)
as	varchar(255)
so_terakhir	varchar(50)
p_s	varchar(255)
k_so	varchar(255)
p_sb1	varchar(50)
t_sb1	int(11)
f_sb1	int(11)
n_sb1	int(11)
s_sb1	varchar(50)
keter_sb1	varchar(255)
p_sb2	varchar(255)
t_sb2	int(11)
f_sb2	int(11)
n_sb2	int(11)
s_sb2	int(11)
keter_sb2	varchar(255)
itt	int(11)
sb_i_nk_m	int(11)
sb_nk_m	int(11)
sb_i_nk_p	int(11)
sb_nk_p	int(11)
sb_i_nkl	int(11)
sb_nkl	int(11)
sr_i_nk_m	int(11)
sr_nk_m	int(11)
sr_i_nk_p	int(11)
sr_nk_p	int(11)
sr_i_nkl	int(11)
sr_nkl	int(11)
kgr	varchar(255)
kte	varchar(255)
tbr	varchar(255)
tco	varchar(255)
jmlh_container	int(11)
irgr	varchar(255)
kfb	varchar(255)
atk	varchar(255)
fkrs	varchar(255)
tco1	varchar(255)
irtr	varchar(255)
gkr	varchar(255)
jml_galon	bit(1)
rpc	varchar(255)
bbap	varchar(255)
sbap	varchar(255)
icr	varchar(255)
tb	varchar(255)
re	varchar(255)
cctv	varchar(255)
kunci_b	varchar(255)
kunci_k	varchar(255)
p_router	varchar(255)
s_wdcp	varchar(255)
k_gps	varchar(255)
alarm	varchar(255)
dvr	varchar(255)
tgs	varchar(255)
rs	varchar(255)
lb	varchar(255)
rak_k	varchar(255)
rak_c	varchar(255)
rak_s	varchar(255)
nk_plu1	int(11)
nk_plu_desk1	varchar(255)
qty_nk1	int(11)	0
rp_nk1	int(11)
ket_nk1	varchar(255)
nk_plu2	int(11)
nk_plu_desk2	varchar(255)
qty_nk2	int(11)
rp_nk2	int(11)
ket_nk2	varchar(255)
nk_plu3	int(11)
nk_plu_desk3	varchar(255)
qty_nk3	int(11)
rp_nk3	int(11)
ket_nk3	varchar(255)
nk_plu4	int(11)
nk_plu_desk4	varchar(255)
qty_nk4	int(11)
rp_nk4	int(11)
ket_nk4	varchar(255)
nk_plu5	int(11)
nk_plu_desk5	varchar(255)
qty_nk5	int(11)
rp_nk5	int(11)
ket_nk5	varchar(255)
nl_plu1	int(11)
nl_plu_desk1	varchar(255)
qty_nl1	int(11)
rp_nl1	int(11)
ket_nl1	varchar(255)
nl_plu2	int(11)
nl_plu_desk2	varchar(255)
qty_nl2	int(11)
rp_nl2	int(11)
ket_nl2	varchar(255)
nl_plu3	int(11)
nl_plu_desk3	varchar(255)
qty_nl3	int(11)
rp_nl3	int(11)
ket_nl3	varchar(255)
nl_plu4	int(11)
nl_plu_desk4	varchar(255)
qty_nl4	int(11)
rp_nl4	int(11)
ket_nl4	varchar(255)
nl_plu5	int(11)
nl_plu_desk5	varchar(255)
qty_nl5	int(11)
rp_nl5	int(11)
ket_nl5	varchar(255)
file_sb1	text
file_sb2	text
files_nl1	text
files_nl2	text
files_nl3	text
files_nl4	text
files_nl5	text
file_gudang_toko	text
file_ba_sb	text
item_akurat	int(11)	0
item_non_akurat	int(11)	0
KODE_ADJUST	varchar(255)
tgl	varchar(8)
regdate	datetime	current_timestamp()

	and then
Use TAB key to move from value to value, or CTRL+arrows to move anywhere.