> PRIMARY KEY ( cod1, cod2 ) ,
> FOREIGN KEY ( cod1 ) REFERENCES tab1( cod1 ) ON UPDATE
> CASCADE ON DELETE CASCADE ,
> FOREIGN KEY ( cod2 ) REFERENCES tab2( cod2 ) ON UPDATE
> CASCADE ON DELETE CASCADE
> ) TYPE = INNODB
>
> Mensagens do MySQL :
> Can't create
In 3.23, all foreign keys must be on columns that exist as the
first field in an index on the table. This applies to
the columns they reference as well.
Ernie Hershey
--
On Mon, 24 Mar 2003, Luis Matos Lima wrote:
> i´m having some trouble in creating a table like this
> one.
>
Your cron line:
0 * * * * /home/you/mysqlcheck
Or if it's in /etc/crontab
0 * * * * root /home/you/mysqlcheck
And the script:
#!/bin/sh
# on error send e-mail to
#
adminmail="[EMAIL PROTECTED]"
# or /usr/bin/safe_mysqld, etc.
#
restartCommand="/etc/rc.d/init.d/mysqld start"
if [ ! "`ps au
ld be stored in a given program anyways,
so it would be more organized.
Ernie Hershey
[EMAIL PROTECTED]
-Original Message-
From: Sparta Cruz [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 10, 2001 3:48 PM
To: Ernie Hershey
Subject: RE: Maximum # of Columns
This doesn't have
columns and 80 rows).
Ernie Hershey
[EMAIL PROTECTED]
-Original Message-
From: Sparta Cruz [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 10, 2001 3:10 PM
To: [EMAIL PROTECTED]
Subject: Maximum # of Columns
am trying to design a good database, that has a matrix of data per
record. For
e [to_outfile]. Append everything into given
outfile.
use (\u)Use another database. Takes database name as argument.
Ernie Hershey
[EMAIL PROTECTED]
-Original Message-
From: Barbara Ferrell [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 21, 2001 9:25 AM
To: [EMAIL PROTECTED]
Subject
I've used pam-mysql with redhat linux and am very pleased with
it. I love being able to authenticate to a db.
Ernie Hershey
[EMAIL PROTECTED]
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 19, 2001 2:00 AM
To: Chris Aitken
Cc: [
