Learning MySQL and MariaDB: [heading in the right direction with MySQL and MariaDB]
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing [u.a.]
O'Reilly
2015
|
| Ausgabe: | 1. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltstext Inhaltsverzeichnis |
| Beschreibung: | XXIII, 381 S. |
| ISBN: | 9781449362904 1449362907 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV042571622 | ||
| 003 | DE-604 | ||
| 005 | 20211118 | ||
| 007 | t | ||
| 008 | 150520s2015 xxu |||| 00||| eng d | ||
| 015 | |a 15,N09 |2 dnb | ||
| 016 | 7 | |a 106730794X |2 DE-101 | |
| 020 | |a 9781449362904 |c Pb. : EUR 41.00 (DE) (freier Pr.), EUR 42.20 (AT) (freier Pr.) |9 978-1-449-36290-4 | ||
| 020 | |a 1449362907 |9 1-4493-6290-7 | ||
| 024 | 3 | |a 9781449362904 | |
| 035 | |a (OCoLC)910585009 | ||
| 035 | |a (DE-599)DNB106730794X | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c XD-US | ||
| 049 | |a DE-1050 |a DE-11 | ||
| 082 | 0 | |a 004 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 084 | |a 004 |2 sdnb | ||
| 100 | 1 | |a Dyer, Russell J. T. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Learning MySQL and MariaDB |b [heading in the right direction with MySQL and MariaDB] |c Russell J.T. Dyer |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing [u.a.] |b O'Reilly |c 2015 | |
| 300 | |a XXIII, 381 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a MariaDB |0 (DE-588)122947658X |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 MariaDB |0 (DE-588)122947658X |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m X:MVB |q text/html |u http://deposit.dnb.de/cgi-bin/dokserv?id=5158436&prov=M&dok_var=1&dok_ext=htm |3 Inhaltstext |
| 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=028005162&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-028005162 | |
Datensatz im Suchindex
| _version_ | 1806331351077486592 |
|---|---|
| adam_text |
Titel: Learning MySQL and MariaDB
Autor: Dyer, Russell J. T
Jahr: 2015
Table of Contents Foreword . xiii Preface . xix Part I. The Software 1. Introduction. 3 The Value of MySQL and MariaDB 3 Mailing Lists and Forums 4 Other Books and Other Publications 4 2. Installing MySQL and MariaDB.7 The Installation Packages 7 Licensing 8 Finding the Software 9 Choosing a Distribution 10 The _AMP Alternatives 11 Linux Binary Distributions 12 Mac OS X Distributions 13 Windows Distributions 16 FreeBSD and Sun Solaris Distributions 19 Source Distributions 21 Post-Installation 24 Special Configuration 24 Setting Initial Password for root 25 More on Passwords and Removing Anonymous Users 25 Creating a User 26 3. The Basics and the mysql Client.29 The mysql Client 29
Connecting to the Server 30 Starting to Explore Databases 33 First SQL Commands 34 Inserting and Manipulating Data 36 A Little Complexity 39 Summary 40 Exercises 41 Part II. Database Structures 4. Creating Databases and Tables. . 45 Creating a Database 46 Creating Tables 47 Inserting Data 51 More Perspectives on Tables 52 Summary 56 Exercises 56 5. Altering Tables. . 59 Prudence When Altering Tables 59 Essential Changes 61 Dynamic Columns 68 Optional Changes 71 Setting a Column’s Default Value 71 Setting the Value of AUTOJNCREMENT 73 Another Method to Alter and Create a Table 74 Renaming a Table 77 Reordering a Table 79 Indexes 80 Summary 85 Exercises 85 Partlll. Basics of Handling Data 6. Inserting Data. . 91 The Syntax 91 Practical Examples 93 The Table for Bird Orders 94 The Table for Bird Families 95 The Table for Birds 101 Other Possibilities 104 vi 1 Table of Contents ------------------- -----—
Inserting Emphatically 104 Inserting Data from Another Table 104 A Digression: Setting the Right ID 106 Replacing Data 110 Priorities When Inserting Data 112 Summary 114 Exercises 115 7. Selecting Data. . 119 Basic Selection 120 Selecting by a Criteria 120 Ordering Results 121 Limiting Results 124 Combining Tables 124 Expressions and the Like 127 Counting and Grouping Results 132 Summary 134 Exercises 134 8. Updating and Deleting Data. . 137 Updating Data 137 Updating Specific Rows 138 Limiting Updates 142 Ordering to Make a Difference 143 Updating Multiple Tables 144 Handling Duplicates 146 Deleting Data 149 Deleting in Multiple Tables 150 Summary 151 Exercises 151 9. Joining and Subquerying Data. . 153 Unifying Results 153 Joining Tables 156 Selecting a Basic Join 157 Updating Joined Tables 162 Deleting Within Joined Tables 164 Subqueries 166 Scalar Subqueries 167 Column Subqueries 169 Row Subqueries 170 Table Subqueries 172 Table of Contents 1 vii
Performance Considerations with Subqueries Summary Exercises 173 173 174 Part IV. Built-In Functions String Functions. . 179 Formatting Strings 180 Concatenating Strings 180 Setting Case and Quotes 182 Trimming and Padding Strings 183 Extracting Text 185 Searching Strings and Using Lengths 188 Locating Text Within a String 188 String Lengths 191 Comparing and Searching Strings 192 Replacing and Inserting into Strings 194 Converting String Types 196 Compressing Strings 199 Summary 200 Exercises 200 Date and Time Functions. . 203 Date and Time Data Types 203 Current Date and Time 205 Extracting Date and Time Components 208 Formatting Dates and Time 212 Adjusting to Standards and Time Zones 214 Adding and Subtracting Dates and Time 217 Comparing Dates and Times 222 Summary 226 Exercises 226 Aggregate and Numeric Functions. Aggregate Functions 229 Counting Values 230 Calculating a Group of Values 235 Concatenating a Group 240 Numeric Functions 241 Rounding Numbers 241 Rounding Only Down or Up 244 viii I Table of Contents
Truncating Numbers 245 Eliminating Negative Numbers 245 Summary 247 Exercises 247 Part V. Administration and Beyond 13. User Accounts and Privileges. 253 User Account Basics 253 Restricting the Access of User Accounts 256 Username and Host 256 SQL Privileges 258 Database Components and Privileges 260 Administrative User Accounts 265 User Account for Making Backups 265 User Account for Restoring Backups 266 User Account for Bulk Importing 267 User Account to Grant Privileges 268 Revoking Privileges 269 Deleting a User Account 270 Changing Passwords and Names 272 Setting a User Account Password 272 Renaming a User Account 273 User Roles 274 Summary 276 Exercises 276 14. Backing Up and Restoring Databases. 279 Making Backups 279 Backing Up All Databases 280 Understanding Dump Files 282 Backing Up Specific Databases 288 Creating Backup Scripts 289 Backing Up Specific Tables 290 Restoring Backups 292 Restoring a Database 292 Restoring a Table 293 Restoring Only Rows or Columns 298 Recovering from a Binary Log 300 Developing a Backup Policy 307 Summary 312 Table of Contents | ix
Exercises 312 Bulk Importing Data. . 315 Preparing to Import 315 Loading Data Basics 318 Watching for Warnings 319 Checking the Accuracy of the Import 320 Selecting Imported Data 323 Better Loading 324 Mapping Fields 324 Setting Columns 326 More Field and Line Definitions 327 Starting, Terminating, and Escaping 328 Replacing Data Versus Ignoring Errors 329 Importing from Outside MySQL 330 Importing Local Files 331 Using mysqlimport 331 Importing Without FILE Privileges 332 Bulk Exporting Data 333 Summary 335 Exercises 335 Application Programming Interfaces. . 337 Creating API User Accounts 338 C API 338 Connecting to MySQL 339 Querying MySQL 340 Complete Minimal C API Program 341 Compiling with C Includes 342 Perl DBI 342 Installing 343 Connecting to MySQL 343 Querying MySQL 343 A Full Example with Perl DBI 346 More Information 348 PHP API 348 Installing and Configuring 349 Connecting to MySQL 349 Querying MySQL 350 More Information 353 Python 353 Installing 353 1 Table of Contents ----------------- --------------------
Connecting to MySQL 353 Querying MySQL 354 Sample Python Program 355 More Information 357 Ruby API 357 Installing and Preparing MySQL/Ruby 357 Connecting to MySQL 359 Querying MySQL 360 Sample MySQL/Ruby Program 361 More Information 364 SQL Injection 364 Summary 366 Exercises 366 Index. 369 Table of Contents | xi |
| any_adam_object | 1 |
| author | Dyer, Russell J. T. |
| author_facet | Dyer, Russell J. T. |
| author_role | aut |
| author_sort | Dyer, Russell J. T. |
| author_variant | r j t d rjt rjtd |
| building | Verbundindex |
| bvnumber | BV042571622 |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)910585009 (DE-599)DNB106730794X |
| dewey-full | 004 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 004 - Computer science |
| dewey-raw | 004 |
| dewey-search | 004 |
| dewey-sort | 14 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 1. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 c 4500</leader><controlfield tag="001">BV042571622</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20211118</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">150520s2015 xxu |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">15,N09</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">106730794X</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781449362904</subfield><subfield code="c">Pb. : EUR 41.00 (DE) (freier Pr.), EUR 42.20 (AT) (freier Pr.)</subfield><subfield code="9">978-1-449-36290-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1449362907</subfield><subfield code="9">1-4493-6290-7</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9781449362904</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)910585009</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)DNB106730794X</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</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">XD-US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield><subfield code="a">DE-11</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">004</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">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Dyer, Russell J. T.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Learning MySQL and MariaDB</subfield><subfield code="b">[heading in the right direction with MySQL and MariaDB]</subfield><subfield code="c">Russell J.T. Dyer</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2015</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXIII, 381 S.</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="650" ind1="0" ind2="7"><subfield code="a">MariaDB</subfield><subfield code="0">(DE-588)122947658X</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">MariaDB</subfield><subfield code="0">(DE-588)122947658X</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">X:MVB</subfield><subfield code="q">text/html</subfield><subfield code="u">http://deposit.dnb.de/cgi-bin/dokserv?id=5158436&prov=M&dok_var=1&dok_ext=htm</subfield><subfield code="3">Inhaltstext</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=028005162&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028005162</subfield></datafield></record></collection> |
| id | DE-604.BV042571622 |
| illustrated | Not Illustrated |
| indexdate | 2024-08-03T02:23:35Z |
| institution | BVB |
| isbn | 9781449362904 1449362907 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028005162 |
| oclc_num | 910585009 |
| open_access_boolean | |
| owner | DE-1050 DE-11 |
| owner_facet | DE-1050 DE-11 |
| physical | XXIII, 381 S. |
| publishDate | 2015 |
| publishDateSearch | 2015 |
| publishDateSort | 2015 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Dyer, Russell J. T. Verfasser aut Learning MySQL and MariaDB [heading in the right direction with MySQL and MariaDB] Russell J.T. Dyer 1. ed. Beijing [u.a.] O'Reilly 2015 XXIII, 381 S. txt rdacontent n rdamedia nc rdacarrier MariaDB (DE-588)122947658X gnd rswk-swf MySQL (DE-588)4559381-4 gnd rswk-swf MySQL (DE-588)4559381-4 s MariaDB (DE-588)122947658X s DE-604 X:MVB text/html http://deposit.dnb.de/cgi-bin/dokserv?id=5158436&prov=M&dok_var=1&dok_ext=htm Inhaltstext HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028005162&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Dyer, Russell J. T. Learning MySQL and MariaDB [heading in the right direction with MySQL and MariaDB] MariaDB (DE-588)122947658X gnd MySQL (DE-588)4559381-4 gnd |
| subject_GND | (DE-588)122947658X (DE-588)4559381-4 |
| title | Learning MySQL and MariaDB [heading in the right direction with MySQL and MariaDB] |
| title_auth | Learning MySQL and MariaDB [heading in the right direction with MySQL and MariaDB] |
| title_exact_search | Learning MySQL and MariaDB [heading in the right direction with MySQL and MariaDB] |
| title_full | Learning MySQL and MariaDB [heading in the right direction with MySQL and MariaDB] Russell J.T. Dyer |
| title_fullStr | Learning MySQL and MariaDB [heading in the right direction with MySQL and MariaDB] Russell J.T. Dyer |
| title_full_unstemmed | Learning MySQL and MariaDB [heading in the right direction with MySQL and MariaDB] Russell J.T. Dyer |
| title_short | Learning MySQL and MariaDB |
| title_sort | learning mysql and mariadb heading in the right direction with mysql and mariadb |
| title_sub | [heading in the right direction with MySQL and MariaDB] |
| topic | MariaDB (DE-588)122947658X gnd MySQL (DE-588)4559381-4 gnd |
| topic_facet | MariaDB MySQL |
| url | http://deposit.dnb.de/cgi-bin/dokserv?id=5158436&prov=M&dok_var=1&dok_ext=htm http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028005162&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT dyerrusselljt learningmysqlandmariadbheadingintherightdirectionwithmysqlandmariadb |