Albert,
Your spec isn't entirely clear to me (eg if sd1 & sd2 were 'unique
within each record', wouldn't there be zero rows where sd1=sd2?), but is
this what you're looking for ...
SELECT
zz,
COUNT(zz) as zzCount,
SUM(IF(zz=sd1 AND sd1=sd2, 1, 0)) AS sd1sd2Count
FROM ss
GROUP BY zz;
Peter
In the last episode (Jul 22), Andy McHargue said:
> I have table with very similar values in one field,
>
> count word
> -
> 2 APPLE
> 6 APPLES
> 1 APPEL
>
> select *,sum(count) as total from table group by word will leave
> these rows separated.
>
> So I want to GROUP BY that field to
I would be grateful if those of you around this weekend could help me
figure out if what I'm after is possible. I've already spent hours
with the manual, the archives and my books. I've looked at JOINS and
TEMP TABLES but still can't come up with a solution.
THE ENVIRONMENT: MySQL Version
Hi,
I've just converted my databases so they are using per_table
tablespaces.
When I do a show table status in that database the Comment line
still shows
the amount free, but I assume this doesn't mean anything now ?? It
doesn't
make sense ?
As innodb_file_per_table makes individual f
I would really like to hear how some of you are handling backups on
high-availability servers. The DBA in my company is skeptical about
switching from MSSQL Server to MySQL, this is one of his reasons
(backups). If someone is making MySQL work in a high-availabity
environment, let's hear about i
At 07:03 PM 7/22/05, Siegfried Heintze wrote:
I'm having trouble getting the like clause to work. It seems to work fine in
the MySQL Control Center 9.4.beta. I'm using MySQL 4.0.23-debug.
use DBH;
my $sth = DBH->prepare("SELECT 'David!' LIKE '%D%v%'");
$sth->execute();
my $row;
print join(@$row
I have table with very similar values in one field,
count word
-
2 APPLE
6 APPLES
1 APPEL
select *,sum(count) as total from table group by word will leave these
rows separated.
So I want to GROUP BY that field to add the numbers (to come up with 9
APPLES). Is this possible? I gues
I'm having trouble getting the like clause to work. It seems to work fine in
the MySQL Control Center 9.4.beta. I'm using MySQL 4.0.23-debug.
use DBH;
my $sth = DBH->prepare("SELECT 'David!' LIKE '%D%v%'");
$sth->execute();
my $row;
print join(@$row,",")."\n" while ($row = $sth->fetch);
This doe
So it appears I am having an issue with 4.1.13 which I'm guessing is
a bug... wanted some input before I file it...
Setting up a new machine to take over for an old one, so it's clean,
Operating System and some empty disks... the server does nothing
other than MySQL so there are no other pr
At 15:56 -0600 7/22/05, Siegfried Heintze wrote:
Could someone kindly point me to the documentation on the like clause. I
found the documentation on the SELECT statement but could not find the
discussion on the like clause. I search too -- but there were too many
"like"'s used outside of the SQL
Could someone kindly point me to the documentation on the like clause. I
found the documentation on the SELECT statement but could not find the
discussion on the like clause. I search too -- but there were too many
"like"'s used outside of the SQL syntax.
Thanks,
Siegfried
--
MySQL General Mail
On Friday 22 July 2005 08:56, [EMAIL PROTECTED] wrote:
> To confirm that you would like
>
> [EMAIL PROTECTED]
>
> removed from the mysql mailing list, please click on
> the following link:
>
> http://lists.mysql.com/u/mysql/42e0ecf613841f68/sotl155360=earthlink.net
>
> This confirmation serves
Hello everyone,
I cannot figure this out. I have a table like the following:
Tab_A
datetime_field datetime not null,
num_field bigint not null
I do a SELECT as follows:
Select datetime_field, num_field from Tab_A
where datetime_field='2005-03-10' and
num_field = 1234;
I return 2 ro
Gentlemen
Thank you VERY much ! Am now back to working again
Then when Amazon delivery my MySQL books I should be a lot wiser too !
Very much appreciated all the assistance
Andy
On 7/22/05 3:12 PM, "Santino" <[EMAIL PROTECTED]> wrote:
> OK
>
> Now open the terminal and type:
> cd /usr/loc
OK
Now open the terminal and type:
cd /usr/local/mysql/
./scripts/mysql_install_db
and restart mysql.
Santino Cusimano
At 14:34 -0400 22-07-2005, Andy Hilton wrote:
This would appear to be the relevant stuff - the err file was in the
mysql/data directory
050722 14:23:32 mysqld started
This would appear to be the relevant stuff - the err file was in the
mysql/data directory
050722 14:23:32 mysqld started
050722 14:23:32 [Warning] Setting lower_case_table_names=2 because file
system for /usr/local/mysql/data/ is case insensitive
050722 14:23:33 InnoDB: Database was not shu
Andy Hilton wrote:
Santino - many thanks (thanks to Brent too but I cannot reply to him
directly - seemingly I am not allowed !)
I had removed all of the mysql folder and the 'other' directory - the one
with the really long name where most stuff seemed to beand did a
re-install...
What hap
This may be a stupid question, but on the mysql site, there are
downloads for 64 bit, then the same 64 bit downloads for redhat ES3. If
I'm using fedora core 3, do I need the redhat rpms?
Anne
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
The permission of directory /usr/local/mysql/data and it's contents
must be mysql/mysql
so open the terminal and type
cd /usr/local/mysql
chown -R mysql:mysql ./data
and try to restart mysql.
Santino Cusimano
At 12:40 -0400 22-07-2005, Andy Hilton wrote:
Santino - many thanks (thanks to Bre
Santino - many thanks (thanks to Brent too but I cannot reply to him
directly - seemingly I am not allowed !)
I had removed all of the mysql folder and the 'other' directory - the one
with the really long name where most stuff seemed to beand did a
re-install...
What happens now is I have an
We are using MyISAM tables with MySQL running on Windows. We also use
Acronis (www.acronis.com) to take images of the various disc partitions
we have. This uses the "Volume Shadow Copy" capability of XP and Win2K.
Acronis can run a command before the "snapshot" is taken and after it.
It only takes
The directory where MySql install bin script and data is:
/usr/local/mysql
this is a symbolic link to another directory in /usr/local/.
Try to open a terminal and type:
cd /usr/local/mysql
bin/mysqlsafe &
this command launches the server.
bin/mysql
launches the client.
There is a file in scri
Did you try that link? When I follow it, I get a search results page
saying <>. Too
bad it doesn't actually show the search results
> -Original Message-
> From: Michael Monashev [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 21, 2005 5:45 PM
> To: Ryan Stille; mysql@lists.mysql.c
I would really like to hear how some of you are handling backups on
high-availability servers. The DBA in my company is skeptical about
switching from MSSQL Server to MySQL, this is one of his reasons
(backups). If someone is making MySQL work in a high-availabity
environment, let's hear about it
It's SOOO frustrating !
Yes that let me set a password for root - thanks
But no change on the admin app - still tells me it cannot get the catalog
list - 'Could not retrieve user list:
SELECT command denied to user 'root'@'localhost' for table 'user' (error
1142)'
I tried for interest using
Sounds like it could be a problem with the graphical management tool.
Maybe it just doesn't like a system with no password set, which is a
very bad thing.
It sounds like you may not have set an initial root password for
mysql. It defaults to being nothing, which is not good.
In your termin
I believe the conflict here is the OR. Try this...
select * from table
where field1 = 'VALUE1' and field2 like 'VALUE2%'
union
select * from table
where field3 = 'VALUE1' and field2 like 'VALUE2%'
Currently, MySql can't utilize two indexes on the same table at
the same time but it is on their
Privet!
Yogesh wrote:
HI,
I have a client that runs php+mysql application and it has a problem with "ORDER BY
some_varchar_field" sql expression. The DB is in russian cp1251 encoding and "order
by" doesnt produce an alphabetically ordered result. our mysql server default charset is
latin1 a
The system cannot used the index on field2 because it is the second half
of the index in both cases, and it can only use indexes in order. It
cannot use the separate indexes on field 1 and field 2 because the are
ORred together.
If you rephrase your query
SELECT * from table
WHERE field2 LI
HI,
I have a client that runs php+mysql application and it has a problem with
"ORDER BY some_varchar_field" sql expression. The DB is in russian cp1251
encoding and "order by" doesnt produce an alphabetically ordered result. our
mysql server default charset is latin1 and I don't know of any wa
Hi
field2 is indexed. I have 2 indexes. One is on field1 and field2, the
second indexes field3 and field2.
You mean a separate index which only indexes field2 ? Ithought that
the type of query I am doing is a good reason for doing composite
indexes.
Chris
On 7/22/05, Eugene Kosov <[EMAIL PROT
Eugene Kosov wrote:
Chris Faulkner wrote:
HI
I have a query like this
select * from table where (
( field1 = 'VALUE1' and field2 like 'VALUE2%' ) OR ( field3 = 'VALUE1'
and field2 like 'VALUE2%' ) )
I have created two composite indexes - one on field1 + field2 and one
on field3 + field2. Ex
Chris Faulkner wrote:
HI
I have a query like this
select * from table where (
( field1 = 'VALUE1' and field2 like 'VALUE2%' )
OR
( field3 = 'VALUE1' and field2 like 'VALUE2%' )
)
I have created two composite indexes - one on field1 + field2 and one
on field3 + field2. Explain on the SQL
Hi Heikki,
I've followed your instructions here and its all worked fine.
Now I currently have a 200Gb shared innodb table space which is sitting
almost empty now all databases have there own table spaces.
I want to reduce this amount but ot sure what is the best way to do it.
I know I can not ju
Andrea Gangini <[EMAIL PROTECTED]> wrote on 22/07/2005 10:17:34:
> I have a column in one of my table, which:
> - must be unique
> - must be indexed because almost all queries are "SELECT .. WHERE
> COLUMN LIKE "
>
> I created two indexes this column, one of type UNIQUE and a normal one
I have a column in one of my table, which:
- must be unique
- must be indexed because almost all queries are "SELECT .. WHERE
COLUMN LIKE "
I created two indexes this column, one of type UNIQUE and a normal one,
because I thought that the unique index and a normal indexes were
differ
HI
I have a query like this
select * from table where (
( field1 = 'VALUE1' and field2 like 'VALUE2%' )
OR
( field3 = 'VALUE1' and field2 like 'VALUE2%' )
)
I have created two composite indexes - one on field1 + field2 and one
on field3 + field2. Explain on the SQL indicates that the indexes
Thanks for the information, I will look more. What are the specifications
(libraries) for compile mysql 3.22?
I want to use 3.22.xx that I know is stable for my application and for
continue use ISAM format in the future and with a more modern linux
distribution I want to use 4.1 or wait for 5.0.
sorry,my english is poor.
Follow is my mean.
One,I create a index.(create index orders_test on orders(o_id,o_c_id))
Two,I do explain again.
Follow is result
--
1, 'PRIMARY', 'orders', 'range', 'PRIMARY,orders_test', 'orders_test',
39 matches
Mail list logo
