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
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Basic Commands, Variables, and Data Types
More Power to the Numbers Data Sequences and Arrays
Basic Graphics Commands
Game Graphics Learning to Use Bitmaps
Fundamentals of 3D Graphics Programming
Project Management JumpStart
Building the Foundation
Defining the Project Goals
Planning and Acquiring Resources
Assessing Risk
Controlling the Project Outcome
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Training
Initial Startup and Common Pitfalls
Improving the Kanban
Conclusion
Appendix D Organizational Changes Required for Kanban
.NET-A Complete Development Cycle
Introducing .NET
The Project Vision and Business Case
Requirements for the GDI+ Extensions
Breakdown of the Code Modules
Requirements Tracing
Python Programming for the Absolute Beginner, 3rd Edition
The Greps of Wrath
PyToe: A Tic-Tac-Toe Game Widget
Persistence Options in Python
Reversing Sequences
Conclusion Python and the Development Cycle
Understanding Digital Signal Processing (2nd Edition)
REPRESENTING REAL SIGNALS USING COMPLEX PHASORS
BANDPASS QUADRATURE SIGNALS IN THE FREQUENCY DOMAIN
REFERENCES
FREQUENCY TRANSLATION USING DECIMATION
Section A.3. ARITHMETIC OPERATIONS OF COMPLEX NUMBERS
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