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 (who's
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 mysq
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 (germa
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 Par
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 IN
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 h
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 project
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 impo
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]> wro
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
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 enabl
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 t
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.
18184639
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 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, b
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 VARCHAR
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]
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 t
19 matches
Mail list logo
