Part III: MySQL Administration - Mastering MySQL 4 [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

جستجو بر اساس ... همه عنوان پدیدآور موضوع یادداشت تمام متن
اصطلاحنامه مجموعه ها مرورالفبایی لغت نامه دهخدا
➟
جستجو در لغت نامه
بیشتر
کتابخانه شخصی پرسش از کتابدار ارسال منبع

Mastering MySQL 4 [Electronic resources] - نسخه متنی

Ian Gilfillan

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
میخواهم بخوانم
درحال خواندن
خوانده شده
ارسال به دوستان

آدرس پست الکترونیک گیرنده :

آدرس پست الکترونیک فرستنده :

نام و نام خانوارگی فرستنده :

پیغام برای گیرنده ( حداکثر 250 حرف ) :

کد امنیتی را وارد نمایید

ارسال
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
➟
جستجو در لغت نامه
بیشتر
لیست موضوعات

Sitemap

BackCover

Mastering MySQL 4

Introduction

What Not to Expect from This Book

What Do You Need?

How to Use This Book

How to Contact the Author

Part I: Using MySQL

Chapter 1: Quickstart to MySQL

Understanding MySQL Basics

Connecting to the MySQL Server

Creating and Using Your First Database

Summary

Chapter 2: Data Types and Table Types

Exploring the Various Column Types

MySQL Options

Exploring the Various Table Types

Summary

Chapter 3: Advanced SQL

Operators

Advanced Joins

Adding Records to a Table from Other Tables with INSERT SELECT

More about Adding Records

More about Removing Records (DELETE and TRUNCATE)

User Variables

Running SQL Statements Stored in files

Transactions and Locking

Summary

Chapter 4: Indexes and Query Optimization

Understanding Indexes

Creating an Index

Using an Auto Increment Field

Dropping or Changing an Index

Understanding Table Types and Indexes

Using Indexes Effectively

Analyzing How MySQL Uses Indexes with EXPLAIN

Optimizing Selects

Optimizing Updates, Deletes, and Inserts

Summary

Chapter 5: Programming with MySQL

Using Good Database Programming Techniques

The Stages of Application Development

Summary

Chapter 6: Extending MySQL

User-Defined Functions

Troubleshooting the UDF

Summary

Part II: Designing a Database

Chapter 7: Understanding Relational Databases

Exploring Early Database Models

Understanding the Relational Database Model

Summary

Chapter 8: Database Normalization

Understanding Normalization

Understanding Denormalization

Summary

Chapter 9: Database Design

The Database Lifecycle

Real-World Example: Creating a Publishing Tracking System

Concurrency Control with Transactions

Summary

Part III: MySQL Administration

Chapter 10: Basic Administration

Meeting MySQL as an Administrator

Starting and Shutting Down MySQL

Configuring MySQL

Logging

Optimizing, Analyzing, Checking, and Repairing Tables

Summary

Chapter 11: Database Backups

Backing Up MyISAM Tables with BACKUP

Restoring MyISAM Tables with RESTORE

Backing Up MyISAM Tables by Directly Copying the files

Backing Up with mysqldump

Backing Up with SELECT INTO

Using mysqlhotcopy to Back Up

Using the Binary Update Log to Restore a Database to the Most Recent Position

Backing Up and Restoring InnoDB Tables

Replication as a Means of Backup

Summary

Chapter 12: Database Replication

Understanding Replication

Setting Up Replication

Replicating One Database

Replicating with an Active Binary Log on the Master

Removing Old Binary Logs from the Master and Then Starting

Avoiding Too Many Updates

Avoiding Key Errors

Summary

Chapter 13: Configuring and Optimizing MySQL

Optimizing the mysqld Variables

Changing Variable Values with the Server Running

Improving Hardware to Speed Up the Server

Using Benchmarks

Running MySQL in ANSI Mode

Using Different Languages in MySQL

Chapter 14: Database Security

Security When Connecting

Managing Users and Permissions

SSL Connections

Application Security

System Security

Security Issues with LOAD DATA LOCAL

Summary

Chapter 15: Installing MySQL

Deciding Whether to Install a Source or Binary Distribution

Installing MySQL on Windows

Installing MySQL on Unix

Installing Multiple MySQL Servers on the Same Machine

Avoiding Common Installation Problems

Upgrading from MySQL 3.x to MySQL 4

Summary

Chapter 16: Multiple Drives

Understanding RAID

Using Symbolic Links

Summary

Part A: Appendixes

Appendix A: MySQL Syntax Reference

ALTER

ANALYZE TABLE

BACKUP TABLE

BEGIN

CHECK TABLE

COMMIT

CREATE

DELETE

DESC

DESCRIBE

DO

DROP

EXPLAIN

FLUSH

GRANT

INSERT

JOIN

KILL

LOAD DATA INFILE

LOCK TABLES

OPTIMIZE

RENAME

REPAIR TABLE

REPLACE

RESET

RESTORE TABLE

REVOKE

ROLLBACK

SELECT

SET

SET TRANSACTION

SHOW

TRUNCATE

UNION

UNLOCK TABLES

UPDATE

USE

Appendix B: MySQL Function and Operator Reference

Arithmetic Operators

Comparison Operators

Bit Operators

Date and Time Functions

String Functions

Numeric Functions

Aggregate Functions

Other Functions

Appendix C: PHP API

PHP MySQL Functions

Appendix D: Perl DBI

DBI Class Methods

DBI Methods Common to All Handles

DBI Utility Functions

Database Handle Methods

Statement Handle Methods

DBI Attributes Common to All Handles

Database Handle Attributes

Statement Handle Attributes

Dynamic Attributes

A Short Perl DBI Example

Appendix E: Python Database API

Attributes

Methods

A Short Python Example

Appendix F: Java API

General Methods

Connection Methods

Statement and Prepared Statement Methods

ResultSet Methods

ResultSetMetaData Methods

SQLException Methods

Warning Methods

A Short Java Example

Appendix G: C API

C API Functions

A Short C API Example

Appendix H: ODBC and .NET

Understanding Data Sources

Exporting Data from Microsoft Access to MySQL

Using ODBC

MyODBC Functions

Index

Index_A

Index_B

Index_C

Index_D

Index_E

Index_F

Index_G

Index_H

Index_I

Index_J

Index_K

Index_L

Index_M

Index_N

Index_O

Index_P

Index_Q

Index_R

Index_S

Index_T

Index_U

Index_V

Index_W

Index_Y

Index_Z

List of Figures

List of Tables

List of Listings

List of Sidebars

توضیحات
افزودن یادداشت جدید
/ 229