Marco, ----- Original Message ----- From: "Marco B" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, June 09, 2003 8:45 PM Subject: ADD CONSTRAINT on InnoDB tables
> Hi all,=0D=0A=0D=0AI've just installed mysql 4.0.1 on my pc and I'm tryin= > g to migrate a set of old MyISAM table to InnoDB type table, to introduce= > referential integrity on my data.=0D=0A=0D=0AI found this problem. I cre= ... when I press 'Reply', your message gets scrambled with 0D and 0A codes, which are the carriage return and linefeed in Windows, I think :). Anyway, the answer to the question is that RESTRICT is the default if you do not specify an 'action'. That is why SHOW CREATE TABLE does not explicitly print the RESTRICT. > =0AMarco Barbato=0D=0A=0D=0A---------------------------------------------= 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]
