This is not specific to MySQL (probably) but I thought this wizened
community might have a definitive answer.
Take this simple grouped select:
SELECT Value1,Value2 FROM Table1 GROUP BY Value1,Value2
Value1 Value2
---
Joe Red
Joe Blue
Joe Green
Jim Red
Jim
MySQL 3.23.47: I want to change a column that is currently
non-indexed. SessionID is a nullable int column:
alter table tbl_Orders
add unique SessionID(SessionID);
results in
Column 'SessionID' is used with UNIQUE or INDEX but is defined as NOT
NULL
(A throwback to version 3.22???)
I have
Honestly I am not sure how it would scale, it has worked well in my
use with several thousand very large documents (a couple million rows
in the index table). You certainly couldn't use this to develop an
internet search engine...
I had never heard of MySQL not using keys in an OR type of query,
You can do this yourself, pretty easily by building an index in
advance. I've been using the following technique to implement full text
searching since before it existed in MySQL in any form. Tokenize
each unique word in a document and store the word & count in tables:
tbl_tokens:
token_id int
to
Gotta say that this is a bad reason to choose one product vs.
another... because it lacks a GUI to build queries? Undertanding SQL
is all well and good, but I can tell you that I would give anything to
have a query builder that works like the one for MS SQL server. You may
enjoy writing incredibl
By the way, if I rewrite the SQL without calculated fields, e.g.
instead of defining @MyYear, @StartMonth, and @EndMonth as variables
but rather duplicating the SQL to create a MyYear (and the others) column
and then inside the larger formula for Period, it works.
-- Jamie
The following statemen
The following statement:
SELECT Date, @MyYear := year(Date) AS MyYear, @StartMonth :=
floor((month(date)-1)/3)*3+1 AS StartMonth,
@EndMonth := floor((month(date)-1)/3)*3+3 AS EndMonth,
@Period :=
concat(left(monthname(concat('1-',@StartMonth,'-2000')),3),'-',left(monthname(concat('1-',@EndMonth
There is a free, feature-limited version.
GBD> Mascon is sweet, but it's not free :)
>> can anyone suggest a good GUI client to suggest to MySQL hosting
>> customers?
--
Best regards,
Jamesmailto:[EMAIL PROTECTED]
-
You must remember, though, that for every person who has a problem
posted to this list, there are probably hundreds who don't ;-) I'd
hazard that RH6.2 is the single most popular platform for running
MySQL.
If I learned anything while teaching myself linux a year ago, it was
to use source instal
Actually there is no reason to expect MySQL to perform better than
Access for a nominally sized database and everything running on one PC.
Access was designed and optimized for JET whereas ODBC is a
general-purpose API.
Also, the connection method impacts this significantly, as do the
complexity
I've been very happy with mascon (scibit.com). Payware with a limited free
version that I think covers all your requirements. I felt it was worth the
price for the real thing. Their support is excellent, as is the incredible
frequency of releaseing updates with significant new features.
Jamie
I would like to log connections to a file (e.g. the connection info
provided using the --log option) but I don't want every query logged as
well, or at the very least would like them to go to a different file. Is
there any way to do this?
Jamie
---
At 05:58 PM 1/10/01, Carlos Corzo wrote:
>Some people have tried the manuals verbatim but are really confused
>because they are not at your intellectual level. If this list is for
>the "intelligent only", change the title please. Not everyone can
>decipher a manual. I may post questions but the
13 matches
Mail list logo
