On Wednesday 19 July 2006 01:07 pm, Jesse wrote:
> `ID` int(10) unsigned NOT NULL auto_increment,
> `CTID` int(11) NOT NULL,
the storage types aren't the same. change CTID to INT(10) UNSIGNED NOT NULL
and it should work.
--
Chris White
PHP Programmer/DBank
Interfuel
--
MySQL General Mail
ion` varchar(15) default NULL,
`Points` tinyint(3) default NULL,
`CTID` int(11) NOT NULL,
PRIMARY KEY (`ID`),
KEY `CTID` (`CTID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Thanks,
Jesse
- Original Message -
From: "Chris White" <[EMAIL PROTECTED]>
To:
Sent: W
On Wednesday 19 July 2006 10:25 am, Jesse wrote:
> MySQL Error Number 1005
> Can't create table '.\karate\#sql-304_9.frm' (errno: 150)
KEY `FK_custpoints_1` (`CTID`)
REFERENCES `custtournaments` (`ID`)
can you show us the column declarations for these two?
> Any idea why this is happening, and
Is it possible you're in the wrong database (different from
'custtournaments') when you issue this command?
No. I've tried in SQL Browser, EMS SQL Manager, and MySQL Command line,
making sure in each case that I have the karate database selected. I have
also re-typed it in MySQL Command line
Jesse, a stab in the dark here, with some info from the manual.
A foreign key constraint is in My Code erroneously coded,
If MySQL gives the error number 1005 from a CREATE TABLE
statement, and the error message string refers to errno 150, then
the table creation failed because a foreign key cons
I'm using MySQL 5 with InnoDB tables. I'm trying to create a foreign key,
but when I try, it's giving me an error. I've tried this with the
MySQLQuery Browser, and EMS SQL Manager 2005. I get the following error in
the Query Browser:
Error while executing query.
ALTER TABLE `karate`.`custp
HI Victoria, Harald, Dyego
you all were right, the database is not supporting the InnoDb tables;
I configure it with "--with --innodb" option & add innodb_data_file_path
to the my.cnf. Now it's working!!
Thank you so much
Vinita
sql
Dyego Souza do Carmo wrote:
vvM> HI
vvM> still not workin
vinita,
Tuesday, November 19, 2002, 2:06:01 AM, you wrote:
vvM> still not working :-(
vvM> I didn't do the installation , Do we need to set any option
vvM> specifically during the installation for foreign key to work??
Check that your both tables are InnoDB:
SHOW TABLE STATUS LIKE "tabl
vvM> HI
vvM> still not working :-(
vvM> I didn't do the installation , Do we need to set any option
vvM> specifically during the installation for foreign key to work??
The InnoDB is loaded ?
please run
show variables like '%innodb%';
and put here.
tnks.
sql,query
---
("433222", "2000", "1");
Query OK, 1 row affected (0.00 sec)
Silmara wrote:
Change room to unit
FOREIGN KEY (unitCode) REFERENCES room (unitCode) ON DELETE CASCADE
FOREIGN KEY (unitCode) REFERENCES unit(unitCode) ON DELETE CASCADE
Hope this helps,
Sil
- Orig
CTED]>
Sent: Sunday, November 17, 2002 9:15 PM
Subject: Creating foreign key
> HI
> I'm not sure what I'm doing wrong in the following example, the foreign
> key is NOT working. I'm using ver3.23.53.
>
> --
HI
I'm not sure what I'm doing wrong in the following example, the foreign
key is NOT working. I'm using ver3.23.53.
-
mysql> CREATE TABLE unit (
-> unitCode CHAR(20) NOT NULL,
-> uni
12 matches
Mail list logo
