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',
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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 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
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 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
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
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
39 matches
Mail list logo
