perpus.smpn1giri.sch.id / 127.0.0.1 / inlislite_v3 / collections

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize appearance of the 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 tree

Customize the 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

Databases

Databases display options.

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.

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-

Server: 127.0.0.1:3309 »

Database: inlislite_v3 »

Table: collections

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

Browse mode

Customize 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 (2632 total, Query took 0.0061 seconds.)

SELECT * FROM `collections`

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

Filter rows:

Sort by key:

			ID	NomorBarcode	NoInduk	Currency	RFID	PriceType	TanggalPengadaan	CallNumber	Branch_id	Catalog_id	Partner_id	Location_id	Rule_id	Category_id	Media_id	Source_id	Status_id	Location_Library_id	Keterangan_Sumber	CreateBy	CreateDate	CreateTerminal	UpdateBy	UpdateDate	UpdateTerminal	QUARANTINEDBY	QUARANTINEDDATE	QUARANTINEDTERMINAL	ISREFERENSI	EDISISERIAL	NOJILID	TANGGAL_TERBIT_EDISI_SERIAL	BAHAN_SERTAAN	KETERANGAN_LAIN	TGLENTRYJILID	IDJILID	NOMORPANGGILJILID	ISOPAC	JILIDCREATEBY	KIILastUploadDate	BookingMemberID	BookingExpiredDate	IsDeposit	NomorDeposit	ThnTerbitDeposit	deposit_ws_ID	deposit_kode_wilayah_ID	Nomor_Regis
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'5999\'	5999	2022.00002	2022.00002	IDR	2022.00002	Per eksemplar	2022-11-12 00:00:00	823.8 SIR t	37	56	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 09:13:08	180.247.53.203	33	2024-01-11 11:49:02	180.247.52.66	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6000\'	6000	2022.00003	2022.00003	IDR	2022.00003	Per eksemplar	2022-11-12 00:00:00	823.8 SIR t	37	57	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 09:24:54	180.247.53.203	33	2024-01-17 11:40:12	180.247.53.94	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6001\'	6001	2022.00004	2022.00004	IDR	2022.00004	Per eksemplar	2022-11-12 00:00:00	823.8 SIR t	37	58	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 09:28:05	180.247.53.203	33	2023-01-14 10:11:44	180.247.52.236	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6002\'	6002	2022.00005	2022.00005	IDR	2022.00005	Per eksemplar	2022-11-12 00:00:00	823.8 SIR t	37	59	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 09:31:18	180.247.53.203	33	2024-02-13 07:42:41	180.247.53.190	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6003\'	6003	2022.00006	2022.00006	IDR	2022.00006	Per eksemplar	2022-11-12 00:00:00	823.8 SIR m	37	60	1100	466	1	7	2	1	11	1	NULL	33	2023-01-11 09:45:24	180.247.53.203	NULL	2025-09-15 08:41:37	36.73.177.186	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6005\'	6005	2022.00008	2022.00008	IDR	2022.00008	Per eksemplar	2022-11-12 00:00:00	823.8 SIR s	37	61	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:01:33	180.247.53.203	33	2023-12-05 10:48:27	180.247.53.174	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6006\'	6006	2022.00009	2022.00009	IDR	2022.00009	Per eksemplar	2022-11-12 00:00:00	823.8 SIR s	37	62	1098	466	1	1	1	1	1	1	NULL	33	2023-01-11 10:05:40	180.247.53.203	33	2023-01-11 10:05:40	180.247.53.203	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6007\'	6007	2022.00010	2022.00010	IDR	2022.00010	Per eksemplar	2022-11-12 00:00:00	823.8 SIR s	37	63	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:08:01	180.247.53.203	33	2023-06-20 09:15:31	180.247.53.191	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6008\'	6008	2022.00011	2022.00011	IDR	2022.00011	Per eksemplar	2022-11-12 00:00:00	823.8 SIR s	37	64	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:10:29	180.247.53.203	33	2023-08-30 10:32:55	180.247.52.50	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6009\'	6009	2022.00012	2022.00012	IDR	2022.00012	Per eksemplar	2022-11-12 00:00:00	823.087 SIR s	37	65	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:36:55	180.247.53.203	33	2023-01-14 10:15:40	180.247.52.236	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6010\'	6010	2022.00013	2022.00013	IDR	2022.00013	Per eksemplar	2022-11-12 00:00:00	823.087 SIR s	37	66	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:40:03	180.247.53.203	33	2024-02-13 12:02:34	180.247.53.190	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6011\'	6011	2022.00014	2022.00014	IDR	2022.00014	Per eksemplar	2022-11-12 00:00:00	823.087 SIR s	37	67	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:43:03	180.247.53.203	33	2023-01-14 10:17:14	180.247.52.236	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6012\'	6012	2022.00015	2022.00015	IDR	2022.00015	Per eksemplar	2022-11-12 00:00:00	823.087 SIR s	37	68	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:45:30	180.247.53.203	33	2023-01-14 10:18:03	180.247.52.236	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6013\'	6013	2022.00016	2022.00016	IDR	2022.00016	Per eksemplar	2022-11-12 00:00:00	823.087 SIR s	37	69	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:48:19	180.247.53.203	33	2023-01-24 09:51:20	180.247.53.81	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6014\'	6014	2022.00017	2022.00017	IDR	2022.00017	Per eksemplar	2022-11-12 00:00:00	823.087 SIR t	37	70	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:56:18	180.247.53.203	33	2023-01-14 10:19:46	180.247.52.236	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6015\'	6015	2022.00018	2022.00018	IDR	2022.00018	Per eksemplar	2022-11-12 00:00:00	823.087 SIR a	37	71	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 10:58:33	180.247.53.203	33	2023-09-18 10:37:10	180.247.52.103	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6016\'	6016	2022.00019	2022.00019	IDR	2022.00019	Per eksemplar	2022-11-12 00:00:00	823.087 SIR h	37	72	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 11:01:39	180.247.53.203	33	2024-01-13 09:44:52	180.247.52.66	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6017\'	6017	2022.00020	2022.00020	IDR	2022.00020	Per eksemplar	2022-11-12 00:00:00	823.087 SIR t	37	73	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 11:05:33	180.247.53.203	33	2023-08-31 10:12:46	180.247.52.50	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'6018\'	6018	2022.00021	2022.00021	IDR	2022.00021	Per eksemplar	2022-11-12 00:00:00	823.087 SIR t	37	74	1100	466	1	7	2	1	1	1	NULL	33	2023-01-11 11:08:31	180.247.53.203	33	2023-08-08 08:31:36	180.247.52.151	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'9226\'	9226	2022.00029	2022.00029	IDR	2022.00029	Per eksemplar	2022-11-12 00:00:00	398 DAR d	37	84	1100	466	1	7	2	1	1	1	NULL	33	2023-01-18 12:31:36	180.247.52.236	33	2024-01-15 10:09:31	180.247.52.66	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'9227\'	9227	2022.00030	2022.00030	IDR	2022.00030	Per eksemplar	2022-11-12 00:00:00	398 NUN d	37	85	1100	466	1	7	2	1	1	1	NULL	33	2023-01-18 12:33:02	180.247.52.236	33	2023-10-19 07:29:20	180.247.52.179	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'9228\'	9228	2022.00031	2022.00031	IDR	2022.00031	Per eksemplar	2022-11-12 00:00:00	398 DAR k	37	86	1100	466	1	7	2	1	1	1	NULL	33	2023-01-18 12:34:18	180.247.52.236	33	2024-02-12 07:19:33	180.247.53.190	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'9229\'	9229	2022.00032	2022.00032	IDR	2022.00032	Per eksemplar	2022-11-12 00:00:00	398 DAR d	37	87	1100	466	1	7	2	1	1	1	NULL	33	2023-01-18 12:41:35	180.247.52.236	33	2023-01-18 12:41:35	180.247.52.236	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'9230\'	9230	2022.00033	2022.00033	IDR	2022.00033	Per eksemplar	2022-11-12 00:00:00	398 DAR d	37	88	1100	466	1	7	2	1	1	1	NULL	33	2023-01-18 12:45:00	180.247.52.236	33	2023-01-18 12:45:00	180.247.52.236	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM `collections` WHERE CONCAT(`collections`.`ID`) = \'9231\'	9231	2022.00034	2022.00034	IDR	2022.00034	Per eksemplar	2022-11-12 00:00:00	398 DAR c	37	89	1100	466	1	7	2	1	1	1	NULL	33	2023-01-18 12:47:17	180.247.52.236	33	2024-01-19 09:48:18	180.247.53.94	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL

Check all With selected:

Filter rows:

Query results operations

Print view

Export

Display chart

Create view