Re: innodb or Berkeley DB default for mysql max

[terete]

We have the same problem as Victoria, and the --default-table-type option
does not work.

- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 15, 2002 1:38 PM
Subject: innodb or Berkeley DB default for mysql max


 Kemp,
 Thursday, March 14, 2002, 8:37:00 PM, you wrote:

 KRW What is the default table engine used in the binary version of
mysql-max --
 KRW innodb or Berkeley?  If not innodb, how do I get the innodb to be the
default?
 KRW Can someone point me to the manual section?

 The default table type of MySQL server is MyISAM. To set up another
 table type by default use '--default-table-type' option.





 --
 For technical support contracts, goto https://order.mysql.com/
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.com




 -
 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

Transactional sql tables with columns that can have NULL values

[terete]

 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