Learn the three main basic data types used in MySQL and how to utilize them to build a more effective dynamic web site. Lots of web developers use MySQL but not all of them harness the power of these features.

One of the great characteristics of SQL (Structured Query Language) is the fact that one can develop access and modify data across various tables. There are several benefits to this, including greater ease of manipulation, increased speed of access, and reduced data redundancy. In MySQL (as well as many other SQL languages), this is accomplished via the join command. This tutorial takes a look at several types of the join command including The Cross Join, The Equi-join, The Left Join, and Self-joins.

Everyone who likes MS HTML Help (.chm extension) can now obtain complete conversion of MySQL manual into this format. This conversion tries to bring additional functionality and make using of MySQL manual more comfortable.

This article describes how to make Access and PHP work together using the ODBCSocketServer, an open source socket server, available at http://odbc.linuxave.net/. This tutorial will take you through configuring your machines and using the socket server.

ODBC is one of Microsoft's earliest technologies for connecting to databases. This article describes how to setup and use ODBC from a PHP perspective. Also discusses ODBC extension bugs, database wrapper libraries, Microsoft's ADO (which is Microsoft's recommended API for 4GL programmers) and DSN-less connections.

PHP provides built in functions to access just about every database that exists, including Oracle. This 8-page tutorial illustrates how to use these built in functions to communicate with an Oracle database.

Even though loading data from a text file into the database is not a task that user would perform on a daily basis, there are several cases when the speed of this process is important to DBA and company management. One example would be having a "database guy" receive the daily reports from the field offices or sales people on daily basis. Reports come as Excel documents or delimited spreadsheets of some kind, and DBA's responsibility includes updating the database on constant basis, so that by the end of the day, he is able to give the management a report on the amount of daily sales or field office transactions. Here you will find a MS Word-format downloadable file that examines the benchmark results for Oracle and MySQL speed of loading the data from a text file.

Following examples teaches how to query a mySQL database and getting results in pages. Every page displays results maximum 10 results in a single page.

This tutorial is the second part of our PHP/MYSQL series of articles. In this episode we show you setting up a MYSQL Database through phpmyadmin and create a PHP Script to make tables for the MYSQL database and more.

This is the third installment of our php mysql tutorial series. This tutorial covers inserting data to MYSQL with a PHP script. Using the following key features; HTML Forms, Passing variables from a form to php and inserting into the database using Mysql INSERT command.