Database design manual: using MySQL for windows:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
London u.a.
Springer
2004
|
| Schriftenreihe: | Springer professional computing
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | X, 209 S. Ill. |
| ISBN: | 1852337168 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV017391748 | ||
| 003 | DE-604 | ||
| 005 | 20070419 | ||
| 007 | t | ||
| 008 | 030805s2004 xxka||| |||| 00||| eng d | ||
| 010 | |a 2003059046 | ||
| 020 | |a 1852337168 |9 1-85233-716-8 | ||
| 035 | |a (OCoLC)52728956 | ||
| 035 | |a (DE-599)BVBBV017391748 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxk |c GB | ||
| 049 | |a DE-384 |a DE-83 | ||
| 050 | 0 | |a QA76.9.D3 | |
| 082 | 0 | |a 005.75/6 |2 22 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Norman, Matthew |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Database design manual: using MySQL for windows |c Matthew Norman |
| 264 | 1 | |a London u.a. |b Springer |c 2004 | |
| 300 | |a X, 209 S. |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Springer professional computing | |
| 630 | 0 | 4 | |a Microsoft Windows (Computer file) |
| 650 | 4 | |a Database design | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 0 | 7 | |a World Wide Web |0 (DE-588)4363898-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a MySQL |0 (DE-588)4559381-4 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankentwurf |0 (DE-588)4127613-9 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 0 | 1 | |a MySQL |0 (DE-588)4559381-4 |D s |
| 689 | 0 | |5 DE-604 | |
| 689 | 1 | 0 | |a World Wide Web |0 (DE-588)4363898-3 |D s |
| 689 | 1 | 1 | |a Datenbankentwurf |0 (DE-588)4127613-9 |D s |
| 689 | 1 | 2 | |a MySQL |0 (DE-588)4559381-4 |D s |
| 689 | 1 | |5 DE-604 | |
| 856 | 4 | 2 | |m Digitalisierung UB Augsburg |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010479330&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-010479330 | ||
Datensatz im Suchindex
| _version_ | 1804130211844849664 |
|---|---|
| adam_text | Contents
1 MySQL and Databases ......................................................... 1
About This Book
About
Who Can Use This Book?
Databases and the Internet
DBMS
MySQL Databases
Tables
Client-server Systems
Structured Query Language
2
Obtaining MySQL
Installing the MySQL Server
Installing the Graphical Client Tool
MySQL Directory Structure
The Online MySQL Manual
Starting the MySQL Service
MySQL Configuration Files
Connecting to the MySQL Service
Connecting with the Graphical Tool
MySQLGUI QuickTour
3
The Datatype
Numeric Types
Character Types
Fixed or Variable Length?
Storing Text
BLOB
Date Types
Other Types
SET
ENUM
viii Contents
4
Redundant Data
The Primary Key
Foreign Keys
Redundant or Not?
Referential Integrity
NULL
CREATE DATABASE
CREATE TABLE
Identifying Foreign Keys
Create from Select Statement
CREATETABLE LIKE
5
INSERT
INSERT
INSERT
INSERT
Inserting Data with Scripts
Directly Inserting Data
6
SELECT
SELECT DISTINCT
WHERE
MySQL Operators
Subqueries
7
Information in Multiple Tables
Cross Joins
Inner Joins
Equi-join
Equi-joins on More Tables
Restricting Equi-joins
INNER JOIN
Outer Joins
8
Altering Data
UPDATE Revisited
REPLACE
CREATE or REPLACE
DUPLICATE KEY UPDATE
Contents ix
9
Keeping Data Accurate
DELETE FROM
DROP TABLE
DROP
10
Count
GROUP BY
MAX
MIN
SUM
Using Multiple Aggregates
AVG
HAVING
Π
Using Date and Time
Working with Dates
Common Date Queries
12
Protecting Valuable Data
The User Table
The tables_priv Table
The Grant Tables
Restricting Users
Other Passwords
13
Tables Get Bigger
How Well Does It Run?
Examining Queries
Looking at Cross-joins Again
Indexing
CREATE INDEX
OPTIMIZE TABLE
CHECK TABLE
REPAIRTABLE
ANALYZE TABLE
14
It s Not Just For MySQL
More Standards
Open Database Connectivity
χ
Data Sources
Obtaining MyODBC
Installing MyODBC Drivers
Setting Up a Data Source
Example Connections
MySQL and ASP
MySQL and ColdFusion
Creating a Data Source in ColdFusion
Accessing the Data Source in ColdFusion
15
IndigoPerl
A Quick PHP Script
Accessing MySQL
Working with Perl
Defining a Perl and HTML Document
Connecting to MySQL with DBI
Generating the Query
Processing the Query Results
Coping with Errors
Reformatting the Output
16
Other Tools
MySQL Control Centre
PHPMyAdmin
|
| any_adam_object | 1 |
| author | Norman, Matthew |
| author_facet | Norman, Matthew |
| author_role | aut |
| author_sort | Norman, Matthew |
| author_variant | m n mn |
| building | Verbundindex |
| bvnumber | BV017391748 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 |
| callnumber-search | QA76.9.D3 |
| callnumber-sort | QA 276.9 D3 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)52728956 (DE-599)BVBBV017391748 |
| dewey-full | 005.75/6 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/6 |
| dewey-search | 005.75/6 |
| dewey-sort | 15.75 16 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01778nam a2200493zc 4500</leader><controlfield tag="001">BV017391748</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20070419 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">030805s2004 xxka||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2003059046</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1852337168</subfield><subfield code="9">1-85233-716-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)52728956</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV017391748</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">xxk</subfield><subfield code="c">GB</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-384</subfield><subfield code="a">DE-83</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D3</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/6</subfield><subfield code="2">22</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="100" ind1="1" ind2=" "><subfield code="a">Norman, Matthew</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Database design manual: using MySQL for windows</subfield><subfield code="c">Matthew Norman</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">London u.a.</subfield><subfield code="b">Springer</subfield><subfield code="c">2004</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">X, 209 S.</subfield><subfield code="b">Ill.</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">Springer professional computing</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Windows (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Database design</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">World Wide Web</subfield><subfield code="0">(DE-588)4363898-3</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="650" ind1="0" ind2="7"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><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=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">World Wide Web</subfield><subfield code="0">(DE-588)4363898-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Datenbankentwurf</subfield><subfield code="0">(DE-588)4127613-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="2"><subfield code="a">MySQL</subfield><subfield code="0">(DE-588)4559381-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Augsburg</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=010479330&sequence=000002&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-010479330</subfield></datafield></record></collection> |
| id | DE-604.BV017391748 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T19:17:26Z |
| institution | BVB |
| isbn | 1852337168 |
| language | English |
| lccn | 2003059046 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-010479330 |
| oclc_num | 52728956 |
| open_access_boolean | |
| owner | DE-384 DE-83 |
| owner_facet | DE-384 DE-83 |
| physical | X, 209 S. Ill. |
| publishDate | 2004 |
| publishDateSearch | 2004 |
| publishDateSort | 2004 |
| publisher | Springer |
| record_format | marc |
| series2 | Springer professional computing |
| spelling | Norman, Matthew Verfasser aut Database design manual: using MySQL for windows Matthew Norman London u.a. Springer 2004 X, 209 S. Ill. txt rdacontent n rdamedia nc rdacarrier Springer professional computing Microsoft Windows (Computer file) Database design SQL (Computer program language) World Wide Web (DE-588)4363898-3 gnd rswk-swf MySQL (DE-588)4559381-4 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 gnd rswk-swf Datenbankentwurf (DE-588)4127613-9 s MySQL (DE-588)4559381-4 s DE-604 World Wide Web (DE-588)4363898-3 s Digitalisierung UB Augsburg application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010479330&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Norman, Matthew Database design manual: using MySQL for windows Microsoft Windows (Computer file) Database design SQL (Computer program language) World Wide Web (DE-588)4363898-3 gnd MySQL (DE-588)4559381-4 gnd Datenbankentwurf (DE-588)4127613-9 gnd |
| subject_GND | (DE-588)4363898-3 (DE-588)4559381-4 (DE-588)4127613-9 |
| title | Database design manual: using MySQL for windows |
| title_auth | Database design manual: using MySQL for windows |
| title_exact_search | Database design manual: using MySQL for windows |
| title_full | Database design manual: using MySQL for windows Matthew Norman |
| title_fullStr | Database design manual: using MySQL for windows Matthew Norman |
| title_full_unstemmed | Database design manual: using MySQL for windows Matthew Norman |
| title_short | Database design manual: using MySQL for windows |
| title_sort | database design manual using mysql for windows |
| topic | Microsoft Windows (Computer file) Database design SQL (Computer program language) World Wide Web (DE-588)4363898-3 gnd MySQL (DE-588)4559381-4 gnd Datenbankentwurf (DE-588)4127613-9 gnd |
| topic_facet | Microsoft Windows (Computer file) Database design SQL (Computer program language) World Wide Web MySQL Datenbankentwurf |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=010479330&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT normanmatthew databasedesignmanualusingmysqlforwindows |