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.
CREATE TABLE
( cod2 ) REFERENCES tab2( cod2 ) ON UPDATE
CASCADE ON DELETE CASCADE
) TYPE = INNODB
Mensagens do MySQL :
Can't create table '.\test\tab3.frm' (errno: 150)
Luis
Cópia Ernie Hershey [EMAIL PROTECTED]:
In 3.23, all foreign keys must be on columns
that exist as the
first
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
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
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
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: [EMAIL
]. 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: Where can i