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
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 th
On Wed, 9 Jan 2002, Rick Emery wrote:
> First, you are describing a "one-to-many" relationship, bceasue one "file"
> record can be referenced by many "people" records. If this is the case, you
> may wish to re-design your tablse such that a "people record" contains a
> "file_id" field. You can
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 optimize
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
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 th
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 ch
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 alread
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)
11 matches
Mail list logo
