Beginning databases with MySQL

By: Matthew, NeilContributor(s): Stones, RichardMaterial type: TextTextPublication details: Mumbai : Shroff Publishers., 2002Description: xi, 575 p. : illustrationsISBN: 1861006926 ; 9781861006929Subject(s): SQL (Computer program language) | Relational databasesDDC classification: 005.7565
Contents:
Chapter 1 Introduction To MySQL 07 -- Chapter 2 Relational Database Principles 23 -- Chapter 3 Installing and Getting Started with MySQL 49 -- Chapter 4 Accessing Your Data 79 -- Chapter 5 MySQL Graphical Tools 119 -- Chapter 6 Changing Your Data 155 -- Chapter 7 Advanced Data Selection 179 -- Chapter 8 Data Definition and Manipulation 209 -- Chapter 9 Transactions and Locking 253 -- Chapter 10 MySQL Administration 279 -- Chapter 11 Database Design 311 -- Chapter 12 Accessing MySQL from C and C++ 341 -- Chapter 13 Accessing MySQL from PHP 385 -- Chapter 14 Accessing MySQL from Perl 425 -- Chapter 15 Accessing MySQL from Java 463 -- Chapter 16 Further Information and Resources 509 -- Appendix A MySQL Database Limits 517 -- Appendix B MySQL Data Types 521 -- Appendix C MySQL SQL Syntax 527 -- Appendix D mysql Reference 539 -- Appendix E Database Schema and Tables 543 -- Appendix F Large Objects Support in MySQL 547.
Summary: MySQL is the world's most popular Open Source Relational Database designed for speed, power, and precision in heavy load use. MySQL AB is the company owned and run by the MySQL founders and main developers. MySQL offers the database programmer with a range of options and capabilities rarely seen in other database servers. MySQL runs under a broad array of operating systems. This book is a complete tutorial on MySQL features and functions and takes you through the whole process from installation and configuration of MySQL to executing commands and basic administration of the database server. We'll show you how to integrate MySQL with programming languages for the Web. What does this book cover? - Detailed tutorial in MySQL - Installing from binaries and source code on UNIX and Windows - Working with graphical tools - Various forms of queries, subqueries, aggregate functions, and joins - Discussion on transactions and locking - Performance monitoring, tuning, and server control - Connecting and executing SQL statements using C and C++ - Developing applications in PHP, Perl, and Java using MySQL
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)
Holdings
Item type Current library Collection Call number Status Date due Barcode Item holds
Reference Books Reference Books Main Library
Reference
Reference 005.7565 MAT (Browse shelf(Opens below)) Available 009513
Total holds: 0

"Programmer to programmer"--Cover.
Includes index.

Chapter 1 Introduction To MySQL 07 --
Chapter 2 Relational Database Principles 23 --
Chapter 3 Installing and Getting Started with MySQL 49 --
Chapter 4 Accessing Your Data 79 --
Chapter 5 MySQL Graphical Tools 119 --
Chapter 6 Changing Your Data 155 --
Chapter 7 Advanced Data Selection 179 --
Chapter 8 Data Definition and Manipulation 209 --
Chapter 9 Transactions and Locking 253 --
Chapter 10 MySQL Administration 279 --
Chapter 11 Database Design 311 --
Chapter 12 Accessing MySQL from C and C++ 341 --
Chapter 13 Accessing MySQL from PHP 385 --
Chapter 14 Accessing MySQL from Perl 425 --
Chapter 15 Accessing MySQL from Java 463 --
Chapter 16 Further Information and Resources 509 --
Appendix A MySQL Database Limits 517 --
Appendix B MySQL Data Types 521 --
Appendix C MySQL SQL Syntax 527 --
Appendix D mysql Reference 539 --
Appendix E Database Schema and Tables 543 --
Appendix F Large Objects Support in MySQL 547.

MySQL is the world's most popular Open Source Relational Database designed for speed, power, and precision in heavy load use. MySQL AB is the company owned and run by the MySQL founders and main developers. MySQL offers the database programmer with a range of options and capabilities rarely seen in other database servers. MySQL runs under a broad array of operating systems.
This book is a complete tutorial on MySQL features and functions and takes you through the whole process from installation and configuration of MySQL to executing commands and basic administration of the database server. We'll show you how to integrate MySQL with programming languages for the Web.

What does this book cover?

- Detailed tutorial in MySQL

- Installing from binaries and source code on UNIX and Windows

- Working with graphical tools

- Various forms of queries, subqueries, aggregate functions, and joins

- Discussion on transactions and locking

- Performance monitoring, tuning, and server control

- Connecting and executing SQL statements using C and C++

- Developing applications in PHP, Perl, and Java using MySQL

There are no comments on this title.

to post a comment.

© University of Vavuniya

---