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