Arul,
Thursday, May 30, 2002, 2:05:52 PM, you wrote:
A> First of all i would like to know the basic difference between Inno DB and
A> My ISAM Table types..
Check the manual:
http://www.mysql.com/doc/T/a/Table_types.html
A> I wanted mySQL to support AutoIncrement , Transactions,Foreign Key
A> Constraints,Blob, Text etc...so as per the documents i thought of using a
A> InnoDB Table...
A> Currently i am using 3.23.49 Max on Win 2K...I created two tables parent
A> and child
A> CREATE TABLE parent(id INT NOT NULL,PRIMARY KEY (id)) TYPE=INNODB;
A> CREATE TABLE child(id INT, parent_id INT,INDEX par_ind (parent_id),FOREIGN
A> KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE) TYPE=INNODB;
A> After creating the tables when i executed the Query
A> mysql>show table status
A> This says that the Table is of type MyISAM.
If you want to support InnoDB you should set up startup InnoDB option:
http://www.mysql.com/doc/I/n/InnoDB_start.html
and then run mysqld-max or mysqld-max-nt. You can check if you have
sopport fo InnoDB using command:
SHOW VARIABLES LIKE "have%";
If InnoDB is supported, the value of variable "have_innodb" must be
'YES'.
A> This confuses me a lottt...Also the table i had created is not working for
A> Foreign Key Relations..
A> What could be the soltuion...Kindly Advice
A> -Arul
A> ---------------------------------------------------------------------
A> Before posting, please check:
A> http://www.mysql.com/manual.php (the manual)
A> http://lists.mysql.com/ (the list archive)
A> To request this thread, e-mail <[EMAIL PROTECTED]>
A> To unsubscribe, e-mail <[EMAIL PROTECTED]>
A> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
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
