Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Posted Oct 1, 2002

Ian Gilfillan

By DatabaseJournal.com Staff

Ian Gilfillan lives in Cape Town, South Africa. He is the author of the book 'Mastering MySQL 4', published by Sybex, and has been working with MySQL since 1997. These days he develops mainly in PHP and MySQL, although confesses to starting out with BASIC and COBOL, way back when, and still has a soft spot for Perl. He developed South Africa's first online grocery store, and has developed and taught internet development and other technical courses for various institutions. He has majors in Programming and Information Systems, as well as English and Philosophy. For 5 years he was Lead Developer and IT Manager for Independent Online, South Africa's premier news portal. However, he has now 'retired' from fulltime work, and is hoping that his next book will be more in the style of William Blake and Allen Ginsberg.


Series Articles

Tomorrow's Contender

MySQL Storage Engines

Transactions in MySQL

MySQL Stored Procedures and Functions

MySQL Date and Time Functions

Current Articles

MySQL and Character Sets
A Database Journal Guide to MySQL 5 Certification: The DBA Stream
A Database Journal Guide to MySQL 5 Certification
MySQL, today's contender
Connecting and prepared statements with the mysqli extension
MySQL 5.1 - the next generation
Pressure on MySQL increases as Oracle purchases Sleepycat, with more to come
Date and Time in MySQL 5
MySQL Stored Functions
Oracle's purchase of InnoDB, their release of Oracle Express, and the effect on MySQL
MySQL Stored Procedures: Part 3
MySQL Stored Procedures: Part 2
MySQL Stored Procedures: Part 1
MySQL Oddities
MySQL 5 Storage Engines
A Database Journal Guide to MySQL Certification: Part 2, Professional Certification
A Database Journal Guide to MySQL Certification: Part 1, Core Certification
Open Source Databases: A brief look at the Berkeley DB, Derby, Firebird, Ingres, MySQL and PostgreSQL DBMS'
The HAVING and GROUP BY SQL clauses
MySQL Query Browser
MySQL Administrator
MySQL Subqueries
MySQL backups
MySQL Transactions, Part III - BDB Tables, Table locking and Savepoints
MySQL Transactions, Part II - Transaction Isolation Levels
Transactions in MySQL
Optimizing the mysqld variables
Database Replication in MySQL
MySQL, Still tomorrow's contender?
Restoring lost data from the Binary Update Log
An introduction to MySQL permissions
Repairing Database Corruption in MySQL
PostgreSQL vs MySQL: Which is better?
MySQL's Query Cache
Table types in MySQL: Part 2 - InnoDB tables
Table types in MySQL: Part 1 - HEAP tables
Referential Integrity in MySQL
An introduction to the ADOdb class library for PHP, Part 2
An introduction to the ADOdb class library for PHP
MySQL--Yesterday's Toy, Tomorrow's Contender
Deleting Duplicate Rows in a MySQL Database
MySQL date and time functions, Part 2
MySQL date and time functions, Part 1
More MySQL logs
MySQL's Over-looked and Under-worked Slow Query Log
Using Fulltext Indexes in MySQL - Part 2, Boolean searches
Using Fulltext Indexes in MySQL - Part 1
Using a MySQL database with PHP
Introduction to Relational Databases
Database Normalization
SQL joins - multi-table queries
Optimizing MySQL: Hardware and the Mysqld Variables
Optimizing MySQL: Queries and Indexes
Database Normalization

Comment and Contribute


(Maximum characters: 1200). You have characters left.