Jim, Wednesday, August 21, 2002, 2:51:51 PM, you wrote: JB> sql, query JB> I understand I must use InnoDB tables if I plan to use constraints.
JB> If I: JB> CREATE TABLE TEMP_TEST(A CHAR(2),B CHAR(2)) JB> TYPE = InnoDB; JB> Well the test table gets created, but it is, according to JB> SHOW TABLE STATUS, a MyISAM table. How can I set Type to InnoDB JB> and make it stick. If you install MySQL from binary distribution you should use MySQL-Max or you should configure MySQL server with --with-innodb option: http://www.mysql.com/doc/en/InnoDB_overview.html JB> And if it is true that InnoDB tables can contain JB> only 1000 or fewer rows, what's the use. I could do that with a text file. You are so credulous :) No, it's not true. You can store more that 1000 rows in the InnoDB table. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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