sql, query I understand I must use InnoDB tables if I plan to use constraints.
If I: CREATE TABLE TEMP_TEST(A CHAR(2),B CHAR(2)) TYPE = InnoDB; Well the test table gets created, but it is, according to SHOW TABLE STATUS, a MyISAM table. How can I set Type to InnoDB and make it stick. And if it is true that InnoDB tables can contain only 1000 or fewer rows, what's the use. I could do that with a text file. Jim Bailey _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx --------------------------------------------------------------------- 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