- 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.
|
- Accessing Your MySQL Database from the Web with PHP
- Sep 30, 2008
- In this chapter, learn how to access a database from the Web using PHP, read from and write to the database, and filter potentially troublesome input data.
|
- Alternatives to LAMP
- Jun 2, 2006
- The LAMP configuration (Linux, Apache, MySQL, and PHP) is familiar to the open source universe. But just because this combination of products is comfortable, that doesn't mean that it provides the best solution for your systems. David Chisnall suggests some alternatives that might make a better match for your needs.
|
- 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.
|
- Creating an Online Storefront in PHP, MySQL and Apache, Part 1
- Jun 25, 2008
- Learn the design process behind a simple discussion forum.
|
- Creating an Online Storefront in PHP, MySQL and Apache, Part 2
- Jul 2, 2008
- In Part 2 of this chapter, you’ll learn the design process behind a simple discussion forum; specifically, displaying the topic list.
|
- Creating an Online Storefront in PHP, MySQL and Apache, Part 3
- Jul 7, 2008
- Learn the design process behind a simple discussion forum.
|
- Creating an Online Storefront in PHP, MySQL and Apache, Part 4
- Jul 15, 2008
- Learn the design process behind a simple discussion forum.
|
- Data Types in MySQL
- Aug 16, 2008
- Learn the types of data values that MySQL can handle and the issues involved in working with those types.
|
- 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.
|
- End-to-End JPA Collections with MySQL, Part 1
- Apr 30, 2012
- Having difficulty getting your JPA collection code up and running? Stephen Morris demonstrates an end-to-end, working example of a JPA collection in this first part of a two-part series.
|
- End-to-End JPA Collections with MySQL, Part 2
- May 1, 2012
- Stephen Morris provides simple, end-to-end working code illustrating how to modify JPA collection code. Also, the area of MySQL stored procedures is looked at, using some simple examples in this the concluding part of a two-part series.
|
- 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.
|
- 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.
|
- 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.
|
- 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.
|
- 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.
|