SQL Anywhere Studio 9- P1

SQL Anywhere Studio 9 Developers Guide mô tả chi tiết làm thế nào để quản lý và chương trình SQL bất cứ nơi nào, các quan hệ cơ sở dữ liệu hàng đầu cho điện thoại di động, phân phối, và các ứng dụng nhúng. Cuốn sách này tập trung vào các nhiệm vụ khác nhau thực hiện trong vòng đời của một cơ sở dữ liệu điển hình, như tạo bảng và các đối tượng schema khác, và chèn, chọn, cập nhật, và xóa dữ liệu. Các chủ đề khác bao gồm đóng gói mã SQL vào các thủ...
Nội dung trích xuất từ tài liệu:
SQL Anywhere Studio 9- P1Please purchase PDF Split-Merge on www.verypdf.com to remo SQL Anywhere® Studio 9 Breck Carter Wordware Publishing, Inc.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark Library of Congress Cataloging-in-Publication Data Carter, Breck. SQL anywhere Studio 9 / by Breck Carter. p. cm. ISBN 1-55622-506-7 1. SQL (Computer program language) 2. Relational databases. I. Title. QA76.73.S67C36 2004 005.133—dc22 2004011573 © 2004, Wordware Publishing, Inc. All Rights Reserved 2320 Los Rios Boulevard Plano, Texas 75074 No part of this book may be reproduced in any form or by any means without permission in writing from Wordware Publishing, Inc. Printed in the United States of America ISBN 1-55622-506-7 10 9 8 7 6 5 4 3 2 1 0406 SQL Anywhere is a registered trademark of Sybase, Inc. and its subsidiaries. All brand names and product names mentioned in this book are trademarks or service marks of their respective companies. Any omission or misuse (of any kind) of service marks or trademarks should not be regarded as intent to infringe on the property of others. The publisher recognizes and respects all marks used by companies, manufacturers, and developers as a means to distinguish their products. All inquiries for volume purchases of this book should be addressed to Wordware Publishing, Inc., at the above address. Telephone inquiries may be made by calling: (972) 423-0090Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark Contents Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv Chapter 1 Creating . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1.2 Codd’s 12 Rules for Relational Databases . . . . . . . . . . . . . . . . . . . 2 1.3 Five Types of Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 1.4 Global Permanent Table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 1.5 Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 1.5.1 A String Is a String: BINARY, CHARACTER, LONG . . . . . . . . . 8 1.5.2 Dates and Times . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 1.5.3 Exact Decimals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 1.5.4 Floating-Point Numbers . . . . . . . . . . . . . . . . . . . . . . . . . 11 1.5.5 Binary Integers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 1.5.6 Literals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 1.6 Column Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 1.7 Computed Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 1.8 DEFAULT Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 1.8.1 DEFAULT AUTOINCREMENT . . . . . . . . . . . . . . . . . . . . 17 1.8.2 DEFAULT GLOBAL AUTOINCREMENT . . . . . . . . . . . . . . 18 1.8.3 Literal Defaults . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 1.8.4 Special Update Defaults . . . . . . . . . . . . . . . . . . . . . . . . . 20 1.8.5 Expressions as Defaults . . . . . . . . . . . . . . . . . . . . . . . . . 21 1.9 NULL Property . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 1.10 Column Constraints . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 1.10.1 NOT NULL Constraint . . . . . . . . . . . . . . . . . . . . . . . . 22 1.10.2 Column CHECK Constraint . . . . . . . . . . . . . . . . . . . . . . 22 1.10.3 PRIMARY KEY Column Constraint . . . . . . . . . . . . . . . . . 23 1.10.4 Foreign Key Column Constraint. . . . . . . . . . . . . . . . . . . . 24 1.10.5 UNIQUE Column Constraint . . . . . . . . . . . . . . . . . . . . . 25 1.11 User-Defined Data ...