cgc-cabuyao-main.mora-mackarel.ts.net / 127.0.0.1 / dbias_master / payment_enrolled

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 (30214 total, Query took 0.0913 seconds.) [classtypebalance: 0... - 0...]

SELECT * FROM `payment_enrolled` ORDER BY `classtypebalance` DESC

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

Filter rows:

			pay_id	stud_id	stud_name	units	sem	year	course	balance	total	misc	others	ds1	lab	cancel	deducted	ds2	ds3	ds4	ds5	ds6	printed	per_unit	per_lab	total_unit	temp_balance	total_others	transfer_to	other_dis	promo	p_type	class_type	classtypebalance 1
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 11264	11264	19-A-7237	PALAÑA, ESTRAEL A.	25	2nd	2020-2021	BSE	0	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	1st/2021-2022	NULL	Regular	Promo	NULL	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 11520	11520	18-A-6390	DEJUMO, JONADEL M.	23	1st	2021-2022	BSTM	2015	7500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	7500	0	NULL	2nd/2021-2022	NULL	Regular	Regular	Online	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 11776	11776	17-A-4306	SANTIAGO, JAMES RUSSELL A.	29	1st	2021-2022	BSCS	750	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	2nd/2021-2022	NULL	Regular	Promo	Online	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 12032	12032	19-A-7142	AÑAIN, ANNA GRACE A.	26	1st	2021-2022	BTVTED	6943	14443	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	4943	NULL	2nd/2021-2022	NULL	Regular	Promo	Online	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 12288	12288	21-A-9761	FLORDELIZ. MARC KHEIAN L.	26	1st	2021-2022	BSPSYCH	7000	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	2nd/2021-2022	NULL	Regular	Promo	Online	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 13056	13056	19-A-7152	CERVANTES, RIZA	23	1st	2021-2022	BSPSYCH	0	11575	2650	0	NULL	300	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	8625	0	NULL	1st/2022-2023	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 13312	13312	20-A-8171	YTAC, KAREN MAY D.	26	1st	2022-2023	BSCRIMINOLOGY	3000	7500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	7500	0	NULL	2nd/2022-2023	NULL	Regular	Regular	Online	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 13568	13568	21-A-9443	GUERRERO, JOAN V	23	1st	2022-2023	BSE	16000	18000	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	7500	10500	NULL	2nd/2022-2023	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 13824	13824	22-A-10146	RANCES, GRACE O.	26	1st	2022-2023	BSPSYCH	3500	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	2nd/2022-2023	NULL	Regular	Promo	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 14336	14336	22-A-10023	CERVANTES, RUFER ALEXA P.	25	2nd	2022-2023	BSPSYCH	500	10000	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	500	NULL	1st/2023-2024	NULL	Regular	Promo	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 14848	14848	22-A-10298	OLIVA, OLIVER D.	27	2nd	2022-2023	BSCRIMINOLOGY	0	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	1st/2023-2024	NULL	Regular	Promo	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 15360	15360	22-A-10233	FERNANDEZ, VENUS E.	31	1st	2023-2024	BTVTED	0	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	2nd/2023-2024	NULL	Regular	Promo	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 15872	15872	22-A-9949	NAVARRO, DENIVETH C.	24	1st	2023-2024	BSCRIMINOLOGY	0	10500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	10500	0	NULL	2nd/2023-2024	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 16128	16128	23-A-10964	DE LEON, JEN PRINCESS D.	20	1st	2023-2024	BSBA	0	7500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	7500	0	NULL	2nd/2023-2024	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 16384	16384	22-A-10176	BIGCAS, RAIZEN ANGELO P.	24	1st	2023-2024	BSPSYCH	10500	21000	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	10500	10500	NULL	2nd/2023-2024	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 17152	17152	19-A-6698	BUTALID, JUSTIN T.	20	2nd	2023-2024	BSPSYCH	2000	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	1st/2024-2025	NULL	Regular	Promo	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 17408	17408	22-A-10159	ALJECERA, RUSSEL ROYCE E.	20	2nd	2023-2024	BSCS	9500	15500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	10500	5000	NULL	1st/2024-2025	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 17664	17664	23-A-11339	ANIEL, JOHN ALFRED	27	2nd	2023-2024	BSCRIMINOLOGY	500	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	1st/2024-2025	NULL	Regular	Promo	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 17920	17920	21-A-9644	OLIVIO, ANNE ANDREA D.	26	2nd	2023-2024	BSTM	11600	14350	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	4850	NULL	1st/2024-2025	NULL	Regular	Promo	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 18432	18432	24-A-11651	DELOVIO, ARNEL R	23	1st	2024-2025	BSTM	0	11275	2650	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	8625	0	NULL	2nd/2024-2025	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 18688	18688	23-A-10879	DE JESUS, CRIZIA G.	-2	1st	2024-2025	BSPSYCH	0	1200	0	0	NULL	300	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	1500	0	NULL	2nd/2024-2025	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 18944	18944	24-A-11892	LOPEZ, MARCIA KYLA L.	26	1st	2024-2025	BSCRIM	4500	9500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	9500	0	NULL	2nd/2024-2025	NULL	Regular	Promo	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 19200	19200	23-A-10901	BUSTAMANTE, JODRY B.	26	1st	2024-2025	BSCRIMINOLOGY	2000	19500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	10500	9000	NULL	2nd/2024-2025	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 19456	19456	22-A-10226	ESPIRITU, NICO PAULO M.	28	1st	2024-2025	BSCRIMINOLOGY	2001	17001	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	10500	6501	NULL	2nd/2024-2025	NULL	Regular	Regular	Regular	0
Edit	Copy	Delete DELETE FROM payment_enrolled WHERE `payment_enrolled`.`pay_id` = 19712	19712	24-A-11583	BELHIDA AR-JAY	26	1st	2024-2025	BSPSYCH	0	5500	0	0	NULL	0	NULL	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	5500	0	NULL	2nd/2024-2025	NULL	Regular	Regular	Regular	0

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view