Rainer,
----- Original Message -----
From: "Rainer Collet" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Saturday, May 31, 2003 5:49 PM
Subject: Re: MySQL/InnoDB-4.0.13 is released
> [EMAIL PROTECTED] ("Heikki Tuuri") wrote in message
news:<[EMAIL PROTECTED]>...
> > Hi!
> >
> > InnoDB is a MySQL table type which provides transactions, foreign key
> > constraints, and a non-free hot backup tool to MySQL.
>
> Where can I get this hot backup tool?
it is non-free and can be ordered from http://www.innodb.com. MySQL/InnoDB
support contracts also contain some complimentary Hot Backup licenses.
> > CONSTRAINT `0_16` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`)
ON
> > DELE
> > TE CASCADE
>
> How did you get this? I also use 4.0.13 but only get e.g.
> "CONSTRAINT `0_16` FOREIGN KEY (`parent_id`) REFERENCES `parent`
> (`id`)"
>
> Even I defined it with an "on update" or "on delete" statment. How can
> I retrieve these contraints afterwards?
Could you post a full example? They should be there when you do SHOW CREATE
TABLE. E.g.:
[EMAIL PROTECTED]:~/mysql-4.0/client> mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 4.0.14-debug-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE TABLE parent(id INT NOT NULL,
-> PRIMARY KEY (id)) TYPE=INNODB;
Query OK, 0 rows affected (0.01 sec)
mysql> 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;
Query OK, 0 rows affected (0.01 sec)
mysql>
mysql>
mysql> show create table child;
+-------+-------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
-+
| Table | Create Table
|
+-------+-------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
-+
| child | CREATE TABLE `child` (
`id` int(11) default NULL,
`parent_id` int(11) default NULL,
KEY `par_ind` (`parent_id`),
CONSTRAINT `0_14016` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`)
ON D
ELETE CASCADE
) TYPE=InnoDB |
+-------+-------------------------------------------------------------------
----
----------------------------------------------------------------------------
----
----------------------------------------------------------------------------
-+
1 row in set (0.00 sec)
mysql>
> Thanks very much,
> Rainer
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
