Flylib.com
List of Tables
Previous page
Table of content
Next page
Chapter 1: Quickstart to MySQL
Table 1.1: The Product Table
Table 1.2: The Invoice Table
Table 1.3: Sales Reps
Table 1.4: AND/OR Truth Table
Table 1.5: The Customer Table
Table 1.6: The Sales Table
Chapter 2: Data Types and Table Types
Table 2.1: Numeric Types
Table 2.2: String Types
Table 2.3: Date Types
Table 2.3:
TIMESTAMP
Types
Table 2.5: MySQL Option
Table 2.6: Compressed Table Options
Chapter 3: Advanced SQL
Table 3.1: Logical Operators
Table 3.2: Arithmetic Operators
Table 3.3: Comparison Operators
Table 3.4: Wildcard Characters
Table 3.5: Regular Expressions (
REGEXP, RLIKE
)
Table 3.6: Bit OPerators
Chapter 4: Indexes and Query Optimization
Table 4.1: Boolesn Search Operators
Table 4.2: What the
EXPLAIN
Columns Mean
Table 4.3: What Descriptions in the
extra EXPLAIN
Column Mean
Table 4.4: The Different Join Type
Table 4.5: Meanings of the Columns Returned by
SHOW INDEX
Chapter 7: Understanding Relational Databases
Table 7.1: The Product Table
Table 7.2: The Invoice Table
Table 7.3: The Custpmer Table
Table 7.4: The Lecturer Table
Table 7.5: The Course Table
Table 7.6: The Lecturer Table
Table 7.7: The Course Table
Table 7.8: The Student View
Table 7.9: The Student Table
Table 7.10: The Student Grade View
Table 7.11: The Student Table
Table 7.12: The Course Table
Table 7.13: The Grade Table
Chapter 8: Database Normalization
Table 8.1: Plant Data Displayed As a Tabular Report
Table 8.2: Trying to Create a Table with the Plant Data
Table 8.3: Each Record Stands Alone
Table 8.4: A Data Anomaly
Table 8.5: Removing the Fields Not Dependent on the Entire Key
Table 8.6: Creating a New Table with Plant Data
Table 8.7: Creating a New Table with Location Data
Table 8.8: Another Anomaly
Table 8.9: Plant Data After Removing the Soil Description
Table 8.10: Creating a New Table with the Soil Description
Table 8.11: 1st Normal Form
Table 8.12: The Plant Location Table with Partial Dependencies Removed
Table 8.13: Table Resulting from Fields Dependent on Plant Code
Table 8.14: Table Resulting from Fields Dependent on Location Code
Table 8.15: The Plant Location Table Remains Unchanged
Table 8.16: The Plant Table with Soil Description Removed
Table 8.17: The New Soil Table
Table 8.18: The Location Table Is Unchanged
Table 8.19: A Table Containing Data about the Student, Course, and Instructor Relationship
Table 8.20: Using Student and Course as the Key
Table 8.21: More Data Anomalies
Table 8.22: Student Instructor Table after Removing Course
Table 8.23: Resulting Instructor Course Table
Table 8.24: Using Student and Instructor as the Key
Table 8.25: Removing Course
Table 8.26: Creating a New Table with Course
Table 8.27: Student Course Instructor Data, with Several Instructors per Course
Table 8.28: Three Attributes as Key
Table 8.29: Creating a Table for the Student to Instructor Relationship
Table 8.30: Creating a Table for the Student to Course Relationship
Table 8.31: The Sales Rep Example
Table 8.32: Looking at a Larger Set of Data
Table 8.33: Creating a Table with Sales Rep and Product
Table 8.34: Creating a Table with Sales Rep and Company
Table 8.35: Creating a Table with Company and Product
Table 8.36: Customer Table
Chapter 9: Database Design
Table 9.1: Poet Table
Table 9.2: Poem Table
Table 9.3: Poem-Publication Table
Table 9.4: Publication Table
Table 9.5: Sale-Publication Table
Table 9.6: Sale Table
Table 9.7: Customer Table
Chapter 10: Basic Administration
Table 10.1: The MySQL Executables
Table 10.2: Precedence of the Configuration Files on Unix
Table 10.3: Precedence of the Configuration Files in Windows (continued)
Table 10.4: CHECK TABLE Options
Table 10.5: The mysqlcheck Options That Apply to Table Checking
Table 10.6: myisamchk Checking Options
Table 10.7: Available REPAIR TABLE Options
Table 10.8: Repairing Tables with myisamchk
Table 10.9: Mysqlcheck Options
Table 10.10: General myisamchk Options
Table 10.11: myisamchk Check Options
Table 10.12: myisamchk Repair Options
Table 10.13: Other myisamchk Options
Chapter 11: Database Backups
Table 11.1: mysqldump Options
Table 11.2: mysqlimport Options
Table 11.3: mysqlhotcopy Options
Table 11.4: mysqlbinlog Options
Chapter 12: Database Replication
Table 12.1: Master Configuration File Options
Table 12.2: Slave Configuration File Options
Chapter 13: Configuring and Optimizing MySQL
Table 13.1: The mysqld Options
Table 13.2: The mysqld Variables
Table 13.3: The MySQL Status Values
Table 13.4: Nonstandard Variables
Table 13.5: Options for
run-all-tests
Table 13.6: The
crash-me
Options
Chapter 14: Database Security
Table 14.1: The MySQL Tables
Table 14.2: What the Columns Mean
Table 14.3: Privileges
Table 14.4: Database and Table Names
Table 14.5: SSL Grant Options
Chapter 15: Installing MySQL
Table 15.1: Directories of a Binary Installation
Table 15.2: Directories of a Source Installation
Table 15.3: Executable Files
Table 15.4: Red Hat Package Manager Files
Table 15.5: mysqld_multi Options
Appendix A: MySQL Syntax Reference
Table A.1: Privileges
Table A.2: Variables You Set in a Nonstandard Way (continued)
Appendix B: MySQL Function and Operator Reference
Table B.1: Regular Expression Characters
Table B.2: Date Format Specifiers
Appendix F: Java API
Table F.1: Connection Properties
Table F.2: SQL Types and the Equivalent Set Methods
Table F.3: SQL Types and Equivalent Get Methods
Table F.4: SQL Types and the Equivalent Update Methods
Appendix G: C API
Table G.1: MYSQL Field Types
Table G.2: Flags
Table G.3: Macros
Appendix H: ODBC and .NET
Table H.1: Connection Options
Table H.2: Attribute and Associated value_pointer Contents
Table H.3: The SQLDiagField diagnostic_identifier Argument
Table H.4: The SQLGetEnvAttr attribute Argument
Table H.5: The SQLGetStmt attribute Argument
Table H.6: The operation Argument
Previous page
Table of content
Next page
Mastering MySQL 4
ISBN: 0782141625
EAN: 2147483647
Year: 2003
Pages: 230
Authors:
Ian Gilfillan
BUY ON AMAZON
Lotus Notes and Domino 6 Development (2nd Edition)
Working with Special Forms
Adding and Editing View Columns
Working in the Agent Builder Design Window
Using the Design Synopsis
Applet Tags
SQL Tips & Techniques (Miscellaneous)
Working with Comparison Predicates and Grouped Queries
Understanding SQL Subqueries
Writing External Applications to Query and Manipulate Database Data
Repairing and Maintaining MS-SQL Server Database Files
Writing Advanced Queries and Subqueries
Network Security Architectures
Load Balancing
Ten Steps to Designing Your Security System
Expected Threats
Network Design Considerations
InDesign Type: Professional Typography with Adobe InDesign CS2
Up Next
Up Next
Setting Tabs
Creating Styles
Gradient Type
Junos Cookbook (Cookbooks (OReilly))
Clearing the Routers Logfiles
Introduction
Viewing Information and LDP-Signaled LSPs in the Routing Tables
Allowing IGP Traffic to Use an LSP
Tracing RSVP Operations
Extending and Embedding PHP
Data Types
PHP4 Objects
Methods
Calling Back into PHP
Hash Tables
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies