[Gllug] MySQL Woes

[Simon Stewart]

On Wed, Jun 12, 2002 at 06:00:31PM +0100, Leslie Till wrote:
>
> Finding that I didn't understand the term 'referential integrity' I did
> a google search and found that
> <http://techdocs.postgresql.org/college/002_referentialintegrity/> gives
> a very nice demo of what it means. It is what I imagined, they use a
> number as an id for each record. Postgresql, if asked nicely, will add a
> unique number to a column in the table each time a new record is entered
> - I know this cos I've used it. Unfortunately I lost all my data and the
> Perl/Tk scripts that controlled record entries, using the auto number
> facilty, when I had a backup b£$$sup.

Try creating the appropriate column with the "serial" data type, if
that's what you're after. Functionally, it's equivalent to MySQL's
"autoincrement".

A gotcha which got me is that the 7.2 series uses "typea" instead of
"oid"s for storing blobs.

Cheers,

Simon

-- 
When someone says "I want a programming language in which I need only
say what I wish done," give him a lollipop.

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug