On Mon, 20 Sep 2004 10:25:16 -0400
[EMAIL PROTECTED] wrote:
> I think you missed my point. I think the 5.0.1 behavior was correct
> and the others are wrong. There is a known bug (or two) about mixing
> outer joins and inner joins and it looks like it may be fixed. IF
> you want to see all of the
Good idea. MySQL appears to use the index and skip between intervals. (I'm not sure
it always did...)
On the Feb. 29, I'd be disinclined to rely on MySQL's (or any other DB's) handling of
invalid dates. Note that it appears to take '2002-02-29' to mean Mar. 1, 2002, and
'2002-02-30' to mean
Use COUNT():
SELECT COUNT( id ) FROM test WHERE LEFT( id, 5 ) = '12345' GROUP BY value;
Wes
On Tue, 21 Sep 2004 00:24:33 +0200, Alexander Newald
<[EMAIL PROTECTED]> wrote:
> Hello,
>
> I like to get the number of lines returned by a select ... group by query:
>
> Example:
>
> SELECT id FROM
Hi,
We want to test our MYSQL (4.1.4g) server's query performance, and I
just wondering if there is a tool that enable us sending a list of
queries over HTTP or JDBC repeatedly and gather/display the
statistics?
Thanks
HT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Hello,
I like to get the number of lines returned by a select ... group by query:
Example:
SELECT id FROM test WHERE LEFT(id,5) = "12345" GROUP BY value;
Perhaps I will get
+---+
| id|
+---+
| 2 |
| 1 |
| 5 |
+---+
3 rows in set (0.02 sec)
But
Andre Matos writes:
> SELECT * FROM scan WHERE TimePointID = 3 AND ScanQCResult = 'n' AND
> (ScanStatusID < 90 OR ScanStatusID > 98);
>
> I realized latter analyzing this select that I made a mistake using OR at
> this point: (ScanStatusID < 90 OR ScanStatusID > 98), it should be "AND".
The second
I have tried installing on LINUX syste & got errors.
Kirti
-Original Message-
From: Nathan Mealey [mailto:[EMAIL PROTECTED]
Sent: Monday, September 20, 2004 3:34 PM
To: [EMAIL PROTECTED]
Subject: DBD::MySQL
Has anyone out there had any trouble installing DBD::MySQL for MySQL
4.1.x on M
Hello Bill,
Your explanation gave me an idea:
SELECT id
FROM story
WHERE ((putdatetime>='2003-09-20' AND putdatetime<'2003-09-21' )
OR (putdatetime>='2002-09-20' AND putdatetime<'2002-09-21')
OR (putdatetime>='2001-09-20' AND putdatetime<'2001-09-21'))
AND put=1 AND front=1
ORDER BY
* Andre Matos
> I am performing a SELECT and I am getting 0 rows when I run the SELECT
> direct in the MySQL database and getting 1 when I run using PHP.
> This is my
> select:
>
> SELECT * FROM scan WHERE TimePointID = 3 AND ScanQCResult = 'n' AND
> (ScanStatusID < 90 OR ScanStatusID > 98);
Looks
I'm trying to use C API to MySQL.
MySQL Version: 4.0.20a
Distribution Windows Binary
Machine: P IV on intel 845GL board, 256 MB Ram, Win98se
Compiler: Digital Mars C/C++ Compiler Version 8.40
(ftp://ftp.digitalmars.com/Digital_Mars_C++/Patch/dm840c.zip)
WHEN I COMPILE
* John Mistler
> I have a table in which the first column is either 1 or 0. The second
> column is a number between 0 and 59. I need to perform a query
> that returns
> entries where:
>
> 1. IF the first column is 1, the second column is NOT 0
> 2. IF the first column is 0, the second column i
I have a table in which the first column is either 1 or 0. The second
column is a number between 0 and 59. I need to perform a query that returns
entries where:
1. IF the first column is 1, the second column is NOT 0
2. IF the first column is 0, the second column is anything.
It seems simple, b
Hi List,
I am performing a SELECT and I am getting 0 rows when I run the SELECT
direct in the MySQL database and getting 1 when I run using PHP. This is my
select:
SELECT * FROM scan WHERE TimePointID = 3 AND ScanQCResult = 'n' AND
(ScanStatusID < 90 OR ScanStatusID > 98);
I realized latter anal
Hello
I have a table
CREATE TABLE community_files (
id int(3) unsigned NOT NULL auto_increment,
type int(10) unsigned NOT NULL default '0',
category_id int(10) unsigned NOT NULL default '0',
filename varchar(50) NOT NULL default '',
path varchar(255) NOT NULL default '',
description va
The issue is that the code doesn't know (and doesn't care) if the data
is actually being changed, it's just accepting the posted form data,
compiling it, and updating the record. It uses the return value (number
of rows updated) to make sure there wasn't a problem updating the
record. However
I'm not following why you need to force an update? You mentioned a row
refresh, but I'm not sure in what context. If you are looking to find
out if a row has changed since you last read it, then you should have a
timestamp field. The first timestamp field is always updated when data
changes in
I would first store your original query's results in a temp table:
CREATE TEMPORARY TABLE tmpTracks
SELECT AudioTrack.*
FROM AudioTrack
INNER JOIN AudioTracks_Categories
ON AudioTrack.AudioTrack_id = AudioTracks_Categories.AudioTrack_id
WHERE AudioTracks_Categories.Category_id IN (cat1,ca
At 14:49 -0500 9/20/04, Jeff Demel wrote:
That's what I was afraid of.
Now I have to add a bunch of code to check the data before sending
(pull the record, compare the data, then decide to run the update or
not). How efficient is that, I wonder?
Is there any way to force it to update the row?
I'
That's what I was afraid of.
Now I have to add a bunch of code to check the data before sending (pull
the record, compare the data, then decide to run the update or not).
How efficient is that, I wonder?
Is there any way to force it to update the row?
I'm thinking a workaround might be to add a
Hello:
Installing MySQL-server-4.0.21-0.i386.rpm
on Red Hat 9.0
Getting the following:
error: Failed dependencies:
libmysqlclient.so.10 is needed by (installed) MySQL-python-0.9.1-6
libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
libmysqlclient.so.
No, MySQL will indicate if anything in the row has changed. If you are
updating with the same data, than nothing changes and MySQL doesn't
waste the time to lock the table, write the data and update the
indexes. It's much more efficient this way.
On Sep 20, 2004, at 3:22 PM, Jeff Demel wrote:
I
Has anyone out there had any trouble installing DBD::MySQL for MySQL
4.1.x on Mac OS X 10.3? I have tried it on several machines in my
company's office, but it fails on all that are running 4.1.x, and
installs fine on those running 4.0.x
Thoughts?
Thanks,
Nathan
--
Nathan Mealey
Director of Op
I'm seeing some odd behavior when I run an UPDATE query, and need to
know if this is something that MySQL does. It could be something the
MySQLDirect .NET provider is doing, and to cover that possibility I've
sent an email to their support team.
So anyway, here's the scenario.
If I run an UPDA
I have two tables, let's say AudioTrack and Category
Every AudioTrack record can belong to one or more ( or none )
Categories.
I have created an intermediate table, AudioTracks_ Categories
containing only the IDs of AudioTrack and Category to keep track of the
link.
to find all tracks belonging
Wow Bill,
Thanks!
It's so obvious! But only experience can bring such sollutions.
I'll change the query to a more "hardcoded"-look!
Thanks again!
Dirk.
Bill Easton wrote:
Dirk,
If you use a function on the column, MySQL will not use the index on that
where clause. You need to somehow arrange to no
Dirk,
If you use a function on the column, MySQL will not use the index on that
where clause. You need to somehow arrange to not use a function
on the column with the index.
Here's the query you asked about.
SELECT id FROM story
WHERE MONTH(putdatetime) = MONTH('2004-09-19')
AND DAYOFMONTH(pu
Hi,
I have a web application with servlets and jsp's. I use a connection pool to
optimize connections to database.
Usualy all works fine but sometimes, after a period of inactivity (30-50
minutes), connections are lossed. This only occurs if mysql and web server
are in different machines.
In MySql
I think you missed my point. I think the 5.0.1 behavior was correct and
the others are wrong. There is a known bug (or two) about mixing outer
joins and inner joins and it looks like it may be fixed. IF you want to
see all of the students THAT TABLE (students) needs to be on the LEFT side
of a
By replacing deleted records with new information, you run the risk of
misidentifying data in related tables. What if you had a record in a table
called "person" with an ID of 6 that belonged to Mary Jones. You delete it
and create a new record 6 for Bob Mondo? Let's say you have a related
tab
On Mon, 20 Sep 2004 09:33:56 -0400
[EMAIL PROTECTED] wrote:
> Sounds like your 4.0.20 may be the buggy installation... let me see
> if I can explain.
Except this is a 5.0.1 installation. The query worked as is in 4.0.20
(and it also worked in 5.0.0), only after playing with 5.0.1 did the
results
Sounds like your 4.0.20 may be the buggy installation... let me see if I
can explain.
Let's analyze your FROM clause and imagine there is no WHERE clause, for
the moment:
FROM student s
INNER JOIN enrollment e ON e.tech_id = s.tech_id
INNER JOIN submitted_assignment sa ON sa.tech_id = s.tech_id
I recommend starting with the online manual. It has a section on
installation and a short tutorial section to help you get used to the
MySQL client.
http://dev.mysql.com/doc/mysql/en/index.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Caulfield, Linda" <[EMAIL PROTE
If by "relations" you mean "foreign keys" the answer is YES. Use the
InnoDB table type and read these instructions:
http://dev.mysql.com/doc/mysql/en/ANSI_diff_Foreign_Keys.html
http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html
Don't forget to follow the hyperlinks for additi
Dear list,
I want to display the result of the some mysql query differently ..
I have a mysql table(allreps_orgs) with 2500,000 entries.
QUERY IS:
select distinct * from
allreps_orgs as p1,allreps_orgs as p2,
where p1.organism='Plasmodium' AND p2.organism='Caenorhabditis'
AND p1.repeat=p2.re
34 matches
Mail list logo
