Handy Library Manager  for Windows


Help, how to topics > Library Main Catalogue > What is Structured Query Language (SQL), how to define SQL statements?


What is Structured Query Language (SQL), how to define SQL statements?

SQL (Structured Query Language) is a standard programming language for relational database management systems (like our library database system). SQL statements allow you to retrieve data from a database.

In our Advance Search you can easily and quickly build search queries, to do that, you don't have to know SQL language.


  • Click Advanced Search (1)
  • Define search condition (2): select data field, select condition, and enter condition value.
  • Click Include
  • The search condition is inserted into the Search Condition box.
  • Repeat above steps to define another condition.
  • Click Search to execute query.
  • Click Save to save the search condition for future use.

Our library Advanced Search provides interface that allows you to define simple search condition. In the case of complex search definitions it will be easier to enter the search condition directly into the Search Condition box. Below we list some library search samples with SQL functions and ready to use statements. If you have questions how to define other library useful searches/queries please contact us.


CURRENT_DATE returns the current date value, use this function with other library database date fields.

Compare item DATE_ADDED value with the CURRENT_DATE to display library items that were added today, yesterday, or in the last week or month.



Handy Library Manager

software
tour
features
try now
cloud

Copyright © 2018 · All Rights Reserved · PrimaSoft PC
http://www.primasoft.com/librarymanager/library-software-sql-functions.htm
www.primasoft.com
crawl=CC-MAIN-2018-47
11387
application/http; msgtype=response
sha1:JSUVJ5KQNMCYKUL7K5QIA7PF7UV62TRL
<urn:uuid:7b81d708-fb53-455e-a7b8-c9c933eb305c>
2018-11-16T22:47:30Z
64.151.67.13
text/html
sha1:QMXOVP3WZCCTJNWELBN3HDIHSYZ4UAH6
<urn:uuid:c491eadd-7722-4306-a26f-a5d02ab51469>
http://www.primasoft.com/librarymanager/library-software-sql-functions.htm
response
<urn:uuid:512d5539-0e34-42c5-9013-839e99dc5561>
isPartOf: CC-MAIN-2018-47
publisher: Common Crawl
description: Wide crawl of the web for November 2018
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-237-21-139.ec2.internal
software: Apache Nutch 1.15 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 0.11-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/