newbie question about InnoDB

2002-03-28 Thread Olivier Vanekem
hi, I've downloaded mysql-max-nt v.3.23.49, have setup InnoDB startup support. I am now in the process of creating tables. When these are standard tables no problem, eg: create table test (id integer not null, primary key(id)) type=InnoDB; works fine ! I have problems when I have tables with

Re: newbie question about InnoDB

2002-03-28 Thread Heikki Tuuri
Olivier, please check that the data types of corresponding columns in the referenced tables are the same, and that you have created the necessary indexes in also the referenced tables. I tested the following: C:\m\client_debugmysql test Welcome to the MySQL monitor. Commands end with ; or \g.