Russell Dyer - MySQL in a Nutshell
Here you can read online Russell Dyer - MySQL in a Nutshell full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2009, publisher: OReilly Media, genre: Home and family. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:MySQL in a Nutshell
- Author:
- Publisher:OReilly Media
- Genre:
- Year:2009
- Rating:3 / 5
- Favourites:Add to favourites
- Your mark:
MySQL in a Nutshell: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "MySQL in a Nutshell" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Need to find something in MySQL? This convenient reference offers you all the details you need, day in and day out, in one concise and extremely well organized book. The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. Its ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference.
Russell Dyer: author's other books
Who wrote MySQL in a Nutshell? Find out the surname, the name of the author of the book and a list of all author's works by series.
![Kline Kevin E. - SQL in a nutshell: [a desktop quick reference ; covers MySQL, Oracle, PostgreSQL, and SQL server]](/uploads/posts/book/138111/thumbs/kline-kevin-e-sql-in-a-nutshell-a-desktop.jpg)
MySQL in a Nutshell — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "MySQL in a Nutshell" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Copyright 2009 Russell Dyer
OReilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles (.
Nutshell Handbook, the Nutshell Handbook logo, and the OReilly logo are registered trademarks of OReilly Media, Inc. MySQL in a Nutshell , the image of a pied kingfisher, and related trade dress are trademarks of OReilly Media, Inc.
Many of the designations uses by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and OReilly Media, Inc. was aware of a trademark claim, the designations have been printed in caps or initial caps.
While every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.
To my friend Richard Stringer, for encouraging me in literature, liberalism, and writing, and for helping me to become the person I was meant to be.
MySQL is the most popular open source database system available. Although its free, its still very dependable and fast, and is being employed increasingly in areas that used to be the province of Oracle or MS SQL Server. Thanks to a variety of utilities packaged with MySQL, administration is fairly effortless. With its several application programming interfaces (APIs), its easy to develop your own software to interface with MySQL.
This book provides a quick reference to MySQL statements and functions, the administrative utilities, and the most popular APIs. The first few chapters are designed to help you to get started with MySQL. Each chapter on an API also starts with a tutorial.
When this book was written, version 5.0 of MySQL was generally available, and early releases of the development versions of 5.1 and 6.0 were available but not yet stable. As a result, you will find mostly features from version 5.0. x in this book. Features that appear only in newer versions are noted as such.
The purpose of this book is to provide a quick reference to:
MySQL statements and functions
Command-line options and configuration information for the MySQL server and utilities
The most popular APIs used to access MySQL databases
Several chapters start with tutorials, but the central purpose of the book is to fill in the gaps for people who are already comfortable with relational databases.
The format that Ive followed for a description of each statement or function is to move from curt memory-joggers to more leisurely explanations. If you know the statement or function that youre looking up, but cant quite remember the syntax, youll find that first. If you need a bit more information to jog your memory or to clarify the possibilities available, you can find this in the first sentence or so of the explanation. If you require more clarification, you can continue with the slower-paced material that will follow a statement or function. Examples of usage are provided for almost all statements and functions.
In summary, the goal is to be brief but fairly complete, and to increase the level of detail as you read on.
This book is broken up into 14 chapters and 3 appendixes, as follows.
, explains the major components of MySQL and useful guidelines for other information on MySQL.
, describes how to get MySQL running on common operating systems supported by MySQL AB. It is necessary to read this chapter only if your system does not already have MySQL installed.
, introduces SQL (Structured Query Language) and use of the mysql command-line interface. Its not a replacement for learning SQL and relational database design, but it can be useful to orient you to MySQL.
, covers SQL statements and functions related to the management of user accounts and security.
, lists, explains, and provides examples of SQL statements and functions related to the creating, altering, and dropping of databases, tables, indexes, and views.
, covers any SQL statements and functions that involve the manipulation of datainserting, updating, replacing, or deleting.
, includes details and examples related to SQL statements and functions that might be used in the administration of databases, tables, or the server.
, includes SQL statements that strictly relate to replication. This chapter also includes a tutorial and an explanation of the replication process. It also explains the replication states to help in solving problems.
, covers statements specifically related to events, stored procedures, triggers , and user-defined functions.
, combines aggregate clauses (i.e., GROUP BY) and functions that basically are only used with an aggregate clause. It also includes a tutorial on subqueries as they can be used to aggregate data.
, covers any functions that are related to the manipulation of strings of data.
, covers date and time related functions.
, explains and gives examples of strictly mathematical related functions.
, covers flow control functions such as CASE and IF.
, covers the mysqld daemon and the mysql client and their options. It also explains scripts used to start the server (e.g., mysqld_safe).
, describes the utilities that can be used to administer the MySQL server and data. It also includes utilities such as mysqldump used for data backups.
, covers the functions provided by MySQLs basic C library.
, presents the Perl DBI module, used to access MySQL databases from the programming language Perl.
, presents the PHP functions used to query and manipulate MySQL databases .
lists all the data types supported by MySQL.
lists all MySQL operators, such as arithmetic signs and the LIKE and IS NULL comparison operators.
lists the operating systems environment variables consulted by the MySQL server, client, and other utilities.
The following typographical conventions are used in this book:
Indicates menu titles, menu options, menu buttons, and keyboard accelerators (such as Alt and Ctrl).
ItalicIndicates new terms, URLs, email addresses, usernames, hostnames, filenames, file extensions, pathnames, and directories.
Constant widthIndicates elements of code, configuration options, variables, functions, modules, databases, tables, columns, command-line utilities, the contents of files, or the output from commands.
Constant width boldShows commands or other text that should be typed literally by the user.
Constant width italicShows text that should be replaced with user-supplied values.
This book is here to help you get your job done. In general, you may use the code in this book in your programs and documentation. You do not need to contact us for permission unless youre reproducing a significant portion of the code. For example, writing a program that uses several chunks of code from this book does not require permission. Selling or distributing a CD-ROM of examples from OReilly books does require permission. Answering a question by citing this book and quoting example code does not require permission. Incorporating a significant amount of example code from this book into your products documentation does require permission.
Font size:
Interval:
Bookmark:
Similar books «MySQL in a Nutshell»
Look at similar books to MySQL in a Nutshell. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book MySQL in a Nutshell and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.