Baron, thank you for your response.
I did get a different result for the query:
18184639,12544976,0,0,0,0,0,0,0,0,0,0,0,0
But it still is all the data for the ticket in the row.
If I group by the ticket (key) number and the status, I get one line per
status with the right numbers.
Ryan Bates wrote:
I'm trying to determine why a subquery is slower than running two
separate queries. I have a simple many-to-many association using 3
tables: projects, tags and projects_tags. Here's the query I'm using to
find the projects with a given tag:
SELECT * FROM projects WHERE id
Ryan,
Why is it so much faster?
Subquery optimisation in MySQL is a problem. For ideas see 'The
unbearable slowness of IN()' at
http://www.artfulsoftware.com/infotree/queries.php.
PB
Ryan Bates wrote:
I'm trying to determine why a subquery is slower than running two
separate queries. I
Hi,
can i change the datetime format on mysql in a german format?
At the moment the dates are stored like 2007-10-19 19:06:17 but if i
send a query (which comes from user input) the query looks like WHERE
Datum = '19.10.2007' and i got not what i want.
iam using mysql (5.0.45) on (german)
I'm trying to wrap my head around dealing with people in a table that
have multiple names or akas.
I run an entertainment news site and have to deal with people like
Pamela Anderson (who was once Pamela Lee, Pamela Anderson Lee, Pamela
Denise Anderson), Eva Longoria (who's now Eva Longoria
Ralf Hüsing wrote:
Hi,
can i change the datetime format on mysql in a german format?
At the moment the dates are stored like 2007-10-19 19:06:17 but if i
send a query (which comes from user input) the query looks like WHERE
Datum = '19.10.2007' and i got not what i want.
iam using mysql
Ian M. Evans wrote:
I'm trying to wrap my head around dealing with people in a table that
have multiple names or akas.
I run an entertainment news site and have to deal with people like
Pamela Anderson (who was once Pamela Lee, Pamela Anderson Lee, Pamela
Denise Anderson), Eva Longoria
I'm trying to determine why a subquery is slower than running two
separate queries. I have a simple many-to-many association using 3
tables: projects, tags and projects_tags. Here's the query I'm using
to find the projects with a given tag:
SELECT * FROM projects WHERE id IN (SELECT
Can you send us a copy of your my.cnf at the moment.
Also, if you can provide some reports that will help us determine the best
functionality, that would also help a lot. It is useful to know what is
getting read/writing (or which function is being requested the most...).
Table format is also
Weston, Craig (OFT) wrote:
There were 2 changes -
First was IF(`status` = 'WIP',SUM(time_to_sec(RIGHT(`CLOCK_TIME`),8)),0)
AS 'WIP' ( I addded the RIGHT limit on the string)
And second was grouping by KEY,STATUS
Further experimentation makes it appear that I am getting the right
number of
There were 2 changes -
First was IF(`status` = 'WIP',SUM(time_to_sec(RIGHT(`CLOCK_TIME`),8)),0)
AS 'WIP' ( I addded the RIGHT limit on the string)
And second was grouping by KEY,STATUS
Further experimentation makes it appear that I am getting the right
number of seconds for the entire string,
Weston, Craig (OFT) wrote:
Baron, thank you for your response.
I did get a different result for the query:
18184639,12544976,0,0,0,0,0,0,0,0,0,0,0,0
But it still is all the data for the ticket in the row.
If I group by the ticket (key) number and the status, I get one line per
status with
Hi All,
I have just released PBXT 0.9.90 and MyBS version 0.5.03. PBXT is a
transactional storage engine for MySQL (http://www.primebase.com/xt),
and MyBS is a storage engine that enables streaming of BLOB data
directly in and out of a MySQL database (http://www.blobstreaming.org) .
For
A little bit easier of a way to do this could be the following command:
mysql -u[user] -h[host] -p [database] [mysql dump file]
Make sure the database you're importing into is EMPTY (or at least the
TABLES you are importing to are empty...)
On 10/19/07, Werner Van Belle [EMAIL PROTECTED]
On 19 Oct 2007, at 04:35, Paul McCullagh wrote:
For this release I have completed changes to the MySQL Connector/J
5.0.7, to allow BLOB data to be transparently stored and retrieved
from the MyBS BLOB repository. The new version of the driver is
called MySQL Connector/J SE (streaming
Hi Craig,
Weston, Craig (OFT) wrote:
Hello everyone.
Once again, I am jousting at the windmill of time and date formulae
within MYSQL. I seek to create a cross-tab or pivot table of the SUM of
all times with a specific category, on a per-ticket basis. I have
everything working except the math
Hello,
If it is a dump you can pipe it into mysql. If you have a csv like file you
can import it with LOAD DATA LOCAL INFILE like things. An example below:
DROP TABLE IF EXISTS EnsgDescriptions;
CREATE TABLE IF NOT EXISTS EnsgDescriptions
(stable_id VARCHAR(128) PRIMARY KEY,
description
Hi,
I have a 250mb dump and need to extract some data.
I know how to export a single table, but not import a single table using
mysqldump.
Any ideas?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello everyone.
Once again, I am jousting at the windmill of time and date formulae
within MYSQL. I seek to create a cross-tab or pivot table of the SUM of
all times with a specific category, on a per-ticket basis. I have
everything working except the math part. Even that is kind of working
ok,
19 matches
Mail list logo