Remerciez-le!

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

Guide hsqldb HyperSQL User Guide HyperSQL Database Engine HSQLDB Edited by Blaine Simpson and Fred Toussi CHyperSQL User Guide HyperSQL Database Engine HSQLDB by Blaine Simpson and Fred Toussi Revision Publication date - - Copyright - The HSQL Development

HyperSQL User Guide HyperSQL Database Engine HSQLDB Edited by Blaine Simpson and Fred Toussi CHyperSQL User Guide HyperSQL Database Engine HSQLDB by Blaine Simpson and Fred Toussi Revision Publication date - - Copyright - 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 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 Lob Data Short Guide to Data Types Data Types and Operations Numeric Types Boolean Type Character String Types Binary String Types Bit String Types 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 Two Phase Locking iii CHyperSQL User Guide 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 Statements for Schema De ?nition and Manipulation Common Elements and Statements Renaming Objects Commenting Objects Schema Creation Table Creation 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 The Implementation De ?nition of Tables Scope and Reassignment Null Values in Columns of Text Tables iv CHyperSQL User Guide 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 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 Statement Table Subquery Query Speci ?cation Table Expression Table Primary Joined Table Selection Projection Computed Columns Naming Grouping