Here's a recipe:
create table foo (foo text, bar text);
create fulltext index foo on foo (foo, bar);
mysql show index from foo;
+---++--+--+-+---+-+--++--++-+
| Table | Non_unique |
On Tue, 3 Dec 2002, Jon Frisby wrote:
However, from a DB design standpoint, it is generally considered
MASSIVELY unwise for your PRIMARY KEY value to have any
business-meaning. If it has no business-meaning, it never needs to
change. Ever.
Really, the issue is that you don't want a primary
Is there any programmatic way (SQL, C-level API) way to determine whether
or not a given mysql server is running in ANSI mode or not?
If not, this would be most helpful, as otherwise it is impossible to
know how to quote identifiers (` or ).
-dave
/*==
www.urth.org
we await
On Fri, 4 Jan 2002, Chris Lott wrote:
How is full-text working for you otherwise? Is it excruciatingly slow to
generate indexes and optimize tables as some have said?
Oh god, yes. Running 3.23.46 on Linux with a 1Ghz PIII and 4 GB of RAM it
_still_ takes a heck of a long time to do
On Mon, 17 Dec 2001, Alex Kirk wrote:
I've got a 700-question multiple choice quiz that I've got imported into
MySQL, with one small problem: the answers to the quiz are not a separate
column. I have three columns for each of the possible answers; the correct
answer is denoted by a * in the
On Tue, 4 Dec 2001, AJ wrote:
Ver 11.15 Distrib 3.23.46, for pc-linux-gnu (i686)
The problem that has cropped up I have is that in all GROUP BY column DESC
statements, the DESC is now not being recognized, and the query is being
returned in ascending order. If I use ORDER BY... DESC that
On Mon, 29 Oct 2001, Jindo Soul wrote:
Why this error exists is beyond my knowledge though.
I am guessing that Perl DBI escapes ' \ in bind_param call.
And MySQL escapes the data again when using big5 charset,
which ultimate causes an error because of double escaping.
Well, its not that
On Tue, 14 Aug 2001, Bruce Stewart wrote:
How about a UNION query...?
Too bad MySQL doesn't support them yet ;)
-dave
/*==
www.urth.org
We await the New Sun
==*/
-
Before posting, please
On Mon, 12 Feb 2001 [EMAIL PROTECTED] wrote:
Moving back and forth is a manual process, which is a bit frustrating.
Since dia stores everything in XML, I'm considering what it would take to
make some sort of syncronization.
I've been planning on looking into Alzabo too, which was already
On Sat, 10 Feb 2001, Cal Evans wrote:
As much as I love creating models by hand, my databases are growing to the
point where I need a tool to help me "see" them. Does anyone know of a tool
like ERWin or ER/Studio that supports MySQL?
I have a project called Alzabo (alzabo.sourceforge.net)
10 matches
Mail list logo
