|
Free ebooks
 Free database ebooks SQL MySQL in a Nutshell (2nd edition) - A Desktop Quick Reference
|
 Chapter 1, explains the major components of MySQL and useful guidelines for other information on MySQL.Chapter 2, 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. Chapter 3, introduces SQL (Structured Query Language) and use of the mysql command-line interface. It's not a replacement for learning SQL and relational database design, but it can be useful to orient you to MySQL. Chapter 4, covers SQL statements and functions related to the management of user accounts and security. Chapter 5, lists, explains, and provides examples of SQL statements and functions related to the creating, altering, and dropping of databases, tables, indexes, and views. Chapter 6, covers any SQL statements and functions that involve the manipulation of data—inserting, updating, replacing, or deleting. Chapter 7, includes details and examples related to SQL statements and functions that might be used in the administration of databases, tables, or the server. Chapter 8, 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. Chapter 9, covers statements specifically related to events, stored procedures, triggers, and user-defined functions. Chapter 10, 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. Chapter 11, covers any functions that are related to the manipulation of strings of data. Chapter 12, covers date and time related functions. Chapter 13, explains and gives examples of strictly mathematical related functions. Chapter 14, covers flow control functions such as CASE and IF. Chapter 15, covers the mysqld daemon and the mysql client and their options. It also explains scripts used to start the server (e.g., mysqld_safe). Chapter 16, 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. Chapter 17, covers the functions provided by MySQL's basic C library. Chapter 18, presents the Perl DBI module, used to access MySQL databases from the programming language Perl. Chapter 19, presents the PHP functions used to query and manipulate MySQL databases. Download free pdf ebooks for sql:MySQL in a Nutshell (2nd edition)
|
