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

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 (8256 total, Query took 0.0235 seconds.) [timeend: ... - ...]

SELECT * FROM `section_subject` ORDER BY `timeend` ASC

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

Filter rows:

			ssId	section	course	subject	year	status	sub_id	coursecode	year_entered	room	day	time	units	sem	degree	prof	prof_id	max	current	sy	timefrom	timeend 1	secid
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 256	256	2A1-1IT	IT	ON-JOB-TRAINING	2nd	OK	121	OJT	2014				6	3rd	2nd			NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 512	512	2A1-1TOUR	TOURISM	HUMAN RESOURCE MANAGEMENT	2nd	OK	64	MGT 521	2014	TR 4	FRIDAY	4:30 - 7:30 PM	3	1st	2nd			NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 768	768	1A1-1OM-BINAN	OM	ENTREPRENEURSHIP	1st	OK	12	MGT 122	2014	CHS 2	MONDAY	3:30-6:30	3	2nd	2nd	To Be Arrange (TBA)		NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 1024	1024	2A1-1TOUR	TOURISM	ECONOMICS WITH LAND REFORM AND TAXATION	2nd	OK	62	SS 421	2015				3	1st	2nd	To Be Arrange (TBA)		NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 1280	1280	1A1-2BSAT	BSAT	FUNDAMENTALS OF ACCOUNTING	1st	OK	299	ACC 111	2015				6	1st	4th	To Be Arrange (TBA)		NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 1536	1536	3A1-1BSCS	BSCS	AUTOMATA AND LANGUAGE THEORY	3rd	OK	171	CS 324	2015	TR 7 ANNEX	THURS	7:00-10:00PM	3	2nd	4th	To Be Arrange (TBA)	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 1792	1792	3A1-1ENTREP	BSE	SOCIETY AND CULTURE WITH FAMILY PLANNING	3rd	OK	220	SOC 314	2016	NULL	NULL	NULL	3	1st	4th	To Be Arrange (TBA)		NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 2048	2048	1A1-2OCTOBERIAN	IT	NATIONAL SERVICE TRAINING PROGRAM 1	1st	OK	79	NSTP 111	2016	NULL	NULL	NULL	3	1st	2nd	To Be Arrange (TBA)		NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 2304	2304	3A1-1BSAT	BSAT	HUMAN BEHAVIOR IN ORGANIZTION	3rd	OK	278	HBO 321	2016	TR4	THURSDAY	10:00 AM- 1:00 PM	3	2nd	4th	To Be Arrange (TBA)	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 2560	2560	2A1-4TOUR	TOURISM	FOOD AND BEVERAGE	2nd	OK	547	FB 512	2017	NULL	NULL	NULL	3	3rd	2nd	To Be Arrange (TBA)	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 2816	2816	Modular	IT	SPEECH AND ORAL COMMUNICATION	4th	OK	89	ENG 312	2017	NULL	NULL	NULL	3	2nd	2nd	NULL	NULL	32	0	2017-2018	NULL	NULL	409
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 3840	3840	2A1-1BSE*	BSE	Basic Accounting	2nd	OK	1337	ACC 111*	2019	NULL	NULL	NULL	3	1st	4th	NULL	NULL	32	20	2019-2020	NULL	NULL	517
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 4864	4864	3A1-1BSE	BSE	Export Marketing	3rd	OK	1346	FEL 303*	2021	NULL	NULL	NULL	3	1st	4th	NULL	NULL	32	28	2021-2022	NULL	NULL	646
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 5120	5120	3L1-1BSE	BSE	PHILIPPINE GOVERNMENT AND NEW CONSTITUTION	3rd	OK	310	SS 223	2021	NULL	NULL	NULL	3	2nd	4th	NULL	NULL	32	18	2021-2022	NULL	NULL	680
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 5376	5376	2A1-1BSTM	BSTM	Foreign Language 1 (Spanish)	2nd	OK	1396	TRS 201*	2022	NULL	NULL	NULL	3	1st	4th	NULL	NULL	32	28	2022-2023	NULL	NULL	713
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 6144	6144	3A1-1BTVTED	BTVTED	Home Economics Literacy	3rd	OK	1468	TLE 301*	2023	NULL	NULL	NULL	3	1st	4th	NULL	NULL	32	16	2023-2024	NULL	NULL	815
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 6400	6400	1A1-1NEWACT	ACT	Physical Activities Towards Health and Fitness 1 (...	1st	OK	1859	PE 111	2023	NULL	NULL	NULL	2	1st	2nd	NULL	NULL	32	52	2023-2024	NULL	NULL	846
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 6656	6656	1A1-2BSCRIM	BSCRIMINOLOGY	Understanding the Self	1st	OK	1717	SS 128*	2024	NULL	NULL	NULL	3	2nd	4th	NULL	NULL	45	46	2023-2024	NULL	NULL	881
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 6912	6912	2A1-1BSPSYCH	BSPSYCH	Disaster and Mental Health	2nd	OK	1987	FEL 212	2024	NULL	NULL	NULL	3	1st	4th	NULL	NULL	45	47	2024-2025	NULL	NULL	911
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 7168	7168	2A1-1ACT	ACT	Computer Programming 2 (C++)	2nd	OK	1877	CS 204	2024	NULL	NULL	NULL	3	1st	2nd	NULL	NULL	45	24	2024-2025	NULL	NULL	946
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 7424	7424	1A1-1BSBA(FM)	BSBA(FM)	Mathematics in the Modern World	1st	OK	2030	GE112	2024	NULL	NULL	NULL	3	1st	4th	NULL	NULL	45	54	2024-2025	NULL	NULL	977
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 7680	7680	1A1-3BSCS	BSCS	National Service Training Program 2 (CWTS)	1st	OK	1271	NSTP 122*	2024	NULL	NULL	NULL	3	2nd	4th	NULL	NULL	45	29	2024-2025	NULL	NULL	1016
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 7936	7936	Modular	BSTM	PAGBASA AT PAGSULAT TUNGOSA PANANA LIKSIK	4th	OK	531	FIL 122	2025	NULL	NULL	NULL	3	2nd	4th	NULL	NULL	32	0	2024-2025	NULL	NULL	1050
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 8960	8960	1A1-1BSPSYCH	BSPSYCH	Developmental Psychology	1st	OK	2194	PSY 123	2025	NULL	NULL	NULL	3	2nd	4th	NULL	NULL	45	48	2025-2026	NULL	NULL	1188
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 9472	9472	1A1-1BSITM	BSITM	National Service Training Program 1 (CWTS)	1st	OK	2202	NSTP 111	2026	NULL	NULL	NULL	3	1st	4th	NULL	NULL	45	31	2026-2027	NULL	NULL	1259

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view