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
Customise 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 `libaccession`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id ACCNO CLASS AUTHOR TITLE PAGES PUBLISHER YEAR REMARKS DATERECEIVED EDITION VOLUME SOF COST quan
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 1
1 00001 AZ 183 Gayeta, Macario G., etal Art: Texts and Contexts An Interactive Workbook in... 242 Malabon City: jimczyville 2010 c.2 2
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 2
2 00002 AZ 183 Gayeta, Macario G., etal Art: Texts and Contexts An Interactive Workbook in... 242 Malabon City: jimczyville 2010 c.3 3
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 3
3 00003 AZ 183 Gayeta, Macario G., etal Art: Texts and Contexts An Interactive Workbook in... 242 Malabon City: jimczyville 2010 c.4 4
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 4
4 00004 AZ 152 Molina-Doria, Kristine Humanities Today: An Experiential Approach 117 Quezon City: C & E 2012 c.3 3
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 5
5 00005 AZ 152 Molina-Doria, Kristine Humanities Today: An Experiential Approach 117 Quezon City: C & E 2012 c.2 2
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 6
6 00006 AZ 152 Molina-Doria, Kristine Humanities Today: An Experiential Approach 117 Quezon City: C & E 2012 c.1 NULL NULL NULL 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 7
7 00007 AZ 152 Molina-Doria, Kristine Humanities Today: An Experiential Approach 117 Quezon City: C & E 2012 c.4 4
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 8
8 00008 AZ 183 Regadio Jr., Crisanto Q. Art Appreciation: Introductory Reading on Humaniti... 210 Mandaluyong City: Books Atbp. 2013 c.1 NULL NULL NULL 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 9
9 00009 AZ 183 Regadio Jr., Crisanto Q. Art Appreciation: Introductory Reading on Humaniti... 210 Mandaluyong City: Books Atbp. 2013 c.2 2
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 10
10 00010 AZ 183 Regadio Jr., Crisanto Q. Art Appreciation: Introductory Reading on Humaniti... 210 Mandaluyong City: Books Atbp. 2013 c.3 3
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 11
11 00011 AZ 183 Regadio Jr., Crisanto Q. Art Appreciation: Introductory Reading on Humaniti... 210 Mandaluyong City: Books Atbp. 2013 c.4 4
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 12
12 00012 AZ 183 Marcos, Lucivilla L., etal Introduction to the Humanities Visual & Performing... 178 Manila: Mindshapers 2010 c.1 NULL Revised NULL NULL 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 13
13 00013 AZ 183 M333 Marcos, Lucivilla L., etal Introduction to the Humanities Visual & Performing... 178 Manila: Mindshapers 2010 c.2 Revised 2
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 14
14 00014 AZ 183 Marcos, Lucivilla L., etal Introduction to the Humanities Visual & Performing... 178 Manila: Mindshapers 2010 c.3 Revised 3
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 15
15 00015 AZ 183 Marcos, Lucivilla L., etal Introduction to the Humanities Visual & Performing... 178 Manila: Mindshapers 2010 c.4 Revised 4
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 16
16 00016 AZ 183 Tabotabo, Claudio V. Art Appreciation Introduction to the Humanities 195 Manila: Mindshapers 2010 c.2 2
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 17
17 00017 AZ 183 Tabotabo, Claudio V. Art Appreciation Introduction to the Humanities 195 Manila: Mindshapers 2010 c.1 NULL NULL NULL 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 18
18 00018 A2 183 T114in Tabotabo, Claudio V. Introduction to the Humanities and the Basics of A... 217 Manila: Purely Books 2013 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 19
19 00019 A2 183 T114in Tabotabo, Claudio V. Introduction to the Humanities and the Basics of A... 217 Manila: Purely Books 2013 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 20
20 00020 A2 183 T114in Tabotabo, Claudio V. Introduction to the Humanities and the Basics of A... 217 Manila: Purely Books 2013 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 21
21 00021 A2 183 T114in Tabotabo, Claudio V. Introduction to the Humanities and the Basics of A... 217 Manila: Purely Books 2013 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 22
22 00022 NX 440 De Bogart, Doris V. Introduction to the Humanities; Painting, Sculptur... 422 Mandaluyong City: National BookStore 1970 c.1 NULL NULL NULL 1
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 23
23 00023 NX 440 De Bogart, Doris V. Introduction to the Humanities; Painting, Sculptur... 422 Mandaluyong City: National BookStore 1970 c.2 2
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 24
24 00024 NX 440 De Bogart, Doris V. Introduction to the Humanities; Painting, Sculptur... 422 Mandaluyong City: National BookStore 1970 c.3 3
Edit Edit Copy Copy Delete Delete
DELETE FROM libaccession WHERE `libaccession`.`id` = 25
25 00025 NX 440 De Bogart, Doris V. Introduction to the Humanities; Painting, Sculptur... 422 Mandaluyong City: National BookStore 1970 c.4 4
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