MySQL

43 Items

Sort by Date | Title

An Overview of MySQL Query Browser's Features and Capabilities Sep 23, 2005 This chapter discusses MySQL Query Browser, a client program that provides a graphical interface to the MySQL server for querying and analyzing data.

MySQL Overview and New Performance-Related Features Jun 24, 2005 This chapter provides an overview of the various MySQL iterations, and how they are covered within the rest of the book, along with the environments in which they were used for the book. Finally, there is a list of performance enhancements and the version of MySQL in which they were introduced.

MySQL Query Optimization Apr 22, 2005 Database management systems implement abstract concepts but do so on real hardware bound by real physical constraints. As a result, queries take time—sometimes an annoyingly long time. Find out how to minimize your wait in this sample chapter.

MySQL SQL Syntax and Use Apr 8, 2005 This chapter provides an overview of the naming conventions and other syntax necessary to work in MySQL. Going through this chapter will also help you to get started in SQL by teaching you various commands and shortcuts that will help the SQL beginner.

Working with Data in MySQL Apr 8, 2005 Virtually everything you do in MySQL involves data in some way or another because the purpose of a database management system is, by definition, to manage data. This chapter will help you get started working with data in SQL.

Getting Started with MySQL and SQL Apr 1, 2005 Perfect for SQL novices, this chapter provides an introduction to the MySQL relational database management system (RDBMS), and to the Structured Query Language (SQL) that MySQL understands.

Using MySQL Programs Sep 24, 2004 This chapter provides a brief overview of the programs provided by MySQL AB and discusses how to specify options when you run these programs.

MySQL Character Set Support Aug 27, 2004 Even if you use another SQL database, this sample chapter from the MySQL Language Reference may be awesomely helpful. In addition to explaining the new syntax in MySQL 4.1 (such as Unicode support), it explains what character sets and collations are, along with the multiple-level default system and the meaning of each individual character set and collation.

Using MySQL Client Programs Jul 23, 2004 This chapter discusses general principles that are common to most MySQL client programs. It also describes how to use several specific types of clients. Sample questions with detailed answers are provided at the end of the chapter to help you prepare.

Database Design Crash Course Dec 11, 2003 Need a brain-transplant to grasp (or refresh) database fundamentals, including design principles and normalization? Look no further. In just a few pages, you'll get the straight answers.

Accessing a MySQL Database from a C++ CGI Program Oct 31, 2003 If you want to access a MySQL database through CGI, C++ is a great option. Sure, you can use other languages such as PHP or Perl, and they might be easy to use, but C++ has the advantage of being fast, powerful, and fully compiled, thereby hiding your original code. In this article, Jeff Cogswell shows you how you can write CGI programs in C++ to access a MySQL database.

Using Arrays in PHP May 30, 2003 Explore the function and potential of using arrays. You will learn how to sort arrays and manipulate them to exhaust their potential in association with your goal.

Why MySQL? Apr 11, 2003 Explore an Open Source (GPL) Standard Query Language (SQL) database that is fast, reliable, easy to use, and suitable for applications of any size. Learn the important SQL commands and how to automate database interaction with Perl and the DataBase Independent interface (DBI).

Using the MySQL Client Library to Write Your Own Programs Jan 10, 2003 Write your own client programs in C with the MySQL Client Library. Follow these guidelines to maintain consistency with existing client programs in the MySQL distribution, as well as modularity and reusability of your code. Create a series of programs from a simple server connection to an interactive query.

Optimizing and Tuning Your MySQL Database Sep 20, 2002 This lesson gives you pointers for optimizing and tuning your database so that you get the most bang for your buck.

MySQL Transactions Overview Sep 13, 2002 One of the greatest additions to MySQL in recent versions is its support for transactional processing. Gain an understanding of the benefits of transactions, and more importantly, how to use them in your applications.

Selecting Data from Your MySQL Tables Sep 6, 2002 This sample chapter starts to teach you how to get data into, out of, and removed from your tables. No knowledge of the SQL syntax is assumed, but when you're through with this lesson you will be able to get everything out of your tables, sorted and delineated in exactly the manner you wanted.

MySQL: Learning the Database Design Process Jun 21, 2002 Learn proper database design — It's the only way your application will be efficient, flexible, and easy to manage and maintain. This process requires discussing the rules, requirements, and objectives before creating and normalizing the tables in your relational DB.

MySQL: Order Entry Abstract and Design Nov 2, 2001 This sample chapter from MySQL: Building User Interfaces uses a "real world" example to evaluate the use of Linux and MySQL for a particular application. Matthew Stucky provides a basic design, and explains what the application should do and why.

Transactions in MySQL Sep 21, 2001 MySQL now has the capability to execute transactions. In this article, Paul Dubois, the author of MySQL and Perl for the Web explains this new feature and how it works with DBI.

< Prev Page 1 2 3 Next >