Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `inventaris_barang`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts kode_barang nama_barang jml_barang kode_produsen id_merk thn_produksi isbn id_kategori id_jenis
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000001'
BI00000001 SERVER PILAR 1 PD00000001 MI00001 2024 - KI001 JI001
Edit Edit Copy Copy Delete 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 Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000003'
BI00000003 KOMPUTER SERVER (KHANZA) 1 PD00000029 MI00032 2025 KOMPUTER SERVER KI001 JI003
Edit Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000008'
BI00000008 KEYBOARD 30 PD00000031 MI00035 2023 KEYBOARD LOGITECH KI001 JI004
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000009'
BI00000009 MOUSE 30 PD00000031 MI00035 2023 MOUSE LOGITECH KI001 JI004
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000010'
BI00000010 MIKROTIK ROUTERBOARD 1 PD00000033 MI00036 2023 MIKROTIK SERVER KI001 JI005
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000011'
BI00000011 RUIJIE REYEE 2 PD00000033 MI00037 2023 RUIJIE REYEE KI001 JI006
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000012'
BI00000012 ACCESS POINT 2 PD00000033 MI00038 2023 ACCESS POINT RUIJIE KI001 JI006
Edit Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete 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 Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000016'
BI00000016 MOUSE 7 PD00000031 MI00035 2023 MOUSE LOGITECH KI001 JI004
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000017'
BI00000017 KEYBOARD 7 PD00000031 MI00035 2023 KEYBOARD LOGITECH KI001 JI004
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000018'
BI00000018 MONITOR 1 PD00000031 MI00001 2023 MONITOR LENOVO 22" KI001 JI004
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000019'
BI00000019 ACCESS POINT 0 PD00000031 MI00040 2023 ACCESS POINT TENDA KI001 JI008
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000020'
BI00000020 CONNECTOR 1 PD00000031 MI00041 2023 CONNECTOR HDMITOVGA KI001 JI009
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000021'
BI00000021 WEBCAM HD 1080P 1 PD00000034 MI00042 2023 WEBCAM HIKVISION KI001 JI010
Edit Edit Copy Copy Delete 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 Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000023'
BI00000023 KABEL TELEPON 2 PD00000036 MI00043 2023 KABEL TELEPON KI001 JI007
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000024'
BI00000024 TERMINAL RJ11 4 PD00000036 MI00044 2023 TERMINAL RJ 11 KI001 JI007
Edit Edit Copy Copy Delete Delete
DELETE FROM inventaris_barang WHERE `inventaris_barang`.`kode_barang` = 'BI00000025'
BI00000025 HDD 1 TB 1 PD00000031 MI00045 2023 HDD 1TB SEAGATE KI001 JI011
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query