Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Hsqldb guide 2 HyperSQL User Guide HyperSQL Database Engine Edited by Blaine Simpson and Fred Toussi CHyperSQL User Guide HyperSQL Database Engine by Blaine Simpson and Fred Toussi Revision Publication date - - Copyright - Blaine Simpson Fred Toussi and T

HyperSQL User Guide HyperSQL Database Engine Edited by Blaine Simpson and Fred Toussi CHyperSQL User Guide HyperSQL Database Engine by Blaine Simpson and Fred Toussi Revision Publication date - - Copyright - Blaine Simpson Fred Toussi and The HSQL Development Group Permission is granted to distribute this document without any alteration under the terms of the HSQLDB license You are not allowed to distribute or display this document on the web in an altered form CTable of Contents Preface xiii Available formats for this document xiii Running and Using HyperSQL Introduction The HSQLDB Jar Running Database Access Tools A HyperSQL Database In-Process Access to Database Catalogs Server Modes HyperSQL HSQL Server HyperSQL HTTP Server HyperSQL HTTP Servlet Connecting to a Database Server Security Considerations Using Multiple Databases Accessing the Data Closing the Database Creating a New Database SQL Language Standards Support SQL Data and Tables Temporary Tables Persistent Tables Short Guide to Data Types Data Types and Operations Numeric Types Boolean Type Character String Types Binary String Types Bit String Types Lob Data Storage and Handling of Java Objects Type Length Precision and Scale Datetime types Interval Types Arrays Array De ?nition Array Reference Array Operations Indexes and Query Speed Query Processing and Optimisation Indexes and Conditions Indexes and Operations Indexes and ORDER BY OFFSET and LIMIT Sessions and Transactions Overview Session Attributes and Variables Session Attributes Session Variables Session Tables Transactions and Concurrency Control iii CHyperSQL User Guide Two Phase Locking Two Phase Locking with Snapshot Isolation Lock Contention in PL Locks in SQL Routines and Triggers MVCC Choosing the Transaction Model Schema and Database Change Simultaneous Access to Tables Viewing Sessions Session and Transaction Control Statements Schemas and Database Objects Overview Schemas and Schema Objects Names and References Character Sets Collations Distinct Types Domains Number Sequences Tables Views Constraints Assertions Triggers Routines Indexes Synonyms Statements for Schema De ?nition and Manipulation Common Elements and Statements Renaming Objects Commenting Objects Schema Creation Table Creation Temporal System-Versioned Tables and SYSTEM TIME Period Table Settings Table Manipulation View Creation and Manipulation Domain Creation and Manipulation Trigger Creation Routine Creation Sequence Creation SQL Procedure Statement Other Schema Object Creation The Information Schema Prede ?ned Character Sets Collations and Domains Views in INFORMATION SCHEMA Visibility of Information Name Information Data Type Information Product Information Operations Information SQL Standard Views Text Tables Overview iv CHyperSQL User Guide The Implementation De ?nition of Tables Scope and Reassignment Null Values in Columns of Text Tables Con ?guration Disconnecting Text Tables Text File Usage Text File Global Properties Transactions Access Control Overview Authorizations and Access Control Built-In Roles and Users Listing Users and Roles Access Rights Fine-Grained Data Access Control Statements for Authorization and Access Control Data Access and Change Overview Cursors And Result Sets Columns and Rows Navigation Updatability Sensitivity Holdability Autocommit JDBC Overview JDBC Parameters JDBC and Data Change Statements JDBC Callable Statement JDBC Returned Values Cursor Declaration Syntax Elements Literals References etc Value Expression Predicates Aggregate Functions Other Syntax Elements Data Access Statements Select