----- Original Message ----- From: "Luca Lafranchi" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 5:10 PM Subject: Re: JDBC Transactions
> Hi Arul, this is not a direct answer to your question, only a note about > foreign keys and MySQL: if I'm right (please someone correct me if not), > foreign keys aren't implemented in MySQL: you can define them in your > create statement if you want, but they will not work. > > Ciao > Luca > > > > Arul wrote: > > > Thanx Mark > > > > But i am new to MySQL... > > > > First of all i would like to know the basic difference between Inno DB and > > My ISAM Table types.. > > > > I wanted mySQL to support AutoIncrement , Transactions,Foreign Key > > Constraints,Blob, Text etc...so as per the documents i thought of using a > > InnoDB Table... > > > > Currently i am using 3.23.49 Max on Win 2K...I created two tables parent > > and child > > > > CREATE TABLE parent(id INT NOT NULL,PRIMARY KEY (id)) TYPE=INNODB; > > > > CREATE TABLE child(id INT, parent_id INT,INDEX par_ind (parent_id),FOREIGN > > KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE) TYPE=INNODB; > > > > After creating the tables when i executed the Query > > mysql>show table status > > > > This says that the Table is of type MyISAM. > > > > This confuses me a lottt...Also the table i had created is not working for > > Foreign Key Relations.. > > What could be the soltuion...Kindly Advice > > > > > --------------------------------------------------------------------- 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