Nope, that wasn't the problem. I wasn't aware that the foreign key name
must be unique. So, if you have a foreign key named "fk_lesson", that same
name cannot exist already, even if on a different table. I named the
foreign key something completely different and that solved the problem.
Jesse
-
Interesting. Thanks for that tip on showing the INNODB STATUS. It turned up
the error:
A foreign key constraint of name `cc/fk_lessons` already exists.
...which tells me that a foreign key name cannot already be in use even if
on a different table (at least that's what it appears to be saying).
I'm trying to create a foreign key by executing the following statement:
ALTER TABLE `cc`.`takenlessons`
ADD CONSTRAINT `fk_lessons`
FOREIGN KEY (`LessonID` )
REFERENCES `cc`.`lessons` (`id` )
ON DELETE CASCADE
ON UPDATE NO ACTION
, ADD INDEX `fk_lessons` (`LessonID` ASC) ;
I'
don't know about indexing, but try to search: LIKE '%sentences%'
JC
On Thu, 20 Jul 2006, Peter Lauri wrote:
> Best group member,
>
> I have a problem. I was going to use FULL TEXT search for my Thai client. It
> is working smooth with English text and wordings, the
||xx||
you get the idea, a lot of data will be repeated. not a good idea.
jc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ot (if no password for root) or
mysql -u root -p (if there is pw for root)
and then:
select user,host,password from mysql.user;
if you don't see an entry for root & localhost, then you need to add it
in.
hope that help.
JC
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
id2 IN (all columns in table1 except first
columns).
Is this possible to do in one statement? I know how to do this in
multiple queries, just wonder anyone knows how to optimize this.
Thanks,
JC
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Hi,
I downloaded and compiled mysql 4.0.9 gamma this morning, and
still get the same error. This doesn't seem to be related to reverse
DNS. I've got the crash from both types of client hosts (with and without reverse).
The official 4.0.9 binary version seems to work well.
What did I miss ?
My
because I just saw a posting from Jeremy in Apr anonouncing
that they have a 9GB MYD, but that was Linux.
Is anyone else having this kind of a problem?
Is there any way to dump the compile time options?
Thanks,
JC
-
Before
found a way around this tid bit of a problem.
Background:
I have version 4.01 running on a Linux 7.1 machine the environment
variables for SSL show up.
Thanks in Advance,
JC
-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
iQA/AwUBPHMOqnX+hJ
g a new database with the desired
name and importing the contents of the dump file.
I'd like to be able to just rename the database from the command line
just like you would a table.
Thanks in advance,
JC
-BEGIN PGP SIGNATURE-
Version: PGPfreeware 6.5.8 for non-commercial use <htt
11 matches
Mail list logo