bygrace.example.ngrok.com / 127.0.0.1 / erp_data / ecommerce_order_table

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.

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.

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.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

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

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 :

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

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

			DBID	DBOrderNumber	DBTrackingNumber	DBBatchUpload	DBBatchReleased	DBStatus	DBInventoryNum	DBPrice 1	DBCost	DBUploadedBy	DBDateUpload	DBTimeUpload	DBPreparedBy	DBDatePrepared	DBTimePrepared	DBCheckedBy	DBDateChecked	DBTimeChecked	DBReleasedBy	DBDateReleased	DBTimeReleased	DBReturnedBy	DBDateReturned	DBTimeReturned	DBCancelledBy	DBDateCancelled	DBTimeCancelled	DBPrintedBy	DBDatePrinted	DBTimePrinted	DBCustomer	DBCustomerContact	DBCourier	DBMarketPlace	DBFilterChecker	DBNote	DBPaymentStatus	DBDeductionType	DBSellerNum	DBBranchNum
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 36098	36098	2306235P24VMTE	SPEPH037104524876	UPLOADED_E1BE4E0958	RELEASED_A74D18A879	RELEASED	5806	0	65.00	12	2023-06-24	01:19:46 PM	12	2023-06-24	03:20:59 PM				12	2023-06-24	03:21:04 PM										A******o	******98	SHOPEE EXPRESS	SHOPEE	FMAC		PAID	ON RELEASING	3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 19971	19971	230327GYYYQJ4F	786161576270	UPLOADED_2084EF27150	RELEASED_8F5AD79569	RELEASED	5909	0	500.00	12	2023-03-27	02:21:29 PM	12	2023-03-28	10:01:01 AM				12	2023-03-28	12:23:37 PM										M******A	******10	J&T EXPRESS	SHOPEE	FMAC		PAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 1540	1540	22110476PXXB5E	SPEPH02810481223B	UPLOADED_3C6F39DF176	RELEASED_30C58434373	RELEASED	5815	0	0.00	4	2022-11-07	10:53:27 AM	12	2022-11-07	11:04:21 AM				12	2022-11-07	02:37:26 PM										CARLOS A. BAGALAWIS	******73	SHOPEE EXPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 19206	19206	230320UVW47MK9	SPEPH037012643823	UPLOADED_F6578AE553	RELEASED_14775BE0113	RELEASED	6953	0	37.00	4	2023-03-20	09:41:04 AM	23	2023-03-20	09:44:09 AM				23	2023-03-20	05:45:09 PM										A******S	******45	SHOPEE EXPRESS	SHOPEE	FMAC		PAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 18183	18183	2303090TSYJM9S	SPEPH035339042653	UPLOADED_902FE0A416	RELEASED_73FD5C4D23	RELEASED	5909	0	500.00	4	2023-03-10	09:00:31 AM	23	2023-03-10	10:15:04 AM				23	2023-03-10	05:00:47 PM										M******Y	******20	SHOPEE EXPRESS	SHOPEE	FMAC		PAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 8	8	221029MPC58MHP	221029MPC58MHP	UPLOADED_144415DD1		FOR PREPARING	5815	0	0.00	15	2022-10-31	12:38:03 PM																			ERROL	******47	SHOPEE XPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 1800	1800	221109M8SW4QJB	SPEPH02261516713B	UPLOADED_603BFCD123	RELEASED_A186CC82150	RELEASED	5815	0	0.00	4	2022-11-10	08:30:21 AM	12	2022-11-10	10:10:46 AM				12	2022-11-10	02:34:35 PM										EMMANUEL A. REMOLACIO	******46	SHOPEE EXPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 7945	7945	220923HU1DEVTF	785203497235	UPLOADED_A36E0EE187		FOR PREPARING	F1SLINGBAG	0	0.00	4	2022-12-19	10:45:53 AM																			NORA B. TAN	******82	J&T EXPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 18188	18188	23030918Q3NY4J	SPEPH039110947823	UPLOADED_902FE0A416	RELEASED_73FD5C4D23	RELEASED	5909	0	500.00	4	2023-03-10	09:00:31 AM	23	2023-03-10	10:16:05 AM				23	2023-03-10	05:00:59 PM										S******)	******96	SHOPEE EXPRESS	SHOPEE	FMAC		PAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 21260	21260	2304131KW7W2XM	SPEPH039130373014	UPLOADED_BC010C22139	RELEASED_EC2C9834135	RELEASED	5909	0	500.00	4	2023-04-13	02:58:30 PM	23	2023-04-13	03:03:11 PM				23	2023-04-13	03:19:51 PM										A******O	******95	SHOPEE EXPRESS	SHOPEE	FMAC		PAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 11021	11021	2301113CKW22ST	SPEPH030199775411	UPLOADED_E913085584	RELEASED_BC9049AB55	RELEASED	6953	0	37.00	12	2023-01-12	10:39:23 AM	12	2023-01-13	09:46:14 AM				12	2023-01-13	12:32:55 PM										EL PHIL NATIONAL LINES	******14	SHOPEE EXPRESS	SHOPEE	FMAC		UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 1294	1294	221030Q002YJEQ	OFG120790278233999	UPLOADED_90B8C29785		FOR PREPARING	5815	0	0.00	4	2022-11-05	11:30:22 AM																			LALAINE ROBLES	******88	SHOPEE XPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 4624	4624	2211277GCJP85H	PH223890870494Z	UPLOADED_5BE63FBF4	RELEASED_947451D6222	RELEASED	5815	0	0.00	4	2022-11-28	08:20:52 AM	12	2022-11-28	11:10:04 AM				12	2022-11-29	11:31:32 AM										MERIELLE BELEN	******06	XDE LOGISTICS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 27153	27153	220913NT2Q5JY3	785162359906	UPLOADED_C0622005143		FOR PREPARING	F1SLINGBAG	0	0.00	4	2023-05-01	11:19:28 AM																			DULRICH B. DAGWAN	******67	J&T EXPRESS	SHOPEE			UNPAID		4	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 27410	27410	220812U8S854N5	SPEPH028985316818	UPLOADED_81022812145		FOR PREPARING	5637	0	0.00	4	2023-05-01	11:24:30 AM																			MARC BRYAN S. OBONG	******85	SHOPEE EXPRESS	SHOPEE			UNPAID		4	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 37654	37654	230707AEMMD976	SPEPH035432592467	UPLOADED_D248BBBF41	RELEASED_ED7A2ED66	RELEASED	6953	0	37.00	12	2023-07-07	08:39:56 AM	12	2023-07-07	08:43:27 AM				12	2023-07-07	12:05:05 PM										D******A	******62	SHOPEE EXPRESS	SHOPEE	FMAC		PAID	ON RELEASING	3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 1303	1303	221030QQYAGM94	OFG120816021139585	UPLOADED_90B8C29785		FOR PREPARING	5815	0	0.00	4	2022-11-05	11:30:22 AM																			NIKKO N. MAROLLANO	******47	SHOPEE XPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 4632	4632	2211288BMM1WHB	SPEPH02290768110B	UPLOADED_5BE63FBF4	RELEASED_72462A71443	RELEASED	5815	0	0.00	4	2022-11-28	08:20:52 AM	12	2022-11-28	09:46:34 AM				12	2022-11-28	02:34:44 PM										DAVE BRUZON	******01	SHOPEE EXPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 4378	4378	2211251RMHKVT2	SPEPH02150125876B	UPLOADED_F09156CD3	RELEASED_1B4E836C75	RELEASED	5815	0	0.00	4	2022-11-26	08:07:22 AM	12	2022-11-26	09:05:36 AM				12	2022-11-26	04:06:41 PM										RANDY RAMOS	******00	SHOPEE EXPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 539	539	221101V8YN9GV3	&NBSP	UPLOADED_1AEFAF5A45		FOR PREPARING	5815	0	0.00	12	2022-11-02	10:34:48 AM																			DELFIN S. DUAYAO JR.	******93	J&T EXPRESS	SHOPEE			UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 22811	22811	2304253BQM481R	786295027681	UPLOADED_14D1EFD335	RELEASED_767C4E5081	RELEASED	5806	0	65.00	12	2023-04-26	08:44:21 AM	12	2023-04-26	08:47:42 AM				12	2023-04-26	02:05:43 PM										L******O	******84	J&T EXPRESS	SHOPEE	FMAC		PAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 21021	21021	230411SU9HWVWH	786230746280	UPLOADED_BBBA4B2B158	RELEASED_FB0F0D2B91	RELEASED	5909	0	500.00	4	2023-04-11	05:43:36 PM	12	2023-04-12	10:07:03 AM				12	2023-04-12	02:13:26 PM										E******N	******69	J&T EXPRESS	SHOPEE	FMAC		PAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 37149	37149	230702UXJ4UVYX	786668298890	UPLOADED_60855AE7167	RELEASED_D3DF7F4B92	RELEASED	5806	0	65.00	2	2023-07-03	02:19:00 PM	12	2023-07-04	01:09:30 PM				12	2023-07-04	01:09:32 PM										J******E	******20	J&T EXPRESS	SHOPEE	FMAC		PAID	ON RELEASING	3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 10526	10526	230108RD50Y9WT	785799022042	UPLOADED_AF69870B6	RELEASED_75068FC0105	RELEASED	6953	0	37.00	4	2023-01-09	08:51:55 AM	12	2023-01-09	10:13:14 AM				12	2023-01-09	02:27:59 PM										DELFIN S. DUAYAO JR.	******93	J&T EXPRESS	SHOPEE	FMAC		UNPAID		3	1
Edit	Copy	Delete DELETE FROM `ecommerce_order_table` WHERE `ecommerce_order_table`.`DBID` = 34078	34078	230608TD36DWKD	786541190389	UPLOADED_4FE36EB23	RELEASED_677D19B266	RELEASED	5806	0	65.00	4	2023-06-09	08:31:30 AM	23	2023-06-09	01:03:56 PM				23	2023-06-09	01:04:02 PM										P******r	******79	J&T EXPRESS	SHOPEE	FMAC		PAID	ON RELEASING	3	1

SQL upload ( 0 ) x -