Free Newsletters:
DatabaseDaily  
 		Database Journal
Search Database Journal:
 
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum DBA Videos
internet.com

» Database Journal Home
» DBA Videos
» Database Articles
» Database Tutorials
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» DBA Jobs
» Sitemap

News Via RSS Feed



follow us on Twitter

Marketplace Partners
Be a Marketplace Partner

internet.commerce
Be a Commerce Partner


Mariposa Bot Shipped With Vodafone Smartphone

IT Job Market Heating Up: Report

Bing Makes Strides But Momentum Stalls

internet.com
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers
Database Journal | DBA Support | SQLCourse | SQLCourse2







Programmer Analyst Sr – Oracle E-business (PA)
Next Step Systems
US-PA-Wayne

Justtechjobs.com Post A Job | Post A Resume
October 1, 2002

Ian Gilfillan


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.

Articles:

Series Articles

Tomorrow's Contender
MySQL, today's contender - 5/16/06
MySQL, Still tomorrow's contender? - 4/20/04
MySQL--Yesterday's Toy, Tomorrow's Contender - 5/22/03

MySQL Storage Engines

MySQL 5 Storage Engines - 6/14/05
Table types in MySQL: Part 2 - InnoDB tables - 10/21/03
Table types in MySQL: Part 1 - HEAP tables - 9/16/03

Transactions in MySQL

MySQL Transactions, Part III - BDB Tables, Table locking and Savepoints - 9/21/04
MySQL Transactions, Part II - Transaction Isolation Levels - 8/17/04
Transactions in MySQL - 7/21/04

MySQL Stored Procedures and Functions

MySQL Stored Functions- 12/13/05
Handlers and Cursors- 10/11/05
Advanced Concepts, Including Conditions and Loops- 9/13/05
What are Stored Procedures- 8/9/05

MySQL Date and Time Functions

Date and Time in MySQL 5 - 1/17/06
MySQL date and time functions, Part 2 - 4/15/03
MySQL date and time functions, Part 1 - 4/1/03

Current Articles

MySQL and Character Sets - 10/18/06
A Database Journal Guide to MySQL 5 Certification: The DBA Stream - 8/22/06
A Database Journal Guide to MySQL 5 Certification - 6/27/06
Connecting and prepared statements with the mysqli extension - 4/18/06
MySQL 5.1 - the next generation - 3/21/06
Pressure on MySQL increases as Oracle purchases Sleepycat, with more to come - 2/15/06
Oracle's purchase of InnoDB, their release of Oracle Express, and the effect on MySQL - 11/09/05
MySQL Oddities - 7/12/05
A Database Journal Guide to MySQL Certification: Part 2, Professional Certification - 5/10/05
A Database Journal Guide to MySQL Certification: Part 1, Core Certification- 4/12/05
Open Source Databases: A brief look at the Berkeley DB, Derby, Firebird, Ingres, MySQL and PostgreSQL DBMS' - 3/8/05
The HAVING and GROUP BY SQL clauses - 2/8/05
MySQL Query Browser - 1/19/05
MySQL Administrator - 12/21/04
MySQL Subqueries - 11/15/04
MySQL backups - 10/19/04
Optimizing the mysqld variables - 6/15/04
Database Replication in MySQL - 5/18/04
Restoring lost data from the Binary Update Log - 3/17/04
An introduction to MySQL permissions - 2/17/04
Repairing Database Corruption in MySQL - 1/21/04
PostgreSQL vs MySQL: Which is better? - 12/16/03
MySQL's Query Cache - 11/18/03
Referential Integrity in MySQL - 8/19/03
An introduction to the ADOdb class library for PHP, Part 2 - 7/15/03
An introduction to the ADOdb class library for PHP - 6/17/03
Deleting Duplicate Rows in a MySQL Database - 5/06/03
More MySQL logs - 3/18/03
MySQL's Over-looked and Under-worked Slow Query Log - 3/4/03
Using Fulltext Indexes in MySQL - Part 2, Boolean searches - 2/19/2003
Using Fulltext Indexes in MySQL - Part 1 - 2/03/2003
Using a MySQL database with PHP - 9/24/2002
SQL Joins - Multi-table Queries
Optimizing MySQL: Hardware and the Mysqld Variables
Optimizing MySQL: Queries and Indexes
Introduction to Relational Databases
Introduction to Relational Databases
Database Normalization




Tools:
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
IE 7 | Firefox 2.0 | Firefox 1.5.x
Receive news via our XML/RSS feed








Latest Forum Threads
Database Journal Home Forum
Topic By Replies Updated
Linked Table in Access database apcalogic 1 March 11th, 09:53 AM
What does * mean tonyd 1 March 11th, 09:07 AM
Index problem recon 3 March 11th, 09:05 AM
Execute process task - doesn't run exe mattisimo 3 March 11th, 08:57 AM









The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers

Solutions

Whitepapers and eBooks

Intel Whitepaper: 2010 Intel Core vPro Processors Overview
Article: Adobe Helps PHP Developers Create Rich Internet Applications
Article: Reduce Your Infrastructure Costs with Microsoft System Center
Intel Brief: Five-Star IT Support--Intel Core 2 processor with vPro Delivers ROI of 524 Percent
Article: Security Enhancements Abound in Windows Server 2008
Intel Whitepaper: Implementing Intel vPro Technology to Drive Down Client Management Costs
Microsoft Whitepaper: Improve Communications and Collaboration
 Intel Article: Intel Core i5 vPro Brings Intelligence to the Processor
Microsoft Personalized Whitepapers and Resources for You
Microsoft Articles: Visual Studio 2010
Adobe Article: Java Developers Finding a Home at Adobe Flex
Microsoft Whitepaper: Make Better Decisions - SQL Server 2008 Business Intelligence.
MORE WHITEPAPERS, EBOOKS, AND ARTICLES

Webcasts

Micro Focus Webcast: Boosting the Impact and Effectiveness of Software Development QA and Testing
Microsoft Webcast: Simplified Access and Single Sign-On
Intel Video: 2010 Intel Core Processor Technologies
MORE WEBCASTS, PODCASTS, AND VIDEOS

Downloads and eKits

Adobe Download: Tour de Flex Application and Explore Flex
Get Started: Create Applications Without Infrastructure Limits with the Windows Azure Platform
HP PartnerONE | SolutionsINFINITE Visit us at hp.com/partners/us
 Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS

Tutorials and Demos

Free Adobe Online Flex Training: Check Out this Video Training Course Here
Develop Cloud Applications - Get Started Now with the Windows Azure Platform
Learn Unified Communications
Learn SQL Server 2008
Learn Windows Server 2008 R2
Internet.com Hot List: Get the Inside Scoop on IT and Developer Products
 Join the Intel AtomDeveloper Program: Develop and sell netbook applications!
Learn Forefront
Learn System Center
All About Botnets
Learn SharePoint
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES