bicson.lalskomputer.my.id / 127.0.0.1 / new_data_master / tbl_tmp_rinci_rusak_mstxhg

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

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - 24 (89206 total, Query took 0.0453 seconds.)

SELECT * FROM `tbl_tmp_rinci_rusak_mstxhg`

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

Filter rows:

Sort by key:

TGL1	GUDANG	SHOP	DIV	CAT_COD	DOCNO	INVNO	PRDCD	NAMA	QTY	GROSS	KDSB	MENU_RET	NRB_TK	TGL_NRB_TK	COD_RET	FILE	BLN	HIS_BEBAN	REF	REF_REGIC
2025-12-27	G236	TCR7	21	22121	32726	205702	10014263	WIPOL KARBOL WANGI CEMARA PCH 780/750mL	1	15833	PT	KEMASAN	746	2025-12-21	03090000	MSTXHG	12	TCR7	TCR720570210014263	TCR774610014263
2025-12-15	G236	TUQG	9	10909	32486	203615	20116675	CHITATO LITE SNACK POTATO NORI SEAWEED PCK 120g	1	13776	RT	KEMASAN	543	2025-12-11	03090000	MSTXHG	12	TUQG	TUQG20361520116675	TUQG54320116675
2025-12-16	G236	TCR7	22	22222	32530	203914	20076987	BAYGON INSEKTISIDA SPRAY FLOWER GARDEN KLG 225/200...	1	16826	RT	KEMASAN	736	2025-12-13	03090000	MSTXHG	12	TCR7	TCR720391420076987	TCR773620076987
2025-12-16	G236	TW4T	4	10404	32524	203908	20100142	ULTRA TEH KOTAK BLACKCURRANT TPK 300mL	1	2916	RT	KEMASAN	445	2025-12-13	03090000	MSTXHG	12	TW4T	TW4T20390820100142	TW4T44520100142
2025-12-08	G236	TBZF	5	NULL	32397	202214	20040510	NULL	1	9550	RT	KEMASAN	446	2025-12-04	03090000	MSTXHG	12	TBZF	TBZF20221420040510	TBZF44620040510
2025-12-22	G236	TCME	4	NULL	32599	204760	20135975	NULL	1	6096	RT	KEMASAN	1321	2025-12-19	03090000	MSTXHG	12	TCME	TCME20476020135975	TCME132120135975
2025-12-18	G236	TCME	12	11212	32565	204260	20120798	CHO CHO CHOCOLATE JOY SUPER PCK 40g	1	13001	RT	KEMASAN	1309	2025-12-16	03090000	MSTXHG	12	TCME	TCME20426020120798	TCME130920120798
2025-12-26	G236	THOD	21	22121	32684	205397	20053058	KAO ATTACK DETERGENT POWDER JAZ 1 PESONA SEGAR PCK...	1	17350	RT	KEMASAN	659	2025-12-08	03090000	MSTXHG	12	THOD	THOD20539720053058	THOD65920053058
2025-12-15	G236	T6RD	20	22020	32481	203609	20019342	LAURIER PEMBALUT 10'S SLIM GUARD PCK 22.5cm	2	24200	RT	KEMASAN	559	2025-12-10	03090000	MSTXHG	12	T6RD	T6RD20360920019342	T6RD55920019342
2025-12-22	G236	TIZB	12	11212	32609	204779	10000322	CHOKI CHOKI CHOCOLATE PCK 4x10/9g	1	3784	RT	KEMASAN	165	2025-12-15	03090000	MSTXHG	12	TIZB	TIZB20477910000322	TIZB16510000322
2025-12-30	G236	T9NC	9	10909	32769	206126	20016624	STT FRENCH FRIES 2000 PREMIUM PCK 24g	3	10139	RT	KEMASAN	466	2025-12-27	03090000	MSTXHG	12	T9NC	T9NC20612620016624	T9NC46620016624
2025-12-22	G236	TQHC	9	NULL	32588	204724	20084884	NULL	1	12000	RT	KEMASAN	679	2025-12-19	03090000	MSTXHG	12	TQHC	TQHC20472420084884	TQHC67920084884
2025-12-27	G236	TCR7	9	10909	32727	205703	20089256	INDOMARET SNACK KACANG TELUR MEDAN PCK 150g	1	7400	RT	KEMASAN	748	2025-12-21	03090000	MSTXHG	12	TCR7	TCR720570320089256	TCR774820089256
2025-12-22	G236	TIXZ	16	21616	32613	204783	10011850	HEAD &SHOULDERS SHAMPOO A/D MENTHOL DINGIN BTL 160...	1	22350	PT	KEMASAN	212	2025-12-17	03090000	MSTXHG	12	TIXZ	TIXZ20478310011850	TIXZ21210011850
2025-12-22	G236	THOD	11	11111	32598	204759	20065096	GERY CRACKERS MALKIST SALUUT KEJU PCK 110/100g	1	5811	RT	KEMASAN	678	2025-12-19	03090000	MSTXHG	12	THOD	THOD20475920065096	THOD67820065096
2025-12-22	G236	T5H5	11	11111	32601	204771	10001826	KHONG GUAN CRACKERS SALTCHEESE REGULAR PCK 200g	1	7265	RT	KEMASAN	435	2025-12-16	03090000	MSTXHG	12	T5H5	T5H520477110001826	T5H543510001826
2025-12-18	G236	THM9	21	22121	32557	204246	10008104	SO KLIN PEWANGI PAKAIAN REFILL BLUE PCH 900/800mL	1	9387	RT	KEMASAN	727	2025-12-15	03090000	MSTXHG	12	THM9	THM920424610008104	THM972710008104
2025-12-22	G236	TC0Z	8	10808	32626	204852	20084444	SUKSES'S MIE GORENG ISI 2 AYAM KECAP PCK 129g	1	3361	RT	KEMASAN	654	2025-12-17	03090000	MSTXHG	12	TC0Z	TC0Z20485220084444	TC0Z65420084444
2025-12-18	G236	TCME	9	10909	32555	204244	20116112	MAXICORN SNACK BARBECUE PCK 150/140g	1	8730	RT	KEMASAN	1311	2025-12-16	03090000	MSTXHG	12	TCME	TCME20424420116112	TCME131120116112
2025-12-02	G236	TP8T	24	32424	32308	201144	20031232	WHISKAS CAT FOOD TUNA PCK 85/80g	32	169628	RT	KEMASAN	567	2025-11-28	03090000	MSTXHG	12	TP8T	TP8T20114420031232	TP8T56720031232
2025-12-16	G236	TCR7	25	32525	32498	203844	20096977	MY BABY HAIR & BODY WASH BTL 200mL	1	13398	RT	KEMASAN	738	2025-12-13	03090000	MSTXHG	12	TCR7	TCR720384420096977	TCR773820096977
2025-12-16	G236	TCR7	4	10404	32527	203911	20107749	MILKU SUSU UHT STROBERI BTL 200mL	1	2669	RT	KEMASAN	735	2025-12-13	03090000	MSTXHG	12	TCR7	TCR720391120107749	TCR773520107749
2025-12-08	G236	T7ZK	5	10505	32398	202248	20078207	GMP GULA PASIR PCK 1kg	2	25800	RT	KEMASAN	487	2025-12-03	03090000	MSTXHG	12	T7ZK	T7ZK20224820078207	T7ZK48720078207
2025-12-12	G236	TQHC	2	10202	32458	203172	20068905	FRISIAN FLAG SUSU KENTAL MANIS PUTIH PCH 545g	2	33435	PT	KEMASAN	616	2025-11-26	03090000	MSTXHG	12	TQHC	TQHC20317220068905	TQHC61620068905
2025-12-18	G236	TCME	6	10606	32555	204244	20077116	SOVIA MINYAK GORENG PCH 1L	1	13464	RT	KEMASAN	1311	2025-12-16	03090000	MSTXHG	12	TCME	TCME20424420077116	TCME131120077116

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view