Database Programming
All contributors in Database Programming
How to Use a MySQL Database in a Perl Program
A MySQL database will always form a suitable backend for any application, and the Perl programmer will find that this can be achieved very easily. more...
How to Use Business Rules in a MySQL Database
Business rules are incredibly important to every organisation. They can be made application independent by placing them in a MySQL database. more...
How To Create an OpenOffice.org Database Log On
When looking an OpenOffice.org database there is no way of adding user accounts. Not directly, anyway. The secret is to use a little bit of SQL. more...
How to Create a Self Registering Base Database
With the release of OpenOffice.org 3.1 the programmer can do something important. They can add a macro to a database and they can run it automatically. more...
How to Create OpenOffice.org Database Macros
Release 3.1 of OpenOffice.org gives programmers a new facility - the ability to save macros as part of a database file. more...
How to Update A MySQL Database with C#
It is important to keep the contents of a database up to date. It's fortunate, therefore, that C# and the MySQL .NET connector make that an easy task. more...
How to Add Records to MySQL With C#
As well as viewing data in a MySQL database, a C# programmer can add information by using the SQL insert statement and the MySQL .NET connector more...
All feature articles in Database Programming
Introduction to SQL: SELECT, FROM, WHERE & More
By: Jennifer Graham
SQL is a query language used with relational databases. INSERT, UPDATE and DELETE manipulate tables while SELECT, FROM and WHERE are useful commands for returning data. more...
Introduction to SQL: Getting Started
By: Jennifer Graham
Structured query language (SQL) is used to create databases, and retrieve and manipulate data. It is the standard query language for relational database management system more...
MYSQL Custom Field Sorting Revisited
By: Don Waterfield
At times in MYSQL an unnatural sort is required. This article presents an easy to maintain set of tables where sorting a table in any order can be easily defined. more...
By: Don Waterfield
In MYSQL the sorting of recordset data can be easily setup and maintained with a few custom tables and a little thought. more...
What is a Relational Database Management System?
By: Jennifer Graham
The advent of relational databases ushered in more efficient data storage practices. It lessened the unwanted duplication of data and made information more consistent. more...
Applying Referential Integrity to a Database
When not properly linked, badly connected tables can cause inefficiency to data retrieval. Eventually the database needs to be fixed by hand, at cost. more...
Transact-SQL Primer: Inner Join
By: Dan Hartshorn
A basic SQL concept that should be mastered is that of "joins." Joins allow for the display of data from different tables to be combined with specific relationships. more...
All contributing articles in Database Programming