On Thu, 09 Jan 2003 23:04:37 +0100
Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] wrote:
Rafal,
alter table rezerwacje add foreign key (nip_h,nrpok_p) references
pokoje(nip_h,nrpok_p);
ERROR 1005: Can't create table './test/#sql-932_4.frm' (errno: 150)
Most probably, you are using
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 11:04 PM
Subject: Re: Bug in foreign keys
Rafal,
- Original Message -
From: Rafal Jank [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday
MySQL-Max from http://www.mysql.com
sql query
.
Subject: Re: Bug in foreign keys
From: Rafal Jank
Date: Fri, 10 Jan 2003 11:10:35 +0100
On Thu, 09 Jan 2003 23:41:46 +0200
Heikki Tuuri
for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
.
Subject: Re: Bug in foreign keys
From: Rafal Jank
Date: Fri, 10 Jan 2003 11:10:35 +0100
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10) NOT NULL default '0',
`lozka_p` char(2) default NULL,
`tv_p` char(1) default NULL,
`lazienka_p` char(1) default NULL,
`cena_p` int(10) default NULL,
`zaliczka_p` int(10) default
At 16:11 +0100 1/9/03, Rafal Jank wrote:
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10) NOT NULL default '0',
`lozka_p` char(2) default NULL,
`tv_p` char(1) default NULL,
`lazienka_p` char(1) default NULL,
`cena_p` int(10)
At 16:11 +0100 1/9/03, Rafal Jank wrote:
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10) NOT NULL default '0',
`lozka_p` char(2) default NULL,
`tv_p` char(1) default NULL,
`lazienka_p` char(1) default NULL,
Rafal,
- Original Message -
From: Rafal Jank [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, January 09, 2003 6:18 PM
Subject: Bug in foreign keys
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10
affected (0.01 sec)
Records: 0 Duplicates: 0 Warnings: 0
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 11:04 PM
Subject: Re: Bug in foreign keys
Rafal,
- Original Message -
From: Rafal Jank [EMAIL PROTECTED