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
  10-10-06 

Creating the Blog Script for a PHP/MySQL Blogging System

Jacques Noah 442585

In this second part of a three-part series on blogging with PHP and MySQL, we will be looking at the actual blog. The blog will be simplicity itself. I have created a style sheet that will help in making the blog look clean and neat. The blog will be based purely on a open blog system.

  10-03-06 

Creating a Login Script for a PHP/MySQL Blogging System

Jacques Noah 468307

In this three-part tutorial we are going to be creating an open blogging system. We are also going to provide scripts that will make it possible to switch to a closed blogging system. This article, which is the first part, will cover the creation of the login scripts for a closed system.

  08-24-06 

Optimizing the Logical Database Structure

Sams Publishing 80945

In this final article of our series, you will learn more ways of organizing your data to achieve better query performance. It is excerpted from chapter 13 of the MySQL Certification Guide, written by Paul Dubois et al. (Sams, 2005; ISBN: 0672328127).

  08-17-06 

Enhancing MySQL Query Efficiency

Sams Publishing 235846

There are a number of things you can do in general to optimize your queries and make them more efficient. This article discusses several of these. It is excerpted from chapter 13 of the MySQL Certification Guide, written by Paul Dubois et al. (Sams, 2005; ISBN: 0672328127).

  08-10-06 

Analyzing Queries for Speed with EXPLAIN

Sams Publishing 198637

When you are trying to optimize your queries to run quickly and efficiently, you may encounter queries that really should run faster. That's where EXPLAIN comes in handy. This article shows you how to use EXPLAIN in query analysis. It is excerpted from chapter 13 of the MySQL Certification Guide, written by Paul Dubois et al. (Sams, 2005; ISBN: 0672328127).

  08-03-06 

Optimizing for Query Speed

Sams Publishing 208441

Optimzing your queries can help them run more efficiently, which can save a significant amount of time. This article covers index optimization and index usage. It is excerpted from chapter 13 of the MySQL Certification Guide, written by Paul Dubois et al. (Sams, 2005; ISBN: 0672328127).

  07-27-06 

Client Access Control with MySQL

Sams Publishing 76170

In our third and final article covering MySQL security, you will learn about client access control. There are exercises included (with answers) so you can test yourself on what you learned. This article is excerpted from chapter 12 of the MySQL 5.0 Certification Guide, written by Paul Dubois et al. (Sams, 2005; ISBN: 0672328127).

  07-20-06 

MySQL User Account Management

Sams Publishing 269769

Last week, we began our discussion of MySQL database security. This week, we continue that discussion with user account management. The second of several parts, this article is excerpted from chapter 12 of the MySQL 5.0 Certification Guide, written by Paul Dubois et al. (Sams, 2005; ISBN: 0672328127).

  07-13-06 

Security Issues with MySQL

Sams Publishing 64796

If you maintain a MySQL database, you understand the importance of security. This article covers that topic in detail. The first of several parts, it is excerpted from chapter 12 of the MySQL 5.0 Certification Guide, written by Paul Dubois et al. (Sams, 2005; ISBN: 0672328127).

  07-10-06 

Implementing Additional Methods with mysqli and PHP 5

Alejandro Gervasio 51787

Welcome to the third installment of the series "Using mysqli in PHP 5." Comprised of three articles, this series teaches you how to use the most important methods and properties included in the "mysqli" extension, which is bundled with PHP 5, in order to get the most out of the MySQL 4.1 database server and above.

  07-06-06 

Advanced MySQL Database Administration

Sams Publishing 127896

If you need to administer MySQL, this article gets you off to a good start. In this section, we discuss running multiple MySQL servers on the same machine, and the MySQL Query cache. The final installment of a multi-part series, it is excerpted from chapter four of the book MySQL Administrator's Guide, written by Paul Dubois (Sams; ISBN: 0672326345).

  07-03-06 

Implementing the commit() and rollback() Methods with mysqli and PHP 5

Alejandro Gervasio 97780

If you want to use the "mysqli" extension, you've come to the right place. This is the second part of the series “Using mysqli with PHP 5.” Welcome back. In three tutorials, this series shows how to use the most important methods and properties included in the “mysqli” extension that comes with PHP 5, in order to take advantage of the new features bundled with MySQL 4.1 and above.

  06-29-06 

Administering MySQL: International Usage and Log Files

Sams Publishing 56971

If you need to administer MySQL, this article gets you off to a good start. In this section, we discuss localization and international usage, as well as the MySQL log files. The sixth of a multi-part series, it is excerpted from chapter four of the book MySQL Administrator's Guide, written by Paul Dubois (Sams; ISBN: 0672326345).

  06-27-06 

Performing Basic Tasks with MySQL 4.1 and Above, using mysqli with PHP 5

Alejandro Gervasio 63389

For anyone who has spent a few weeks working with PHP 5, the plethora of cool improvements and new features added to this incarnation of the language has brought a new, more powerful level for developing and deploying Web applications. These include the implementation of exceptions and the brand new object model. But what if I tell you that now you can use PHP 5 to work with MySQL, using an object-oriented approach?

  06-22-06 

Disaster Prevention and Recovery with the MySQL Database

Sams Publishing 82388

If you need to administer MySQL, this article gets you off to a good start. In this section, we discuss the issues of disaster prevention and recovery. The fifth of a multi-part series, it is excerpted from chapter four of the book MySQL Administrator's Guide, written by Paul Dubois (Sams; ISBN: 0672326345).

 
More MySQL Articles
Total MySQL Articles = 173

Page 7 of 12
4 5 6 7 8 9 10 

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: