bicson.lalskomputer.my.id / 127.0.0.1 / new_data_master / tbl_harian_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 (88169 total, Query took 0.0151 seconds.)

SELECT * FROM `tbl_harian_new`

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

Filter rows:

Sort by key:

			Pos_Flag	Pos_Date	Station	Shift	Time_Start	Time_End	Kasir_Name	Last_No_Sl	Last_No_Rt	Cash_Beg	Cash_Act	Cash_Ref	Sales_Cash	Sales_Ref	Sales_Cr	Sales_Cc	Sales_Vou	Sales_Cou	Sales_Db	SlPlu	AcPlu	Potongan	TtPlu	PPn	S_Count	R_Count	S_Count2	R_Count2	P_Count2	Tmp	Vou_Idm	Kredit_Kop	Sw_Teras	S_14601	R_14601	P_14601	Var_Lns	Vou_Oth	S_BbsPpn	P_BbsPpn	Ambil_Draw	NIK	VAR_PLUS	flag_cafe	KD_TOKO	TGL_HR	rw_num
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098554	C	01-01-2026	2	1	06:55:41	14:32:02	ACHMAD HANAFII MAKATITA	145	0	500000	5470000	0	6180100	0	0	0	0	0	103700	0	0	306703	0	0	0	0	0	0	0	0	0	0	0	0	0	0	16600	0	0	0	0	2015629113	0	N	TZYA_	12-04-2026	16098554
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098555	C	01-01-2026	2	2	15:08:14	22:16:43	PUTRA DIRGAHAYU	90	0	500000	2719000	0	2846150	0	0	0	0	0	39600	0	0	171650	0	0	0	0	0	0	0	0	0	0	0	0	0	0	103650	0	0	0	0	2015683823	0	N	TZYA_	12-04-2026	16098555
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098556	C	01-01-2026	1	1	06:55:25	15:27:04	FRANKLIN JOHANES KEMPA	82	0	500000	3946000	0	4152300	0	0	0	0	0	71300	0	0	216702	0	0	0	0	0	0	0	0	0	0	0	0	0	0	7800	0	0	0	0	2015597466	0	N	TZYA_	12-04-2026	16098556
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098557	C	01-01-2026	1	2	16:02:12	22:43:42	LUTFA APRI SETIAWAN	71	0	500000	3360000	0	3372200	0	0	0	0	0	17300	0	0	122200	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	11300	2015527179	11300	N	TZYA_	12-04-2026	16098557
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098558	C	02-01-2026	2	1	07:08:40	15:02:08	KURNIA SANDY PONTOH	19	0	500000	1050000	0	1057500	0	0	0	0	0	0	0	0	57300	0	0	0	0	0	0	0	0	0	0	0	0	0	0	7500	0	0	0	0	2015685486	0	N	TZYA_	12-04-2026	16098558
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098559	C	02-01-2026	2	2	15:11:17	22:32:38	MUTIYA MAWADDAH HELUTH	98	0	500000	3050000	0	3361680	0	0	0	0	0	233300	0	0	183401	0	0	0	0	0	0	0	0	0	0	0	0	0	0	11680	0	0	0	0	2015681187	0	N	TZYA_	12-04-2026	16098559
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098560	C	02-01-2026	1	1	06:49:55	15:39:47	LUTFA APRI SETIAWAN	101	0	500000	3700000	0	4318950	0	0	0	0	0	269500	0	0	270101	0	0	0	0	0	0	0	0	0	0	0	0	0	0	95450	0	0	0	0	2015527179	0	N	TZYA_	12-04-2026	16098560
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098561	C	02-01-2026	1	2	18:58:17	22:31:05	FRANKLIN JOHANES KEMPA	33	0	500000	1060000	0	1103150	0	0	0	0	0	0	0	0	102900	0	0	0	0	0	0	0	0	0	0	0	0	0	0	15650	0	0	0	0	2015597466	0	N	TZYA_	12-04-2026	16098561
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098562	C	03-01-2026	2	1	06:52:28	14:50:44	MUTIYA MAWADDAH HELUTH	123	0	500000	7084000	0	7160650	0	0	0	0	0	131200	0	0	293000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	26650	0	0	0	0	2015681187	0	N	TZYA_	12-04-2026	16098562
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098563	C	03-01-2026	2	2	15:25:26	22:17:01	ACHMAD HANAFII MAKATITA	92	0	500000	3333000	0	3650820	0	0	0	0	0	140500	0	0	233001	0	0	0	0	0	0	0	0	0	0	0	0	0	0	67820	0	0	0	0	2015629113	0	N	TZYA_	12-04-2026	16098563
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098564	C	03-01-2026	1	1	06:54:54	16:06:48	LUTFA APRI SETIAWAN	37	0	500000	1435000	0	1444760	0	0	0	0	0	158500	0	0	90550	0	0	0	0	0	0	0	0	0	0	0	0	0	0	9760	0	0	0	0	2015527179	0	N	TZYA_	12-04-2026	16098564
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098565	C	03-01-2026	1	2	16:19:47	22:48:15	FRANKLIN JOHANES KEMPA	58	0	500000	2020000	0	2541869	0	0	0	0	0	3800	0	0	247850	0	0	0	0	0	0	0	0	0	0	0	0	0	0	21869	0	0	0	0	2015597466	0	N	TZYA_	12-04-2026	16098565
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098566	C	04-01-2026	2	1	06:59:37	15:31:33	MUTIYA MAWADDAH HELUTH	121	0	500000	3850000	0	3862066	0	0	0	0	0	121100	0	0	293700	0	0	0	0	0	0	0	0	0	0	0	0	0	0	12066	0	0	0	0	2015681187	0	N	TZYA_	12-04-2026	16098566
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098567	C	04-01-2026	2	2	16:18:53	22:34:43	PUTRA DIRGAHAYU	79	0	500000	2955000	0	3142400	0	0	0	0	0	0	0	0	178301	0	0	0	0	0	0	0	0	0	0	0	0	0	0	24900	0	0	0	0	2015683823	0	N	TZYA_	12-04-2026	16098567
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098568	C	04-01-2026	1	1	06:51:43	16:27:17	ACHMAD HANAFII MAKATITA	50	0	500000	925000	0	949000	0	0	0	0	0	81500	0	0	115200	0	0	0	0	0	0	0	0	0	0	0	0	0	0	24000	0	0	0	0	2015629113	0	N	TZYA_	12-04-2026	16098568
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098569	C	04-01-2026	1	2	16:43:24	22:31:01	FRANKLIN JOHANES KEMPA	93	0	500000	2650000	0	2715700	0	0	0	0	0	0	0	0	258101	0	0	0	0	0	0	0	0	0	0	0	0	0	0	15700	0	0	0	0	2015597466	0	N	TZYA_	12-04-2026	16098569
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098570	C	05-01-2026	2	1	07:05:48	15:07:02	ACHMAD HANAFII MAKATITA	151	0	500000	3335000	0	3591507	0	0	0	0	0	139400	0	0	153203	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	93493	2015629113	93493	N	TZYA_	12-04-2026	16098570
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098571	C	05-01-2026	2	2	15:14:59	21:49:47	MUTIYA MAWADDAH HELUTH	151	0	500000	7606000	0	7771600	0	0	0	0	0	65400	0	0	261002	0	0	0	0	0	0	0	0	0	0	0	0	0	0	15600	0	0	0	0	2015681187	0	N	TZYA_	12-04-2026	16098571
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098572	C	05-01-2026	1	1	07:01:34	15:31:06	FRANKLIN JOHANES KEMPA	83	0	500000	2600000	0	2592380	0	0	0	0	0	37200	0	0	130000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	7620	2015597466	7620	N	TZYA_	12-04-2026	16098572
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098573	C	05-01-2026	1	2	15:41:56	22:24:15	LUTFA APRI SETIAWAN	24	0	500000	726000	0	743650	0	0	0	0	0	52300	0	0	15400	0	0	0	0	0	0	0	0	0	0	0	0	0	0	17650	0	0	0	0	2015527179	0	N	TZYA_	12-04-2026	16098573
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098574	C	06-01-2026	2	1	07:13:48	18:23:22	MUTIYA MAWADDAH HELUTH	254	0	500000	12600000	0	13027995	0	0	0	0	0	96800	0	0	466302	0	0	0	0	0	0	0	0	0	0	0	0	0	0	27995	0	0	0	0	2015681187	0	N	TZYA_	12-04-2026	16098574
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098575	C	06-01-2026	2	2	18:25:20	21:58:48	PUTRA DIRGAHAYU	60	0	500000	3113000	0	3140350	0	0	0	0	0	0	0	0	158750	0	0	0	0	0	0	0	0	0	0	0	0	0	0	27350	0	0	0	0	2015683823	0	N	TZYA_	12-04-2026	16098575
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098576	C	06-01-2026	1	1	06:59:40	18:30:28	KURNIA SANDY PONTOH	25	0	500000	720000	0	726700	0	0	0	0	0	0	0	0	21000	0	0	0	0	0	0	0	0	0	0	0	0	0	0	6700	0	0	0	0	2015685486	0	N	TZYA_	12-04-2026	16098576
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098577	C	06-01-2026	1	2	18:32:16	22:25:31	LUTFA APRI SETIAWAN	34	0	500000	1700000	0	1697300	0	0	0	0	0	81000	0	0	132550	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2700	2015527179	2700	N	TZYA_	12-04-2026	16098577
Edit	Copy	Delete DELETE FROM tbl_harian_new WHERE `tbl_harian_new`.`rw_num` = 16098578	C	07-01-2026	2	1	07:08:02	15:03:05	PUTRA DIRGAHAYU	77	0	500000	3101000	0	3127890	0	0	0	0	0	119900	0	0	173951	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	23110	2015683823	23110	N	TZYA_	12-04-2026	16098578

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view