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

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 (6036236 total, Query took 0.0071 seconds.)

SELECT * FROM `tbl_sb_new`

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

Filter rows:

			RECID	TIPERAK	NORAK	NOSHELF	KIRIKANAN	DIV	PRDCD	DESC	SINGKAT	BARCODE	BARCODE2	FRAC	UNIT	PTAG	CAT_COD	BKP	SUB_BKP	CTGR	KEMASAN	ACOST	LCOST	RCOST	PRICE	TTL	TTL1	TTL2	TTL_OLD	TTL1_OLD	TTL2_OLD	SALES	SALES_2	RETUR	RETUR_2	CANCEL_S	BPB	BPB_2	BPB_3	ADJ	RETUR_K	COM	HPP	SOID	EDIT	SOTYPE	SOTGL	SOTIME	ADJDT	ADJTIME	DRAFT	DCP	CTK	JAMDLHSO	JAMLHSO	BACABPB	F_NAME	KD_TOKO	TGL_HR	rw_num
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 1		A	2338	1	5	2	10000019	INDOMILK SUSU KENTAL MANIS PUTIH 370g KLG	INDOMILK SKM PTH 370	18992702000015	8992702000018	1	CTN		10201	T	Y	XX	KLG	10843	10843	10843	13500	3	3	0	3	3	0	0	0	0	0	0	0	0	0	0	0	3	10843	L		1	29-10-2025	11:58:39	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	1
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 2		A	2338	1	6	2	10000020	INDOMILK SUSU KENTAL MANIS CHOCOLATE 370g KLG	INDOMILK SKM CHO 370	18993007001646	8992702000063	1	CTN		10201	T	Y	XX	KLG	10843	10843	10843	13500	4	4	0	4	4	0	0	0	0	0	0	0	0	0	0	0	4	10843	L		1	29-10-2025	11:58:35	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	2
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 3		A	2338	1	7	2	10000021	CAP ENAK KENTAL MANIS PUTIH 370g KLG	ENAK K/MNS PUTIH 370	18992702000022	8992702000025	1	CTN		10201	T	Y	XX	KLG	10247	10247	10243	13000	4	4	0	4	4	0	0	0	0	0	0	0	0	0	0	0	4	10247	L		1	29-10-2025	11:58:53	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	3
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 4		A	2257	46	3	11	10000052	AIM CRACKERS CRISPY 150g PCK	AIM CRACK CRISPY 150	18999918457169	8999918181685	1	CTN		11104	T	Y	XX	PCK	6606	6606	6606	11500	6	6	0	6	6	0	0	0	0	0	0	0	0	0	0	0	6	6606	L		1	29-10-2025	13:01:49	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	4
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 5		A	2338	1	3	2	10000088	FRISIAN FLAG SUSU KENTAL MANIS COKLAT 370g KLG	FF SKM CKLT KLG 370	18992753016577	8992753102204	1	CTN		10201	T	Y	XX	KLG	11136	11152	11068	14500	5	5	0	5	5	0	0	0	0	0	0	0	0	0	0	0	5	11136	L		1	29-10-2025	11:59:16	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	5
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 6		A	49407	1	4	24	10000090	ABC BATTERY BIRU R6 4'S	ABC BAT.BIRU R6 4'S	8886022830243	8999801310239	1	CTN		32404	T	Y	XX	PCK	10199	10200	10197	17000	5	5	0	5	5	0	0	0	0	0	0	0	0	0	0	0	5	10199	L		1	29-10-2025	12:59:09	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	6
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 7		A	82611	5	24	15	10000097	CAP KAPAK MINYAK ANGIN 10mL BTL	C/KAPAK MNYK ANGIN10	8888115000144	8994472000038	1	LSN		21502	T	Y	XX	BTL	17539	17755	17539	25500	1	1	0	1	1	0	0	0	0	0	0	0	0	0	0	0	1	17539	L		1	29-10-2025	10:30:14	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	7
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 8		A	82611	7	8	15	10000098	CABE KOYO KECIL 10'S	CABE KOYO KECIL (10)	8993338001011	8993338005033	1	BOX		21501	T	Y	XX	PCK	10750	10750	10750	20000	3	3	0	3	3	0	0	0	0	0	0	0	0	0	0	0	3	10750	L		1	29-10-2025	10:31:04	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	8
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 9		A	2282	4	7	10	10000102	BOTAN MACKAREL 425g KLG	BOTAN MACKEREL 425G	4902931110178		1	CTN		11005	T	Y	XX	KLG	29639	29639	29639	45000	4	4	0	4	4	0	0	0	0	0	0	0	0	0	0	0	4	29639	L		1	29-10-2025	10:53:41	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	9
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 10		A	2257	44	3	11	10000103	REGAL MARIE 230g PCK	REGAL MARIE 230GR	8993039112504	8993039242652	1	CTN	L	11105	T	Y	XX	PCK	17649	17818	17480	29700	4	4	0	4	4	0	0	0	0	0	0	0	0	0	0	0	4	17649	L		1	29-10-2025	11:05:06	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	10
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 11		A	2257	44	1	11	10000104	REGAL MARIE 120g PCK	REGAL MARIE 120GR	8993039111255	8993039242645	1	CTN	S	11105	T	Y	XX	PCK	9552	9595	9120	14000	14	14	0	14	14	0	0	1	0	0	0	0	0	0	0	0	14	9552	L		1	29-10-2025	11:09:37	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	11
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 12		A	30009	4	5	4	10000107	GREEN SANDS ORIGINAL LIME & APPLE 330mL KLG	GREEN SAND ORGNL 330		8997225200044	1	CTN		10407	T	Y	XX	KLG	6164	6164	6164	9400	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	6164	L		1	29-10-2025	13:43:04	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	12
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 13		A	2282	10	17	7	10000116	ABC SAMBAL 335mL BTL	ABC SAMBAL BTL 335ML	0711844120013	18994907001880	1	CTN	T	10706	T	Y	XX	BTL	14731	14847	14731	22600	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	14731	L		1	29-10-2025	13:43:04	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	13
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 14		A	50258	1	3	1	10000128	CERES HAGELSLAG RICE CHOCO CLASSIC 80g PCK	CERES RICE CLASSIC80	8991001301017	98991001103539	1	BOX	T	10108	T	Y	XX	PCK	12140	12236	11754	18900	5	5	0	5	5	0	0	0	0	0	0	0	0	0	0	0	5	12140	L		1	29-10-2025	11:08:19	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	14
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 15		A	50258	1	2	1	10000129	CERES HAGELSLAG RICE CHOCO FESTIVE 80g PCK	CERES RICE FESTIVE80	8991001301024		1	BOX		10108	T	Y	XX	PCK	8978	8978	8978	18900	3	3	0	3	3	0	0	0	0	0	0	0	0	0	0	0	3	8978	L		1	29-10-2025	11:08:11	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	15
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 16		A	2257	42	5	11	10000132	MONDE BISCUIT BUTTER COOKIES 454g KLG	MONDE BT.COOKIES 454	18888166989556	8888166989559	1	CTN		11106	T	Y	XX	KLG	61978	61978	61978	107500	3	3	0	3	3	0	0	0	0	0	0	0	0	0	0	0	3	61978	L		1	29-10-2025	11:05:58	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	16
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 17		A	2257	42	4	11	10000133	KHONG GUAN BISCUIT MINI ASSORTED 650g KLG	KHONG GUAN MN ASS650	18888166603612	8888166603615	1	CTN		11101	T	Y	XX	KLG	49297	49297	49297	70000	2	2	0	2	2	0	0	0	0	0	0	0	0	0	0	0	2	49297	L		1	29-10-2025	11:05:44	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	17
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 18		A	9999	1	6	10	10000135	PRONAS CORNED BEEF 198g KLG	PRONAS CORNED BF.198	18992804000012	8992804119816	1	CTN	J	11003	T	Y	XX	KLG	19974	19974	19974	26900	8	0	8	8	0	8	0	0	0	0	0	0	0	0	0	0	8	19974	L		1	29-10-2025	13:43:04	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	18
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 19		A	2338	3	3	3	10000143	SUN BUBUR SUSU (EKONOMIS) BERAS MERAH 120g PCK	SUN BRS MERAH EKO120	000318	10089686535058	1	CTN		10302	T	Y	XX	PCK	6185	6185	6185	11200	11	11	0	11	11	0	0	0	0	0	0	0	0	0	0	0	11	6185	L		1	29-10-2025	12:01:01	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	19
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 20		A	2338	3	5	3	10000146	SUN BUBUR SUSU (EKONOMIS) KACANG HIJAU 120g PCK	SUN KC HIJAU EKO 120	0896865351506		1	CTN		10302	T	Y	XX	PCK	6185	6185	6185	9200	3	3	0	3	3	0	0	0	0	0	0	0	0	0	0	0	3	6185	L		1	29-10-2025	12:01:05	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	20
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 21		A	82611	4	2	15	10000159	VICKS INHALER OBAT FLU	VICKS INHALER	14987176018233	4987176018083	1	CTN		21504	T	Y	XX	TUB	14390	14390	14390	23500	2	2	0	2	2	0	0	0	0	0	0	0	0	0	0	0	2	14390	L		1	29-10-2025	12:54:26	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	21
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 22		A	2271	1	3	12	10000172	KOPIKO CANDY 105g PCK	KOPIKO CANDY PCK 105	18996001340094	8996001320051	1	CTN		11204	T	Y	XX	PCK	6106	6106	6106	12100	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	6106	L		1	29-10-2025	13:43:04	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	22
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 23		A	2257	27	2	11	10000175	NISSIN WAFER CHOCOLATE 110g PCK	NISSIN WFR CHO 110G	18888166336602	8888166336605	1	CTN		11102	T	Y	XX	PCK	5889	5889	5889	11500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5889	L		1	29-10-2025	13:43:04	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	23
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 24		A	2282	8	6	6	10000181	BIMOLI MINYAK GORENG 5000mL DRG	BIMOLI MINYAK GR. 5L	28992628010133	8992628010139	1	CTN	S	10601	T	Y	XX	DRG	85074	85074	85074	103100	10	2	8	10	2	8	0	0	0	0	0	0	0	0	0	0	10	85074	L		1	29-10-2025	11:02:08	29-10-2025	17:13:13	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	24
Edit	Copy	Delete DELETE FROM tbl_sb_new WHERE `tbl_sb_new`.`rw_num` = 25		A	79115	4	4	8	10000185	INDOMIE MIE INSTANT KARI AYAM 72g PCK	INDOMI KARI AYAM 72G	0089686010190	10089686010524	1	CTN	D	10801	T	Y	XX	PCK	2733	2733	2733	3200	69	29	40	69	29	40	0	0	0	0	0	0	0	0	0	0	76	2733	A		1	29-10-2025	10:45:04	29-10-2025	17:13:15	1	1		29-10-2025 13:43:10	29-10-2025 16:54:46		SB2510	TP8T	29-10-2025	25

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view