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
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
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
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 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
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.