bicson.lalskomputer.my.id / 127.0.0.1 / idm_b / tbl_so_brankas

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

SELECT * FROM `tbl_so_brankas`

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

Filter rows:

			IdRw	KODE_ADJUST	SALES	KAS_TOKO	RRAK	FISIK	MODAL_KASIR	BON_RRAK	BA_VARIANCE	LAIN_LAIN	RegBy	RegDate
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 249	249	SO1058314	14662748	2000000	0	15665600	1000000	0	0	0	2015390360	2023-08-02 09:14:28
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 250	250	SO6074998	8906244	2500000	0	9005500	1000000	1400000	0	0	2015374200	2023-08-02 19:18:50
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 251	251	SO5834155	31168972	2500000	0	32509500	1000000	200000	0	0	2015390360	2023-08-03 15:24:31
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 252	252	SO2506436	22763250	2000000	0	22790000	2000000	0	106461	0	2015390357	2023-08-03 20:03:30
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 253	253	SO7576798	10453100	2000000	0	11095000	1000000	372000	0	0	2015390360	2023-08-04 09:53:07
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 254	254	SO2366301	18328000	2000000	0	18332000	1000000	150000	0	0	2015374200	2023-08-04 16:32:52
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 255	255	SO1104131	8457800	2000000	0	8458000	1000000	436600	0	0	2015390357	2023-08-05 17:12:39
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 256	256	SO2949057	26903500	2000000	0	25783300	1000000	0	0	0	2015390360	2023-08-05 18:22:41
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 257	257	SO2644855	31579700	2500000	0	33080000	1000000	0	0	0	2015431470	2023-08-07 11:03:23
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 258	258	SO6392992	14671300	2500000	0	13713600	1000000	2119000	0	0	2015390360	2023-08-07 19:07:10
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 259	259	SO5934145	10895025	2000000	0	12395800	500000	0	0	0	2015390360	2023-08-08 09:07:23
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 260	260	SO8820082	5954899	2000000	0	6955899	1000000	0	0	0	2015445313	2023-08-08 16:17:01
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 261	261	SO8465621	12150600	2000000	0	13010000	1000000	0	0	0	2015390357	2023-08-08 16:53:14
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 262	262	SO9174436	15600000	2500000	0	17100000	1000000	0	0	0	2015390360	2023-08-09 10:50:55
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 263	263	SO9759309	15807825	2000000	0	16456000	1000000	380000	0	0	2015374200	2023-08-09 13:47:48
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 264	264	SO8367457	8841000	2000000	0	9841000	1000000	0	0	0	2015390360	2023-08-10 14:03:19
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 265	265	SO8790673	6844000	2000000	0	7844000	1000000	0	0	0	2015431470	2023-08-10 16:27:57
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 266	266	SO3750267	2279000	2000000	0	3279500	1000000	0	0	0	2015374200	2023-08-10 17:31:14
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 267	267	SO2698065	2519000	2000000	0	3519000	1000000	0	0	0	2015431470	2023-08-11 16:28:23
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 268	268	SO7729908	24229000	1000000	0	24412800	1000000	816600	0	0	2015390357	2023-08-11 18:58:16
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 269	269	SO7568581	21861600	2000000	0	22878000	1000000	120000	0	0	2015390360	2023-08-11 18:59:05
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 270	270	SO5787200	5403499	2000000	0	6352300	1000000	52000	0	0	2015431470	2023-08-12 17:07:30
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 271	271	SO6327315	50373000	2000000	0	50908000	750000	715000	0	0	2015390360	2023-08-14 12:48:33
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 272	272	SO3094058	8831900	2000000	0	9831900	1000000	0	0	0	2015431470	2023-08-14 18:07:52
Edit	Copy	Delete DELETE FROM tbl_so_brankas WHERE `tbl_so_brankas`.`IdRw` = 273	273	SO1797772	20708000	2000000	0	21468000	1000000	240	0	0	2015390357	2023-08-14 19:18:57

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view