Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `requirements` ORDER BY `STUD_ID` ASC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ID STUD_ID Ascending Descending 1 FRM CARD PSA GM TWOPIC ONEPIC PNV CLASS REMARKS GRADE STRAND SECTION STATUS FRM_PDF CARD_PDF PSA_PDF GM_PDF TWOPIC_PDF PNV_PDF
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 865
865 OK OK NONE OK NONE NONE NONE FRESHMEN GRADE 11 HE HE 2 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 1082
1082 OK OK OK OK OK OK OK FRESHMEN GRADE 12 ABM ABM 1 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 1314
1314 NONE OK NONE OK NONE NONE OK FRESHMEN GRADE 12 ABM ABM 6 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 1379
1379 OK OK OK OK OK OK NONE FRESHMEN GRADE 12 GAS GAS 1 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 1409
1409 NONE OK OK NONE NONE NONE NONE FRESHMEN GRADE 12 GAS GAS 1 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 1527
1527 OK OK OK OK OK OK NONE FRESHMEN GRADE 12 HE HE 3 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 1877
1877 NONE OK NONE OK NONE NONE NONE FRESHMEN GRADE 12 ICT ICT 1 NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 2219
2219 NONE OK NONE NONE NONE NONE OK FRESHMEN GRADE 9 GRADE-9A NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 2278
2278 OK NONE OK OK OK OK OK FRESHMEN GRADE 10 GRADE-10A NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 2399
2399 07-A-2689 OK OK OK OK OK NULL OK FRESHMEN Graduated but has problem with grades.

6 subjec...
NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 2376
2376 07-A-2690 OK OK OK OK OK NULL OK TRANSFEREE Graduated
Released TOR and Diploma
NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 4335
4335 10-A-0002 OK OK OK NONE OK NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 3295
3295 10-A-0003 OK OK OK NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 3779
3779 10-A-0004 OK NONE NONE NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 2944
2944 10-A-0005 OK NONE NONE NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 4382
4382 10-A-0006 OK OK OK OK OK NULL OK FRESHMEN RELEASED TRANSCRIPT AND DIPLOMA Graduate 2012-2013 NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 2984
2984 10-A-0007 OK OK NONE OK NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 3784
3784 10-A-0008 OK OK OK OK NONE NULL OK TRANSFEREE NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 3454
3454 10-A-0009 NONE NONE NONE NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 3067
3067 10-A-0010 NONE NONE NONE NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 2843
2843 10-A-0011 NONE NONE NONE NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 3385
3385 10-A-0012 NONE NONE NONE NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 3408
3408 10-A-0013 NONE NONE NONE NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 2988
2988 10-A-0014 NONE NONE NONE NONE NONE NULL OK FRESHMEN NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM requirements WHERE `requirements`.`ID` = 4350
4350 10-A-0015 OK OK OK NONE NONE NULL OK TRANSFEREE RELEASED TRANSCRIPT AND DIPLOMA Graduate 2012-2013 NULL NULL NULL NULL NULL NULL NULL NULL NULL
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query