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 1 HyperSQL User Guide HyperSQL Database Engine HSQLDB Edited by The HSQL Development Group Blaine Simpson and Fred Toussi CHyperSQL User Guide HyperSQL Database Engine HSQLDB by The HSQL Development Group Blaine Simpson and Fred Toussi Revisi

HyperSQL User Guide HyperSQL Database Engine HSQLDB Edited by The HSQL Development Group Blaine Simpson and Fred Toussi CHyperSQL User Guide HyperSQL Database Engine HSQLDB by The HSQL Development Group Blaine Simpson and Fred Toussi Revision Published Date - - - Sun Oct 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 C CTable of Contents Preface xii Available formats for this document xii 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 Short Guide to Types SQL Data and Tables Temporary Tables Persistent Tables Lob Data Basic 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 iv CHyperSQL User Guide Two Phase Locking with Snapshot Isolation Lock Contention in PL MVCC Choosing the Transaction Model Schema and Database Change Simultaneous Access to Tables 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 Text Tables Overview 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 v CHyperSQL User Guide Built-In Roles and Users 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 Other Syntax Elements Data Access Statements Table Subquery Query Speci ?cation Table Expression Table Primary Joined Table Selection Projection Computed Columns Naming Grouping Operations Aggregation Set Operations Query Expression Ordering Slicing Data Change Statements Delete Statement Truncate Statement Insert Statement Update Statement Merge