Hi!

Where did you read that? That text should be updated!

At least InnoDB supports indexes on columns which can have a NULL value.

Regards,

Heikki Tuuri
Innobase Oy

-----Original Message-----
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Date: Wednesday, March 13, 2002 5:23 PM
Subject: Transactional sql tables with columns that can have NULL values


>
> Hi,
>
> I would like to use transactional sql tables that support columns with
NULL
> values. I think that only BDB and InnoDB tables types support
transactions,
> but I have read that:
>
> "Only the MyISAM table type supports indexes on columns that can have NULL
> values. In other cases you must declare such columns NOT NULL or an error
> results."
>
> The problem is that MyISAM table is non-transactional. How can I solve
>this?
>
> Thank you very much!!!!
>
>             TERE
>
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to