Re: Can't create table

2009-03-16 Thread Gerald L. Clark
Octavian Râºniþã wrote: Hello, I've tried to create these 4 test tables, but when I try to create the last one, MySQL gives the following error: ERROR 1005 (HY000) at line 20: Can't create table '.\z\favorite_link.frm' (errno : 150) It seems that the foreign keys are not created well i

Re: Can't create table (errno: 604) (occurs when trying to create a primary key)

2006-10-11 Thread Sebastian Mork
I've now figured out that the error occurs when I try to create any table that has a primary key. creating tables without the primary key works. hmm.. is there any limitation in the mysql (ndb)-settings that I've to change? Its the standard-installation of 4.1.21-max... -- Sebastian Mork [EMAIL PR

Re: Can't create table from another table

2001-06-13 Thread Benjamin Pflugmann
Hi. On Wed, Jun 13, 2001 at 01:47:53PM +0200, [EMAIL PROTECTED] wrote: > Hi > > Sorry for this question but this is my first shot at this list. > > I have created a table that contains the following: > CREATE TABLE liggare (raknare INT(10) UNSIGNED ZEROFILL DEFAULT '00' NOT >NULL, > >