Core MySQL: [the serious developer's guide]
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Upper Saddle River, NJ
Prentice Hall
2002
|
| Schriftenreihe: | Prentice Hall PTR Core series
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | Includes bibliographical references and index |
| Beschreibung: | xxiv, 721 p. 24 cm |
| ISBN: | 0130661902 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV014496055 | ||
| 003 | DE-604 | ||
| 005 | 20050302 | ||
| 007 | t | ||
| 008 | 020603s2002 xxu|||| |||| 00||| eng d | ||
| 020 | |a 0130661902 |9 0-13-066190-2 | ||
| 035 | |a (OCoLC)473612438 | ||
| 035 | |a (DE-599)BVBBV014496055 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-473 |a DE-91G | ||
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 084 | |a DAT 663f |2 stub | ||
| 100 | 1 | |a Atkinson, Leon |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Core MySQL |b [the serious developer's guide] |c [Leon] Atkinson |
| 246 | 1 | 3 | |a MySQL |
| 264 | 1 | |a Upper Saddle River, NJ |b Prentice Hall |c 2002 | |
| 300 | |a xxiv, 721 p. |b 24 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Prentice Hall PTR Core series | |
| 500 | |a Includes bibliographical references and index | ||
| 650 | 4 | |a SQL | |
| 650 | 4 | |a databasesystemer | |
| 650 | 4 | |a programmering | |
| 650 | 4 | |a relationsdatabasesystemer | |
| 650 | 4 | |a vejledninger | |
| 650 | 0 | 7 | |a Softwareentwicklung |0 (DE-588)4116522-6 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a MySQL |0 (DE-588)4559381-4 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a MySQL |0 (DE-588)4559381-4 |D s |
| 689 | 0 | 1 | |a Softwareentwicklung |0 (DE-588)4116522-6 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009882969&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-009882969 | ||
Datensatz im Suchindex
| _version_ | 1804129310971265024 |
|---|---|
| adam_text | Titel: Core MySQL
Autor: Atkinson, Leon
Jahr: 2002
ACKNOWLEDGMENTS..........................xxi
INTRODUCTION..............................xxiii
PART ONE
MYSQL AND THE RELATIONAL MODEL.......1
I INTRODUCTION TO MYSQL...................3
How People Use Databases 4
Why Databases Are Better than Files 12
Databases Are Not a Cure-AII 15
Why MySQL? 16
MySQL History 17
2 INSTALLING MYSQ.....
Downloading Installation Files 19
By Linux RPM 20
19
Contents
Windows 22
Compiling from Source 24
Granting Privileges 24
3 INTERACTING WITH MYSQL
Client/Server over TCP/IP 27
Command-Line Utilities 28
Graphical Clients 30
ODBC 32
: i
Web Interfaces 33
4 DATABASE CONCEPTS
History 35
Terminology 37
Database Management Systems 37
Flat File Databases 38
Hierarchical Databases 39
Relational Databases 42
Object Databases 43
Object-Relational Databases 44
5 THE RELATIONAL MODEL
Relational Algebra 47
Tables, Rows, and Columns 48
Contents
Keys 49
Relationships 52
Relational Operations 54
Is MySQL a Real RDBMS? 60
6 STRUCTURED QUERY LANGUAGE.............63
SQL Is a 4GL 64
Data Definition 64
Inserting Rows 67
Updating Rows 68
Deleting Rows 68
Queries 69
Joins 70
Ordering 73
Grouping 74
Limiting 74
Altering a Table 75
7 DATABASE DESIGN ........................77
Requirements Specifications 78
Design Specification 82
Diagramming 84
Modeling Languages 86
ER Diagrams 87
Contents
Creating a Diagram 89
Implementing the Design 90
Testing 92
Lifecycle Planning 93
8 NORMALIZATION..........................95
Why Normalize? 96
First Normal Form 97
Second Normal Form 99
Third Normal Form 101
Boyce-Codd Normal Form 102
Fourth Normal Form 104
Denormalization 105
9 TRANSACTIONS AND CONCURRENCY........109
Concurrency 110
Transactions 110
Locking I 14
Sequences 116
PART TWO
MYSQL REFERENCE ....................119
10 DATA TYPES, VARIABLES, AND EXPRESSIONS ... 121
Data Types 121
Variables 125
Contents
Operators 126
Expressions 136
Names with Spaces 137
I I COLUMN AND INDEX TYPES................139
Numeric 140
Strings 143
Time Values 146
Column Type Aliases 149
Indexes 150
12 BUILT-IN FUNCTIONS . .
Debugging and Configuration 154
Flow Control 157
Grouping 161
Mathematical 165
Strings 175
Time 193
Miscellaneous 208
Procedures 210
153
13 SQL STATEMENTS
Comments 213
Alter Table 214
213
Contents
Analyze Table 220
Backup Table 220
Begin [WORK] 221
Change Master 221
Check Table 222
Commit 223
Create Database 224
Create Function 224
Create Index 225
Create Table 225
Delete 233
Describe 234
Drop Database 236
Drop Function 236
Drop Index 236
Drop Table 237
Explain 237
Flush 239
Grant 240
Insert 242
Kill 244
Lock Tables 245
Load Data Infile 246
Load Table 248
Optimize Table 248
Purge Master Logs 249
Rename Table 249
Repair Table 250
Replace 250
Reset Master 251
Reset Slave 251
Restore Table 251
Revoke 252
Rollback 252
Select 253
Set 259
Set Transaction 263
Show Columns 264
Show Create Table 265
Show Databases 266
Show Grants 267
Show Index 267
Show Logs 268
Show Processlist 268
Show Status 269
Show Table Status 271
Contents
Show Tables 272
Show Variables 273
Slave 278
Truncate 278
Unlock Tables 279
Update 279
Use 281
14 COMMAND-LINE UTILITIES
Environment Variables 283
Option Files 285
comp_err 286
isamchk 287
make_binary_distribution 287
msql2mysql 287
my_print_defaults 287
myisamchk 289
myisamlog 296
myisampack 298
mysql 301
mysql_install_db 315
mysqlaccess 315
mysqladmin 316
Contents
mysqlbinlog 325
mysqlbug 327
mysqlc 327
mysqld 327
mysqld-max 348
mysqld-nt 348
mysqld-opt 348
mysqld_multi 348
mysqldump 352
mysqldumpslow 360
mysqlhotcopy 363
mysqlimport 366
mysqlshow 370
packjsam 373
perror 373
replace 374
safe_mysqld 376
15 C API ..................................379
Types 379
Client Functions 384
Array Functions 418
Contents
Character Set Functions 419
File Functions 421
Error Functions 424
Hash Functions 424
List Functions 425
Memory Management Functions 426
Options Functions 427
Password Functions 427
String Functions 428
Thread Functions 431
PART THREE
WRITING MYSQL CLIENTS
433
16 PROGRAMMING THE C API .
435
Preparing a Program 435
Getting Data 437
Manipulating Data 441
17 JDBC
447
Preparing a Program 447
Getting Data 449
Manipulating Data 452
Contents
18 VBSCRIPT AND ODBC .....................457
Preparing a Program 458
Getting Data 460
Manipulating Data 462
19 PHP....................................467
Preparing a Program 468
Getting Data 469
Manipulating Data 471
20 PERL...................................475
Preparing a Program 475
Getting Data 477
Manipulating Data 479
21 PYTHON................................483
Preparing a Program 483
Getting Data 485
Manipulating Data 486
22 MYSQL++ API ............................489
Preparing a Program 489
Getting Data 491
Manipulating Data 493
Contents
PART FOUR
ADVANCED TOPICS.....
23 DATABASE ADMINISTRATION
Responsibilities 499
Making Data Available 500
Maintaining Database Integrity 501
Preparing for Disaster 502
Supporting Users 503
Writing and Enforcing Standards 504
24 PHYSICAL STORAGE . . .
Database/Table Model 507
Dedicated Partitions 508
Table Types 508
Columns 516
Table Locks 517
Indexes 518
File Descriptors 520
System Memory 521
Log Files 521
25 COPING WITH DISASTER
Checking and Repairing Tables 527
Backups and Recovery 530
Contents
26 OPTIMIZATION...........................539
Before Optimizing 539
Benchmarking 541
Design Optimization 545
Optimizations within Applications 547
Optimizing Queries 548
Optimizing SQL Statements 552
Maintaining Tables 554
Tuning Server Configuration 555
Recompiling MySQL 556
27 SECURITY...............................563
Permissions Scheme 563
Setting Permissions 570
Ensuring Security 573
28 TRANSITIONING .........................577
Switching Database Servers 577
Translating Unsupported Features to MySQL 578
Using ANSI Mode 585
Unique MySQL Features 586
Contents
29 DISTRIBUTED DATABASES ..................593
The Distributed Database Concept 593
Delayed Synchronization 597
MySQL s Replication Functionality 600
Running Multiple Servers 605
30 OBJECT MAPPING.........................609
The Object-Oriented Model 610 ^ ,
Serializing Objects 611
Object-Relational Mapping 614
31 ADDING FUNCTIONALITY..................627
Debugging Library 627
Adding Character Sets 632
Functions 637
Procedures 641
APPENDICES
A ONLINE RESOURCES
Official Mailing Lists 643
Unofficial Mailing Lists 645
Mailing List Archives 646
Web Sites 646
Contents
B FURTHER READING .......................649
C BUSINESS AND LEGAL CONCERNS............651
MySQL s License 651
GNU GENERAL PUBLIC LICENSE 652
Stability 659
Support 660
D RESERVED WORDS 663
E MYSQL ERROR CODES .....................667
F SQL STYLE GUIDE.........................683
General 683
Identifiers 684
Tables 684
Statements 685
G EXAMPLE DATABASE DESIGN................687
Diagrams 687
SQL Schema 688
|
| any_adam_object | 1 |
| author | Atkinson, Leon |
| author_facet | Atkinson, Leon |
| author_role | aut |
| author_sort | Atkinson, Leon |
| author_variant | l a la |
| building | Verbundindex |
| bvnumber | BV014496055 |
| classification_rvk | ST 271 |
| classification_tum | DAT 663f |
| ctrlnum | (OCoLC)473612438 (DE-599)BVBBV014496055 |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01608nam a2200457zc 4500</leader><controlfield tag="001">BV014496055</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20050302 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">020603s2002 xxu|||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0130661902</subfield><subfield code="9">0-13-066190-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)473612438</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV014496055</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield><subfield code="a">DE-91G</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">DAT 663f</subfield><subfield code="2">stub</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Atkinson, Leon</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Core MySQL</subfield><subfield code="b">[the serious developer's guide]</subfield><subfield code="c">[Leon] Atkinson</subfield></datafield><datafield tag="246" ind1="1" ind2="3"><subfield code="a">MySQL</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Upper Saddle River, NJ</subfield><subfield code="b">Prentice Hall</subfield><subfield code="c">2002</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xxiv, 721 p.</subfield><subfield code="b">24 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Prentice Hall PTR Core series</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references and index</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">databasesystemer</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">programmering</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">relationsdatabasesystemer</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">vejledninger</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Softwareentwicklung</subfield><subfield code="0">(DE-588)4116522-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Softwareentwicklung</subfield><subfield code="0">(DE-588)4116522-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009882969&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-009882969</subfield></datafield></record></collection> |
| id | DE-604.BV014496055 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T19:03:07Z |
| institution | BVB |
| isbn | 0130661902 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-009882969 |
| oclc_num | 473612438 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG DE-91G DE-BY-TUM |
| owner_facet | DE-473 DE-BY-UBG DE-91G DE-BY-TUM |
| physical | xxiv, 721 p. 24 cm |
| publishDate | 2002 |
| publishDateSearch | 2002 |
| publishDateSort | 2002 |
| publisher | Prentice Hall |
| record_format | marc |
| series2 | Prentice Hall PTR Core series |
| spelling | Atkinson, Leon Verfasser aut Core MySQL [the serious developer's guide] [Leon] Atkinson MySQL Upper Saddle River, NJ Prentice Hall 2002 xxiv, 721 p. 24 cm txt rdacontent n rdamedia nc rdacarrier Prentice Hall PTR Core series Includes bibliographical references and index SQL databasesystemer programmering relationsdatabasesystemer vejledninger Softwareentwicklung (DE-588)4116522-6 gnd rswk-swf MySQL (DE-588)4559381-4 gnd rswk-swf MySQL (DE-588)4559381-4 s Softwareentwicklung (DE-588)4116522-6 s DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009882969&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Atkinson, Leon Core MySQL [the serious developer's guide] SQL databasesystemer programmering relationsdatabasesystemer vejledninger Softwareentwicklung (DE-588)4116522-6 gnd MySQL (DE-588)4559381-4 gnd |
| subject_GND | (DE-588)4116522-6 (DE-588)4559381-4 |
| title | Core MySQL [the serious developer's guide] |
| title_alt | MySQL |
| title_auth | Core MySQL [the serious developer's guide] |
| title_exact_search | Core MySQL [the serious developer's guide] |
| title_full | Core MySQL [the serious developer's guide] [Leon] Atkinson |
| title_fullStr | Core MySQL [the serious developer's guide] [Leon] Atkinson |
| title_full_unstemmed | Core MySQL [the serious developer's guide] [Leon] Atkinson |
| title_short | Core MySQL |
| title_sort | core mysql the serious developer s guide |
| title_sub | [the serious developer's guide] |
| topic | SQL databasesystemer programmering relationsdatabasesystemer vejledninger Softwareentwicklung (DE-588)4116522-6 gnd MySQL (DE-588)4559381-4 gnd |
| topic_facet | SQL databasesystemer programmering relationsdatabasesystemer vejledninger Softwareentwicklung MySQL |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009882969&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT atkinsonleon coremysqltheseriousdevelopersguide AT atkinsonleon mysql |