On Wednesday 21 February 2007 17:51, Paul McCullagh wrote:
> Hi Tim,
Hello Paul
> Foreign key definitions are parsed but ignored by MyISAM tables.
Understood. Thanks
> Try InnoDB or PBXT (http://www.primebase.com/xt) :)
for the time being, I'm going to stick with MyISAM. I've
got a possible solu
On Wednesday 21 February 2007 17:43, Rolando Edwards wrote:
> SHOW INDEXES FROM `providers`;
>
> By the way, what version of MySQL are you using ???
4.0.20
--
Tim Johnson <[EMAIL PROTECTED]>
Palmer, Alaska, USA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Hi Tim,
Foreign key definitions are parsed but ignored by MyISAM tables.
Try InnoDB or PBXT (http://www.primebase.com/xt) :)
On Feb 21, 2007, at 9:35 AM, Tim Johnson wrote:
On Wednesday 21 February 2007 17:01, Rolando Edwards wrote:
SHOW CREATE TABLE providers\G
Hi Rolando:
That doesn't do
SHOW INDEXES FROM `providers`;
By the way, what version of MySQL are you using ???
- Original Message -
From: "Tim Johnson" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, February 21, 2007 3:35:46 AM (GMT-0500) Auto-Detected
Subject: Re: Retrieving
On Wednesday 21 February 2007 17:01, Rolando Edwards wrote:
> SHOW CREATE TABLE providers\G
Hi Rolando:
That doesn't do it on my machine (linux, ver 4.0.2)
Here's what I see
mysql> SHOW CREATE TABLE providers\G
*** 1. row ***
Table: providers
SHOW CREATE TABLE providers\G
- Original Message -
From: "Tim Johnson" <[EMAIL PROTECTED]>
To: "MySQL General Mailing List"
Sent: Wednesday, February 21, 2007 2:59:35 AM (GMT-0500) Auto-Detected
Subject: Retrieving foreign keys and references
Hi:
Below is the following relevant create t