rsgrahayasmine.com / 127.0.0.1 / alzilycutipo2 / databarang

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.

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.

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.

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

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

Press Ctrl+Enter to execute query

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

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

			kode_brng	nama_brng	kode_satbesar	kode_sat	letak_barang	dasar	h_beli	ralan	kelas1	kelas2	kelas3	utama	vip	vvip	beliluar	jualbebas	karyawan	stokminimal	kdjns	isi	kapasitas	expire	status	kode_industri	kode_kategori	kode_golongan	harga_kronis	max_jual
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = ''		MELOXICAM 15 MG	-	TAB		699	699	1048	1048	1048	1048	1048	1048	1048	1048	1048	839	100	JK04	1	15	2022-07-31	0	-	-	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = '-'	-	CHLORAMFENICOL (APOTEK)	TAB	TAB	klorampenikol	771	771	1056	1056	1056	1056	1056	1056	1056	1056	1056	925	10	JK02	1	1	2025-12-12	0	-	K08	G10	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B0000000001'	B0000000001	testing	-	-	-	450000	450000	450000	450000	450000	450000	450000	450000	450000	450000	450000	450000	1	J001	1	1	2022-12-31	1	000	K10	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000001'	B000000001	ABBOTIC SYR 125 60 ML ( ABBOTT)	BTL	BTL	clarithromycin/claritromicin/klaritromisin	197913	197913	275099	275099	275099	275099	255308	275099	275099	275099	255308	245412	3	JK01	1	1	2024-06-14	0	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000002'	B000000002	ACLAM SYR (LAPI)	BTL	BTL	amoxicilin,asam klavulanat, clavulanat	60356	60356	105623	105623	105623	105623	88120	105623	105623	105623	88120	85102	4	JK03	1	1	2027-04-30	1	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000003'	B000000003	ACLAM FORTE SYR ( LAPI )	BTL	BTL	amoxicilin, asam klavulanat, clavulanat	79088	79088	132077	132077	132077	132077	125750	132077	132077	132077	125750	121796	5	JK03	1	1	2027-06-30	1	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000004'	B000000004	FARMABES INJEKSI (BERNOFARM)	BOX	VIA	diltiazem	183150	183150	250916	250916	250916	250916	192308	250916	250916	250916	192308	192308	2	JK01	1	1	2026-03-30	1	-	K20	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000005'	B000000005	ERYRA SIRUP	BTL	BTL	erythromycin, eritromisin	15000	15000	29100	29100	29100	29100	22050	29100	29100	29100	22050	21300	12	JK03	1	1	2026-06-30	1	-	K20	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000006'	B000000006	AMBROXOL 15 MG SYR ( ERELA )	BTL	BTL	ambroxol/ambroksol	4496	4496	11375	11375	11375	11375	8542	11375	11375	11375	8542	8318	220	JK01	1	1	2026-10-10	1	-	K19	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000007'	B000000007	AMBROXOL 30 MG SYR ( ERITA )	BTL	BTL	ambroxol/ambroksol	5775	5775	7796	7796	7796	7796	7796	7796	7796	7796	7796	6930	10	JK01	1	1	2025-12-12	1	-	K19	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000008'	B000000008	AMOXICILLIN 125 MG SYR	BTL	BTL	amoxicilin/amoksisilin	3495	3495	4718	4718	4718	4718	4718	4718	4718	4718	4718	4194	10	JK01	1	1	2024-11-30	0	-	K19	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000009'	B000000009	AMOXICILLIN 250 MG SYR	BTL	BTL	amoxicilin/amoksisilin	11103	11103	14989	14989	14989	14989	14989	14989	14989	14989	14989	13324	10	JK01	1	1	0000-00-00	1	-	K19	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000010'	B000000010	AMOXSAN DROP ( CARPI )	DRP	DRP	amoxicilin/amoksisilin	20513	20513	37436	37436	37436	37436	37436	37436	37436	37436	37436	30769	10	JK03	1	1	2024-10-30	0	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000011'	B000000011	AMOXSAN SYR ( CARPI )	BTL	BTL	amoxicilin/amoksisilin	20513	20513	48206	48206	48206	48206	36103	48206	48206	48206	36103	35077	20	JK06	1	1	2026-03-30	1	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000012'	B000000012	AMOXSAN FORTE SYR ( CARPI )	BTL	BTL	amoxicilin/amoksisilin	29126	29126	60292	60292	60292	60292	45146	60292	60292	60292	45146	43690	18	JK06	1	1	2026-09-30	1	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000013'	B000000013	ANTASIDA SYR ( SANPARINDO )	BTL	BTL	aluminium hidroksida,magnesium hidroksida	4440	4440	10523	10523	10523	10523	8125	10523	10523	10523	8125	7903	150	JK01	1	1	2026-11-01	1	-	K19	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000014'	B000000014	APIALYS SYR ( LAPI )	BTL	BTL	multivitamin/vitamin	33300	33300	75924	75924	75924	75924	55944	75924	75924	75924	55944	54279	45	JK07	1	1	2026-08-30	1	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000015'	B000000015	APIALYS DROP ( LAPI )	DRP	DRP	multivitamin/vitamin	39544	39544	82647	82647	82647	82647	63666	82647	82647	82647	63666	61689	15	JK07	1	1	2026-05-30	1	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000016'	B000000016	ASAM VALPROAT SYR ( DEXA )	BTL	BTL	asam valproat	14800	14800	20276	20276	20276	20276	15540	20276	20276	20276	15540	15540	25	JK01	1	1	2026-07-28	1	-	K19	G12	17294	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000017'	B000000017	ATAROC SYR ( NOVEL )	BTL	BTL	procaterol hcl	38711	38711	71229	71229	71229	71229	65035	71229	71229	71229	65035	63099	60	JK07	1	1	2026-08-30	1	-	K20	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000018'	B000000018	AZTRIN SYR (PHAROS)	BTL	BTL	azitromycin, azitromisin	172494	172494	322564	322564	322564	322564	286340	322564	322564	322564	286340	277715	3	JK04	1	1	2024-10-30	0	-	K09	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000019'	B000000019	AZITROMISIN SYR ( DEXA )	BTL	BTL	azitromycin, azitromisin	36750	36750	97755	97755	97755	97755	80850	97755	97755	97755	80850	79012	7	JK01	1	1	2029-03-30	1	-	K19	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000020'	B000000020	BATUGIN 120 ML (KF)	BTL	BTL	sari daun tempuyung,sari daun kejibeling, batu gin	28916	28916	34988	34988	34988	34988	30362	34988	34988	34988	30362	30362	15	JK02	1	1	2027-03-07	1	-	K20	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000021'	B000000021	BUFECT SYR ( SANBE )	BTL	BTL	ibuprofen	14386	14386	29490	29490	29490	29490	25319	29490	29490	29490	25319	24599	8	JK06	1	1	2026-10-28	1	-	K21	-	0	1000
Edit	Copy	Delete DELETE FROM databarang WHERE `databarang`.`kode_brng` = 'B000000022'	B000000022	BUFECT FORTE SYR ( SANBE )	BTL	BTL	ibuprofen	20113	20113	38014	38014	38014	38014	33790	38014	38014	38014	33790	32785	18	JK06	1	1	2026-09-30	1	-	K21	-	0	1000

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customize browse mode.