www.rsgrahayasmine.com / 127.0.0.1 / alzilycutipo2 / inventaris_barang

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 :

Browse mode

Customize browse mode.

Browse mode

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

Showing rows 0 - 24 (26 total, Query took 0.0009 seconds.)

SELECT * FROM `inventaris_barang`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			kode_barang	nama_barang	jml_barang	kode_produsen	id_merk	thn_produksi	isbn	id_kategori	id_jenis
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000001'	BI00000001	SERVER PILAR	1	PD00000001	MI00001	2024	-	KI001	JI001
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000002'	BI00000002	MESIN ANTRIAN (KIOS Q)	1	PD00000028	MI00003	2025	MESIN ANTRIAN	KI001	JI003
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000003'	BI00000003	KOMPUTER SERVER (KHANZA)	1	PD00000029	MI00032	2025	KOMPUTER SERVER	KI001	JI003
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000004'	BI00000004	ACCESS DOOR	11	PD00000030	MI00033	2023	ACCESS DOOR ZKT X8	KI001	JI003
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000005'	BI00000005	KOMPUTER 1 SET 22 INCHI (Dokter)	19	PD00000031	MI00001	2025	PENGADAAN SET 22"	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000006'	BI00000006	KOMPUTER 1 SET 19 INCHI	11	PD00000031	MI00001	2023	PEREMAJAAN SET 19"	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000007'	BI00000007	CPU MINI	30	PD00000031	MI00034	2023	CPU MINI ATX KARRO	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000008'	BI00000008	KEYBOARD	30	PD00000031	MI00035	2023	KEYBOARD LOGITECH	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000009'	BI00000009	MOUSE	30	PD00000031	MI00035	2023	MOUSE LOGITECH	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000010'	BI00000010	MIKROTIK ROUTERBOARD	1	PD00000033	MI00036	2023	MIKROTIK SERVER	KI001	JI005
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000011'	BI00000011	RUIJIE REYEE	2	PD00000033	MI00037	2023	RUIJIE REYEE	KI001	JI006
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000012'	BI00000012	ACCESS POINT	2	PD00000033	MI00038	2023	ACCESS POINT RUIJIE	KI001	JI006
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000013'	BI00000013	KABEL LAN CAT 5 E	2	PD00000033	MI00039	2023	KABEL LAN CAT 5 E	KI001	JI007
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000014'	BI00000014	CPU MINI	16	PD00000031	MI00034	2023	CPU MINI ATX KARRO	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000015'	BI00000015	KOMPUTER 1 SET 22 INCHI (Dokter)	7	PD00000031	MI00001	2025	KOMPURTER LENOVO 22"	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000016'	BI00000016	MOUSE	7	PD00000031	MI00035	2023	MOUSE LOGITECH	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000017'	BI00000017	KEYBOARD	7	PD00000031	MI00035	2023	KEYBOARD LOGITECH	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000018'	BI00000018	MONITOR	1	PD00000031	MI00001	2023	MONITOR LENOVO 22"	KI001	JI004
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000019'	BI00000019	ACCESS POINT	0	PD00000031	MI00040	2023	ACCESS POINT TENDA	KI001	JI008
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000020'	BI00000020	CONNECTOR	1	PD00000031	MI00041	2023	CONNECTOR HDMITOVGA	KI001	JI009
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000021'	BI00000021	WEBCAM HD 1080P	1	PD00000034	MI00042	2023	WEBCAM HIKVISION	KI001	JI010
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000022'	BI00000022	HUB 5 PORT	2	PD00000031	MI00008	2023	TP-LINK 5 PORT	KI001	JI003
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000023'	BI00000023	KABEL TELEPON	2	PD00000036	MI00043	2023	KABEL TELEPON	KI001	JI007
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000024'	BI00000024	TERMINAL RJ11	4	PD00000036	MI00044	2023	TERMINAL RJ 11	KI001	JI007
Edit	Copy	Delete DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000025'	BI00000025	HDD 1 TB	1	PD00000031	MI00045	2023	HDD 1TB SEAGATE	KI001	JI011

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view