I'm converting a database where multiple selections from a valuelist were
stored delimited within a single field with a \r.
I imported this data into MySQL 3.23.46 and imported the valuelist
selections as is into a VARCHAR field large enough to hold all selections.
I'm fine storing selection
Mikhail V.Soloviev [EMAIL PROTECTED] wrote:
Hello,
I have a problem with mysqld (3.32.46 under Red Hat Linux 7.2,
pIII-800 512K RAM).
It starts and works fine until some time is passed, then it starts
eating my memory and CPU.
Try to run binaries from MySQL site - gcc 2.96 can be the
I've added a timestamp field to a table and when viewing the data stored in the field
it looks like this .
19970523091528
.. but when I view the data in Access or Macromedia Dreamweaver it looks like this
05/23/1997 09:15:28
.. is there any way to make Access/Dreamweaver
Clive,
I've added a timestamp field to a table and when viewing the data stored in the field
it looks like this .
19970523091528
.. but when I view the data in Access or Macromedia Dreamweaver it looks like this
05/23/1997 09:15:28
.. is there any way to make
Hi
Apols for being dense but I have basic problem with
MySQL for Win98.
I have downloaded and unzipped
mysql-3.23.47-win-src.zip
The next step is to do the setup.exe but there is no
file called this. So how do I proceed?
(There is a small zip program also on the download
page, but this is 'not
Hi,
I found that mysql doesn't used indexes if there is a in the where
statement...
for example
mysql explain select * from testtable where id 5;
+-+--+---+--+-+--+---++
| table | type | possible_keys | key | key_len | ref | rows |
Hi Geoff,
Apols for being dense but I have basic problem with
MySQL for Win98.
Perhaps not dense, just baffled by 'new' terminology.
You appear to have downloaded the source code.
If you want to download MySQL and not have the extra, compile, step to negotiate, then
find the *-win.zip
On Thursday, 21. February 2002 12:46, Natalino Picone wrote:
Hi,
I found that mysql doesn't used indexes if there is a in the where
statement...
for example
mysql explain select * from testtable where id 5;
It would only make sense to use an index, when you want to select the id
field
Hi,
I have the following problem:
I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8).
From the the old installation I only got the backup files (created with
'mysqldump database my_databases.sql') and the the database file (ISD,
ISM, frm).
My problem is: I can't read the
This off topic, but one of our programmers is interested in NuSphere's PHPEd
development interface and I would liek some feed back from other users.
His interest lies not so much in using for database table modeling, but for
PHP and Perl development. I am well aware of the conflict a few months
Apart from timestamp are there any other fields that will automatically generate data
for themselves when a new record is created ?.
I'm having trouble using timestamp with Macromdia Dreamweaver so something that just
generates a unique number for each record would be good e.g 1,2,3,4,5,6,7,
His interest lies not so much in using for database table modeling, but
for
PHP and Perl development.
How does PHPEd stack up compared to other PHP IDE's? What experience (good
or bad) has anyone had with it? Is there another product that is better?
I've just finished using Quanta+ for doing a
Jorge,
Wednesday, February 20, 2002, 7:44:50 PM, you wrote:
JG Hello
JG I'm new to MySQL, Unix and Replication.
JG I would like to know if in a scenario where I have one master and
JG several slaves I can convert one of the slaves to master in the event
JG my master goes down.
It will be added
Neil,
Thursday, February 21, 2002, 12:18:27 AM, you wrote:
NZ Hello,
NZ I searched the manual but it seems like MySQL does not support ANSI SQL
NZ CHECK constraints. These are often used to check that rows inserted into
NZ tables meet specified criteria. For example table T created as follows
Natalino,
Thursday, February 21, 2002, 1:46:11 PM, you wrote:
NP Hi,
NP I found that mysql doesn't used indexes if there is a in the where
NP statement...
NP for example
NP mysql explain select * from testtable where id 5;
NP
Geoff,
Thursday, February 21, 2002, 1:33:47 PM, you wrote:
GD Hi
GD Apols for being dense but I have basic problem with
GD MySQL for Win98.
GD I have downloaded and unzipped
GD mysql-3.23.47-win-src.zip
GD The next step is to do the setup.exe but there is no
GD file called this. So how do I
Clive,
Thursday, February 21, 2002, 3:22:47 PM, you wrote:
CA Apart from timestamp are there any other fields that will
CA automatically generate data for themselves when a new record is
CA created ?.
CA I'm having trouble using timestamp with Macromdia Dreamweaver so
CA something that just
Theo,
Wednesday, February 20, 2002, 6:37:15 PM, you wrote:
TVS Hello,
TVS I am new with MySQL and have it running on Windws 2000 server and
TVS programming with VC++ 6.0
TVS Now converting from SQL 7.0 to MySQL
TVS I wonder if there is a way to print out the data structure of the
TVS table
This off topic, but one of our programmers is interested in NuSphere's
PHPEd
development interface and I would liek some feed back from other users.
His interest lies not so much in using for database table modeling, but
for
PHP and Perl development.
If he's not really that interested
This worked for me:
create table tblZips(
id int unsigned not null auto_increment primary key,
city char(24) not null default '',
state char(2) not null default '',
zip char(5) not null default ''
) Type=InnoDB;
Saved CSV file as a UNIX (instad of DOS format file)
LOAD DATA
Ive just downloaded Mysql Max 4.0 binary distribution
for Windows ...
Does this distribution supports Innodb tables ?
How do I turn on this feature ?
I follow the instruction (modifying my.ini to include support for innodb )
buy Mysql does not start ( I am using Winmysqladmin ) and I am using
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is
pretty good. It creates PHP scripts that manipulate MySQL databases. It is
free and allows comparable functionality to the 'native' UltraDev languages
(ASP, JSP, Cold Fusion).
For more info -
I've been having some troubles install dbd::mysql on
Solaris 2.4 - make test is failing and I can't figure
out what is going wrong. The following shows the
results coming back from make test
If anybody can help me out here, I would appreciate
it. Thanks.
make[1]: Entering directory
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is
pretty good. It creates PHP scripts that manipulate MySQL databases. It is
free and allows comparable functionality to the 'native' UltraDev languages
(ASP, JSP, Cold Fusion).
For more info -
Hello,
I am using MySQL 3.23.36 on Linux. This is a small gripe about a product
I am otherwise very happy with. I hope I have not missed the obvious or
been stupid some other way.
The problem - I want to log somewhere other than $DATADIR. Things are
set up like ;
| log | ON
At 06:37 AM 2/21/2002 , you wrote:
This off topic, but one of our programmers is interested in NuSphere's PHPEd
development interface and I would liek some feed back from other users.
His interest lies not so much in using for database table modeling, but for
PHP and Perl development. I am well
Thanks for the advice ... I'll take a look at dbg2 ... if I get stuck, I'll
shoot you a plea for help!
Gerald Jensen
-Original Message-
From: BD [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 9:38 AM
To: Gerald R. Jensen
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL PHP
Andrew,
Thursday, February 21, 2002, 3:31:16 AM, you wrote:
AB I have created a table in the mysql db, using phpmyadmin with the following
AB statement:
AB create table books
AB ( isbn char(13) not null,author char(30),title(60),price float(4,2),primary
AB key(isbn));
AB which works fine and
Hi Darren,
The tests rely on the perl BDB and mysql-modules packages for perl.
Have you installed and tested these?
Ken
- Original Message -
From: Darren Ball [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 21, 2002 10:27 AM
Subject: PERL DBB::MYSQL MAKE TEST
I am a new MySQL user, so forgive my stupidity for asking the following
question (perhaps taboo). What is the latest on NuSphere vs MySQL
AB? What about Gemini. I have searched everywhere for info, but can't
seem to find anything after November of last year.
I have serious needs for
Yes, this problem is happening at the 'make test' step
while installing these modules... I have performed
the perl Makefile.PL, and the make, they seem to go
ok, just when I perform the make test, it seems to
fail with this relocation and symbol errors
--- Ken Menzel [EMAIL PROTECTED]
I have a MySQL InnoDB table for ACH (checking account) transactions that
includes, among other fields, the below:
trans_id (PRIMARY KEY)
cust_type
routing_num
status
site_id
payment_type
auth_type
trans_type
trace_num
All of the above fields (except the primary key) are related to other
tables
Hi,
I have the following problem:
I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8).
From the the old installation I only got the backup files (created with
'mysqldump database my_databases.sql') and the the database file (ISD,
ISM, frm).
My problem is: I can't read the
On Thu, Feb 21, 2002 at 10:17:52AM -0600, Scalper wrote:
I am a new MySQL user, so forgive my stupidity for asking the
following question (perhaps taboo). What is the latest on NuSphere
vs MySQL AB? What about Gemini. I have searched everywhere for
info, but can't seem to find anything
Varshavchick Alexander [EMAIL PROTECTED] writes:
Gentlemen,
Can you advice please if I'd wish to change the database format from
myisam to innodb should I upgrade to mysql 4.0 to get better performance
and stability, or switching to innodb alone under 3.23 will do the
trick?
Switching to
I am having problems connecting to the mysql databse from a Java application in
Windows 2K, I am using JDBC and have the mySQL odbc software installed. I am running
mysql from the command line prompt in Windows 2k. I fear I may be doing something
wrong, if anyone has a step by step solution,
I have the following table:
CREATE TABLE phpSP_users (
primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
user varchar(50) NOT NULL,
password varchar(30) NOT NULL,
userlevel smallint(3) DEFAULT '0' NOT NULL,
service_name varchar(50) DEFAULT 'A Childs Place',
Description:
I'm seeing random hung reads() after a mysql insert that appears to be
related to a sig alarm race condition. The basic workflow of this program
is
while (1)
recvfrom() /* few hundred packets a sec */
parse packet
insert into sql
However, once per second a sig alarm is
I didn't pick the operating system( I don't know it well at all ), and
didn't do the install of mysql on this system, but now I have to figure out
where things are and how to fix it.
What I am use to, is installing on Red Hat with the rpm. ( if someone knows
the differences in the operating
Does mysql have permission to write to that location?
-Original Message-
From: alastair [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 10:33 AM
To: [EMAIL PROTECTED]
Subject: Logging problem with --log, my.cnf etc.
Hello,
I am using MySQL 3.23.36 on Linux. This is a
In the last episode (Feb 21), Luc Foisy said:
I didn't pick the operating system( I don't know it well at all ),
and didn't do the install of mysql on this system, but now I have to
figure out where things are and how to fix it. What I am use to, is
installing on Red Hat with the rpm. ( if
On Thu, Feb 21, 2002 at 01:02:02PM -0500, Luc Foisy wrote:
Does mysql have permission to write to that location?
Yes. I'm starting and stopping MySQL using an init script a la Redhat.
This calls 'safe_mysqld' with some args (e.g. --user,--pid-file etc.) -
all started as user root as usual.
The
Using foreign keys is a really, really good idea. Programs can't be
trusted (and what about running sql queries ad hoc). Even with a really
big database I wouldn't get rid of the keys, just time to move to a
bigger better machine/configuration.
-Original Message-
From: David Felio
Hello,
Have a look at :
http://www.compagnie.com/stef/solution1.jpg
http://www.compagnie.com/stef/solution2.jpg
I'm searching for a solution to change a high traffic
mysql server with a
distributed system.
1)Is the solution 1 is good for a writing + reading
access ? Are there
problems with
020221 13:12:19 mysqld started
020221 13:12:20 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020221 13:12:20 mysqld ended
also it would be important to note /etc/my.cnf
[mysqld]
datadir=/usr/data/mysql
pid-file=/usr/data/mysql/tmcdbs01.mysql.pid
ahh could be a
Any book you guys recommend for learning the specific strenght of MySQL, I'm
have a Oracle background and would like to learn more on MySQL.
Stephane
SQL, Query
-
Before posting, please check:
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis: Install Crash : MySQL-3.23.49-1 /RedHat 7
Severity:
Priority:
Category:
MySQL by Paul DuBoise
Paul monitors this mailing list, so if you have questions concerning what
you've read, he may answer.
-Original Message-
From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 1:08 PM
To: Mysql (E-mail)
Subject: MySQL Book
Any
Hi!
Or should I look at the InnoDB tables (which are still considered beta).
InnoDB tables are classified as gamma by Innobase Oy and MySQL AB. The text
on the MySQL-Max download page is lagging behind (says beta), but to balance
it, on the front page MySQL AB classifies MySQL-Max as stable
On Thu, Feb 21, 2002 at 01:47:50PM -0500, Luc Foisy wrote:
maybe the variable you are using is not right
my 'show variables' indicates log with a value of OFF
| log | OFF
yet mysql still generates its standard error file
Hi Luc,
Thanks for the reply (but please
The bible is MySQL by PAul DuBois
ISBN: 0735709211
homepage: http://www.kitebird.com/mysql-book/
Gurhan
-Original Message-
From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 2:08 PM
To: Mysql (E-mail)
Subject: MySQL Book
Any book you guys
Would anyone be able to tell me why this happened, and how I could fix it?
mysql show slave status\G
*** 1. row ***
Master_Host: 209.217.92.34
Master_User: repslave2
Master_Port: 3306
Connect_retry: 60
Have a feeling I know the answer already, but here goes! ...
Does anyone know if (and how) MySQL supports raw devices? I¹ve been
searching the docs; can find nothing...
Thanks - Lou
-
Before posting, please check:
Hi,
I am running SuSE 7.3 Professional and i downloaded the binary files for Max
4.0 version from here: http://www.mysql.com/downloads/mysql-max-4.0.html
I followed the installation procudure to the letter from this file:
/mysql-max-4.0.1-alpha-pc-linux-gnu-i686/INSTALL-BINARY in the archive.
Hi all,
A novice question:
How can I do away with having to use the -u user and -p password
arguments every time I execute the mysql command? When I create a table
with a script the only way I can get it to work is with the command:
$ mysql samp_db -u root -p create_member.sql
$ Enter
James Austin wrote:
Hi all,
A novice question:
How can I do away with having to use the -u user and -p password
arguments every time I execute the mysql command? When I create a table
with a script the only way I can get it to work is with the command:
$ mysql samp_db -u root -p
If I have a table with a set such as this:
CREATE TABLE application (
application_num int(6) NOT NULL auto_increment,
availability set('weekdays','weekends','mornings','afternoons')
default NULL, PRIMARY KEY (application_num)
) TYPE=MyISAM;
is it possible to search based on members of the
At 13:25 -0600 2/21/02, Rick Emery wrote:
MySQL by Paul DuBoise
Paul monitors this mailing list, so if you have questions concerning what
you've read, he may answer.
You added an e to my name deliberately just to see if I'd reply,
didn't you! :-)
-Original Message-
From: Danis
oops...
Do I get credit for capitalizing the B in DuBois? GRIN
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 3:57 PM
To: Rick Emery; 'Danis Stéphane '; Mysql (E-mail)
Subject: RE: MySQL Book
At 13:25 -0600 2/21/02, Rick Emery wrote:
On Thursday 21 February 2002 03:06, Heikki Tuuri wrote:
Oh, Duh. The bigger Oops was mine. Doesn't help much to have a transaction if
you don't ask for a lock! ;o). Thx.
Oops,
the syntax is
SELECT ... FROM ... WHERE .. LOCK IN SHARE MODE;
Heikki
-Original Message-
From:
Luc,
I new to this mailinglist ( this is my first posting) But I have worked a little
with replication.
Try if the replicator is still down.
set sql_slave_skip_counter = 1; slave start
on the slave as long as you are sure the master is ok.
Let me know is this worked.
-chad
On Thu,
Neil,
Thank you for giving me that idea. That exact syntax did not
work with = but using like worked well. Problem solved.
Thanks,
John
mysql select availability FROM application;
+---+
| availability
I am trying to do an inner join between three tables. Here is what I have
tried:
select * from MapConfig LEFT JOIN ConfigString USING (id) LEFT JOIN ConfigInt
USING (id) WHERE MapConfig.layername = Roads;
What I am trying to do is to pull back all rows from MapConfig associated
with
MySQL by Paul DuBoise
Paul monitors this mailing list, so if you have questions concerning what
you've read, he may answer.
You added an e to my name deliberately just to see if I'd reply,
didn't you! :-)
Not really, but because he thinks you are Paul of Idaho!
=dn
try:
select * from MapConfig mc LEFT JOIN ConfigString USING (id)
LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = Roads;
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 4:24 PM
To: [EMAIL PROTECTED]
Subject:
Yes. Thank you. Just put a pair of around password and it works
fine. I had thought this could be handled in mysql, but hey, this
works.
rc wrote:
one way would bein bash - edit your .bashrc file to include the
following:
alias mysql='mysql -u username -p password'
On Thu, 21
actually someone sent an email to the list suggesting using .my.cnf file,
which is probably better than using the .bashrc file
On Thu, 21 Feb 2002, James Austin wrote:
Yes. Thank you. Just put a pair of around password and it works
fine. I had thought this could be handled in mysql,
On Thu, Feb 21, 2002 at 04:10:58PM -0500, Lou Picciano / Essex Systems wrote:
Have a feeling I know the answer already, but here goes! ...
Does anyone know if (and how) MySQL supports raw devices? I¹ve been
searching the docs; can find nothing...
InnoDB can use raw devices.
--
Jeremy D.
At 22:15 + 2/21/02, DL Neil wrote:
MySQL by Paul DuBoise
Paul monitors this mailing list, so if you have questions concerning what
you've read, he may answer.
You added an e to my name deliberately just to see if I'd reply,
didn't you! :-)
Not really, but because he thinks you are Paul
On Thursday 21 February 2002 3:29 pm, Rick Emery wrote:
try:
select * from MapConfig mc LEFT JOIN ConfigString USING (id)
LEFT JOIN ConfigInt cf on mc.id=cf.id WHERE MapConfig.layername = Roads;
Heh. It's been too long since I worked with SQL.
Thanks, that worked perfectly.
At 14:30 -0800 2/21/02, James Austin wrote:
Yes. Thank you. Just put a pair of around password and it works
fine. I had thought this could be handled in mysql, but hey, this
works.
I don't see how it *could* work. When the password is given on the
command line, it must follow the -p with no
At 17:18 -0500 2/21/02, John Fulton wrote:
Neil,
Thank you for giving me that idea. That exact syntax did not
work with = but using like worked well. Problem solved.
You might find that using FIND_IN_SET('afternoons',availability)
works as well.
Thanks,
John
mysql select availability
shockingly enough it works like this:
alias mysql='mysql -u username -ppassword'
On Thu, 21 Feb 2002, Paul DuBois wrote:
At 14:30 -0800 2/21/02, James Austin wrote:
Yes. Thank you. Just put a pair of around password and it works
fine. I had thought this could be handled in mysql, but
I put this line (with no space after the -p) in the .bashrc file and
sourced it;
alias mysql='mysql -u root -pbig_secret'
It gets me in ok. Van suggested the mysql way putting this in a .my.cnf
file in my home directory.
[client]
user=username
password=big_secret
I know this is basic stuff,
Hi Byron,
On Fri, 2002-02-22 at 03:23, Byron Scott wrote:
I have the following table:
CREATE TABLE phpSP_users (
primary_key mediumint(8) unsigned DEFAULT '0' NOT NULL auto_increment,
[...]
PRIMARY KEY (primary_key),
KEY user (user),
KEY primary_key (primary_key)
);
You
James Austin wrote:
I put this line (with no space after the -p) in the .bashrc file and
sourced it;
alias mysql='mysql -u root -pbig_secret'
It gets me in ok. Van suggested the mysql way putting this in a .my.cnf
file in my home directory.
[client]
user=username
alias mysql='mysql -u root -pbig_secret'
Another, more reliable way, is to use the long-form options and say
mysql --user=root --password=big_secret
--
Shankar.
-
Before posting, please check:
Hi there,
the other comments may have got you where you want but as no one had
mentioned your final option thought I'd mention (from /h at the mysql
command line)
source (\.)Execute a SQL script file. Takes a file name as an
argument.
so you can run the script from the mysql prompt.
Is there a timeline/status for 4.x functionality available?
I would like to use MySQL 4.x, however, I'm looking for some of the highly
requested functionality (ie; subselects, SP's, triggers and Views) and would
like to know where/when in the sequence of things todo does everything fall
into
Everyone,
Have u encountered this kind of query?
mysql select edate from traffic where year(edate)='2001' group by
month(edate);
++
| edate |
++
| 2001-04-29 |
| 2001-05-01 |
| 2001-06-01 |
| 2001-07-01 |
| 2001-08-01 |
| 2001-09-01 |
| 2001-10-30 |
| 2001-11-01 |
Hello all,
Suppose I have 3 tables,
1. master (auto_nr, link, dat)
CREATE TABLE master
(
auto_nr int(11) unsigned zerofill NOT NULL,
link int(11) unsigned zerofill NOT NULL,
dat DATE NOT NULL,
PRIMARY KEY auto_nr(auto_nr),
KEY link_key(link)
)
2. child1 (auto_nr, link1, value1)
CREATE TABLE
If you only interested in getting the overall sum from the child tables you
could try the following:
1)
Change your child create statements to:
CREATE TABLE child1
(
auto_nr int(11) unsigned zerofill NOT NULL,
link int(11) unsigned ,
value int(11),
PRIMARY KEY auto_nr(auto_nr),
KEY
I presuming you are expecting more results from the first select statement,
hence the reason and indicating this in the second, should then your first
statement be:
select edate from traffic where year(edate)='2001' group by
edate;
?
Regards,
Dan
-Original Message-
From: [EMAIL
I can't see any way of making this statement faster, however:
One method to increase speed, especially since the amount of data is large
is to create seperate tables into your lowest common denominator, here year
(e.g. traffic_2000,traffic_2001 etc).
Then create a merge table with the same name
Hi,
On Fri, 2002-02-22 at 11:29, [EMAIL PROTECTED] wrote:
Have u encountered this kind of query?
mysql select edate from traffic where year(edate)='2001' group by
month(edate);
++
| edate |
++
| 2001-04-29 |
| 2001-05-01 |
| 2001-06-01 |
| 2001-07-01 |
Are there any open source ERD programs for MySQL for doing basic data
modelling? I tried myERD at sourceforge and it couldn't parse the sql dump
from my database. It died with a parse exception on the unsigned attribute
for my int columns.
Any other choices out there?
Thanks,
--jeff
For reporting purposes, I usually use a wide index across all the fields
that are relevant to creating the reports. So, for example, my sales table
has this type of data:
sale_id
sale_date
salesperson_id
product_id
referral_id
[other sales data]
sale_id is an auto_incrementing primary key.
Given two tables (t1 and t2) with fields start and end, what is the most
efficient method of finding the all the intervals in the first table that
overlap any interval in the second table?
Right now, I use a query like:
SELECT t1.name, t2.name FROM t1, t2
WHERE t1.start = t2.end AND t1.end =
Hi,
I have the following problem:
I had to install a complete new server with Suse 7.2 (MySql: 3.23.37-8).
From the the old installation I only got the backup files (created with
'mysqldump database my_databases.sql') and the the database file (ISD,
ISM, frm).
My problem is: I can't read the
On Thu, Feb 21, 2002 at 08:13:51PM -0800, Jeff Kilbride wrote:
For reporting purposes, I usually use a wide index across all the
fields that are relevant to creating the reports. So, for example,
my sales table has this type of data:
sale_id
sale_date
salesperson_id
product_id
Hmmm...
Ok, my original assumption was that if I was grouping by those fields in my
SELECT, then including them in the index would help -- if the order of my
GROUP BY followed the order of the fields in the index.
Your saying it doesn't make much of a difference whether I include them or
not?
91 matches
Mail list logo