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

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

			ssId	section	course	subject	year	status	sub_id	coursecode	year_entered	room	day	time	units	sem	degree 1	prof	prof_id	max	current	sy	timefrom	timeend	secid
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 4008	4008	3A1-1BSE	BSE	ECONOMICS WITH LRT	3rd	OK	510	ELR 211	2019	TR3	Saturday	NULL	3	1st	NULL	REYNALD JOSEPH B. FONTE	NULL	32	50	2019-2020	5:00 PM	6:00 PM	529
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 3818	3818	3A1-1BSCS*	BSCS	SYSTEM ANALYSIS AND DESIGN	3rd	OK	172	CS 325	2019	NULL		NULL	3	Summer	NULL	NULL	NULL	32	0	2018-2019	NULL	NULL	507
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 748	748	2A1-1TOURISM	TOURISM	RESEARCH METHODOLOGY	2nd	OK	309	RM 101	2014	CHS1	FRIDAY	2:00-5:00PM	3	2nd				NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 506	506	2A1-2OM	OM	ELECTIVE	2nd	OK	303	ELEC 101	2014	TR 1	WEDNESDAY	11:30 - 2:30 PM	3	1st				NULL	NULL	NULL	NULL	NULL	NULL
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` = 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` = 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` = 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` = 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` = 257	257	2A1-1IT	IT	PROJECT DEFENSE	2nd	OK	110	ITPROJECT1	2014	LAB 1	THU	7:00AM-10:00AM	3	3rd	2nd			NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 513	513	2A1-1TOUR	TOURISM	GROUP GAMES	2nd	OK	65	PE 424	2014	GYM	TUESDAY	8:00 - 10:00 AM	2	1st	2nd			NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 769	769	1A1-1OM-BINAN	OM	BUSINESS COMPUTER APPLICATION 2	1st	OK	13	COM 133	2014	LABORATORY 2	THURSDAY	2:00-5:00	3	2nd	2nd	To Be Arrange (TBA)		NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 1025	1025	2A1-1TOUR	TOURISM	BUSINESS STATISTICS	2nd	OK	63	MAT 423	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` = 2049	2049	1A1-2OCTOBERIAN	IT	GYMNASTICS	1st	OK	80	PE 111A	2016	NULL	NULL	NULL	2	1st	2nd	To Be Arrange (TBA)		NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 2561	2561	2A1-1IT	IT	ON-JOB-TRAINING	2nd	OK	121	OJT	2016	NULL	NULL	NULL	6	3rd	2nd	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 2817	2817	Modular	IT	PRESENTATION PACKAGE AND INTERNET CONCEPT	4th	OK	86	IT 122	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` = 3585	3585	2A1-1OM+	OM	TOTAL QUALITY MANAGEMENT	2nd	OK	29	MGT 520	2018			NULL	3	2nd	2nd		NULL	40	32	2018-2019	10:13:00 PM	10:13:00 PM	495
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 6401	6401	1A1-1NEWACT	ACT	National Service Training Program 1 NSTP 111	1st	OK	1861	NSTP 111	2023	NULL	NULL	NULL	3	1st	2nd	NULL	NULL	32	52	2023-2024	NULL	NULL	846
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 7169	7169	2A1-1ACT	ACT	Discrete Structure	2nd	OK	1878	DS 211	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` = 258	258	2A1-2IT	IT	PROJECT DEFENSE	2nd	OK	110	ITPROJECT1	2014	LAB 1	THU	10:00AM/1:00PM	3	3rd	2nd			NULL	NULL	NULL	NULL	NULL	NULL
Edit	Copy	Delete DELETE FROM section_subject WHERE `section_subject`.`ssId` = 514	514	2A1-1TOUR	TOURISM	COST CONTROL MANAGEMENT	2nd	OK	71	CCM 101	2014	TR 4	THURSDAY	7:00 - 10:00 AM	3	1st	2nd			NULL	NULL	NULL	NULL	NULL	NULL

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customize browse mode.