Home arrow MySQL
 

MYSQL HELP, MYSQL TUTORIALS, MYSQL PROGRAMMING, LEARN MYSQL TRICKS

RSS For Dev Shed
Learn MySQL or get MySQL Help at DevShed. MySQL is an open source relational database management system (RDBMS). It uses Structured Query Language (SQL). While it is typically run on Linux/UNIX platforms and used with PHP, it can be run on Windows and Mac OS X. If you want to use a fast, reliable, flexible open source RDBMS, we have the MySQL tutorials to get you where you need to go, right here.

  Date Title Author Hits
  03-02-06 

Advanced Query Writing

McGraw-Hill/Osborne 140383

This article, the first of two parts, covers some advanced topics concerning SQL queries and functions. It is excerpted from chapter six of the book SQL DeMYSTiFied, written by Andrew Oppel (McGraw-Hill/Osborne, 2005; ISBN: 0072262249).

  02-13-06 

Database Design Using Key-Value Tables

Tal Olier 229774

In the following article we are going to cover the use of key-value tables in a database design. They can help you with flexibility in design, but will trip you up in other areas (such as data filtering) if you are not careful. I assume that the audience for the following article is familiar with basic traditional relational database design and SQL language; nevertheless, someone that is not familiar with it should be able to comprehend it from the walkthrough example of this article.

  11-10-05 

Building a Simple Affiliate System in PHP/MySQL

Roger Stringer 211280

Setting up an affiliate system on your website can be very lucrative. While there are a lot of details involved, it need not be overly complicated. This article walks you through the steps of creating and setting up a basic affiliate system.

  09-15-05 

Database Applications and the Web

O'Reilly Media 151495

With most of the services on the web being powered by web database applications, it becomes important for any web developer to know how bring together the web and databases to build applications. This article gets you started. It is excerpted from chapter one of the book Web Database Applications with PHP and MySQL, written by Hugh E. Williams & David Lane (O'Reilly, 2004; ISBN: 0596005431).

  08-03-05 

Data Management Made Easy Using Nennius: Advanced Data Handling

Brian Vaughn 38560

Welcome to part three of this tutorial introducing application development for the Nennius engine. In this article, we will enhance the News Manager application from part two.

  07-27-05 

Data Management Made Easy Using Nennius: Creating a Web Application

Brian Vaughn 32663

Previously, we took a look at the Nennius engine and discussed several out-of-the-box features available to PHP developers. Now we are ready to create our own Nennius web application, and so we will discuss all of the steps necessary to do that.

  07-20-05 

Data Management Made Easy Using Nennius: Introducing Nennius

Brian Vaughn 30749

PHP allows for the simple creation of many useful tools, such as creating a contact form. However, creating a data management system in PHP is not so simple. Since many end users are familiar with the Internet, Web developers often find themselves needing to create a Web-based interface to allow for meaningful interaction with data.  Nennius is a data management tool that can make this task easier. This article, the first of three parts, provides an overview of this tool.

  06-02-05 

MySQL Configuration and Installation

McGraw-Hill/Osborne 340366

If you ever wanted to start using the open source MySQL server application on your computer, this article is for you. It will show you how to obtain, install, configure, and test the MySQL server on your system, whether you are running UNIX or Windows. It is excerpted from My SQL The Complete Reference by Vikram Vaswani (McGraw-Hill/Osborne, 2003; ISBN: 0072224770).

  04-20-05 

MySQL Optimization, part 2

Sams Publishing 398811

While optimization is possible with limited knowledge of your system or application, the more you know about your system, the better your optimization will be. This article, the second of two parts, covers some of the different points you will need to know for optimizing MySQL. It is excerpted from chapter six of the book MySQL Administrator's Guide, by MySQL AB (Sams, 2004; ISBN: 0672326345).

  04-13-05 

MySQL Optimization, part 1

Sams Publishing 417423

While optimization is possible with limited knowledge of your system or application, the more you know about your system, the better your optimization will be. This article, the first of two parts, covers some of the different points you will need to know for optimizing MySQL. It is excerpted from chapter six of the book MySQL Administrator's Guide, by MySQL AB (Sams, 2004; ISBN: 0672326345)

  03-14-05 

What’s New In MySQL 4.1 Part One: Overview and Subqueries

David Fells 71742

The current release of MySQL, version 4.1.10, offers significant improvements over version 4. While it still has some room for improvement, its new features and capabilities should silence the critics who have up until now regarded it as little more than a toy. In this article, the first of two parts, David Fells covers scalar and correlated queries, derived tables, and row level subqueries.

  01-26-05 

Data Definition Language, Part 2

Sams Publishing 65001

Studying for the MySQL Certification exam? This article, the second of two parts, covers the remainder of roughly 20 percent of the material that will appear on the exam, and includes several sections with questions and answers covering both articles. It is excerpted from chapter four of the book MySQL Certification Guide written by Paul Dubois et. al. (Sams, 2004, ISBN: 0672326329).

  01-19-05 

Data Definition Language, Part 1

Sams Publishing 173775

Studying for the MySQL Certification exam? This article, the first of two parts, covers roughly 10 percent of the material that will appear on the exam, including general database and table properties, storage engines and table types, and more. It is excerpted from chapter four of the book MySQL Certification Guide written by Paul Dubois et. al. (Sams, 2004, ISBN: 0672326329).

  11-29-04 

Counting Queries: PostgreSQL Analysis

Tom Copeland 41012

There are a number of ways to get your database-backed Web application to run faster on the same hardware--allowing you to postpone upgrades for at least a little while, thus cutting costs. One way involves examining how your applications are interacting with the database. Tom Copeland explains how to "tune the queries" for a PostgreSQL database.

  11-10-04 

The Future of SQL

McGraw-Hill/Osborne 72455

In this article, Vikram Vaswani discusses the ways in which SQL plays an important role in the computer market today, and what may be in store for this database language in the future. This excerpt comes from chapter 26 of MySQL: The Complete Reference, by Vikram Vaswani (McGraw-Hill/Osborne, ISBN 0-07-222477-0, 2004).

 
More MySQL Articles
Total MySQL Articles = 173

Page 9 of 12
6 7 8 9 10 11 12 

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: