Jim,
Wednesday, August 21, 2002, 2:51:51 PM, you wrote:
JB> sql, query
JB> I understand I must use InnoDB tables if I plan to use constraints.
JB> If I:
JB>CREATE TABLE TEMP_TEST(A CHAR(2),B CHAR(2))
JB>TYPE = InnoDB;
JB> Well the test table gets created, but it is, according to
JB> SHO
Jim, it must be that the innodb parameters aren't set up in /etc/my.cnf.
Case doesn't matter on the "type=innodb".
I've set up a tablespace called pracexpr1 that has the following section for
innodb in my my.cnf:
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = p
Jim,
Jim Bailey schrieb:
>
> sql, Query
> Hark ye experts!
>
> Here I stand an expert grunt.
> Trying to understand,
> The syntax of constraint.
>
> I was directed to the constraint doc.
> And found the constraint doc doth suck.
>
> Here's my ploy, renewed, refined.
> Please see if you can he
Maybe you should be a poet, lol
- Original Message -
From: "Jim Bailey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 7:00 AM
Subject: Constraint Hell
> sql, Query
> Hark ye experts!
>
> Here I stand an expert grunt.
> Trying to understand,
> The syntax of co
On Tuesday 20 August 2002 08:00 am, Jim Bailey wrote:
http://www.mysql.com/doc/en/SEC447.html
RTFM, couldn't be more clear, the columns in both master and slave which are
constrained need to be indexed, and yes the FOREIGN KEY and REFERENCES
sections name the INDEXES, not the columns. Its
FO
