Hello all,
I get this error when compiling:
Object file format error in: /usr/sw: read_cur_obj_info: File is not a
regular file
I have the same thing in /usr/sw as you'd find in /usr/local
I'm using gcc 4.0.2 and the tru64 native compiler.
I tried taking off a few configure directives, such as
I have a char fiel where I am keeping dates formatted as year-month-day
(2006-10-09)
Now I am trying to find all the records between 2 strings (2 dates). The
2 queries below
should return the same number of records by they do not.
My query is this:
SELECT COUNT(*) FROM proj where
Are you sure those are the results to those queries? ¢,m
Your second query will return more because it includes values outside of
the date range specified in the first query.
In the second result set you have 2009 and 'invalid dates' that would
not be picked up by the first query.
Regards
Am I totally missing something? Why do you believe the two queries should
return the same # of rows? First one has a qualification of proj_adv_date
'2008-12-16' whilst the second one does not...
On Mon, Dec 15, 2008 at 12:12 PM, Néstor rot...@gmail.com wrote:
I have a char fiel where I am
Sorry!!! I apoligized for being blind. Yes, in my small mind I was
thinking that I do not have records biggeer than 2008 but I do and my mind
refused to see the records for 2009 and 2010.
Sorry again for being so blind to the obvious.
:-(
On Mon, Dec 15, 2008 at 9:50 AM, Phil
a separate record
for each host into the 'db' table, and not writing anything to the
'host' table.
So my question is: why does the 'if empty db.host field/look up in host
table' method suggested in the manual not work? What step am I missing?
Thanks in advance for your help. I'd appreciate it if you
: REGEXP help Finding phone numbers (nnn) nnn- format
Hi,
Please, can anyone lend a hand in helping pullout
phone numbers from the DB that only match
the format (nnn) nnn- ?
SELECT phone_work FROM leads WHERE phone_work REGEXP 'the_expression?'
I've been trying to lick this for hours now
On Wednesday 03 December 2008 08:39:54 Paul Nowosielski wrote:
Hi,
Please, can anyone lend a hand in helping pullout
phone numbers from the DB that only match
the format (nnn) nnn- ?
([0-9]{3}) [0-9]{3}-[0-9]{4}
I think
HTH
W
SELECT phone_work FROM leads WHERE phone_work REGEXP
Hi,
Please, can anyone lend a hand in helping pullout
phone numbers from the DB that only match
the format (nnn) nnn- ?
SELECT phone_work FROM leads WHERE phone_work REGEXP 'the_expression?'
I've been trying to lick this for hours now with
no avail.
Thank you,
Paul
--
MySQL
Dear All,
I am looking for help as I want to make a website like orkut.
can u plz help me in designing the Data Table and Queries
--
Thanks Regards,
Tanveer Bhurani
The Bend on the road is not the end of the Road..., Unless you forget
to make the turn
what rate of pay are you offering?
On Mon, Nov 24, 2008 at 5:13 AM, Tanveer Bhurani
[EMAIL PROTECTED]wrote:
Dear All,
I am looking for help as I want to make a website like orkut.
can u plz help me in designing the Data Table and Queries
--
Thanks Regards,
Tanveer Bhurani
The Bend
SELECT ProductName FROM Products
WHERE ProductScore 100
ORDER BY CASE WHEN ProductScore = 125
THEN 0
ELSE 1
END, ProductScore
But this query won't use an index, so it would be a good idea to do this in
two queries
2008/10/24 Tompkins Neil [EMAIL PROTECTED]
Hi
I've the following basic
Hi
I've the following basic query like
SELECT ProductName FROM Products
WHERE ProductScore 100
ORDER BY ProductScore
However, how can I order by ProductScore, but ensure the product with ID 125
is at the top ? Is this possible.
Thanks
Neil
Following on from my email below I now need help with the following
problem. Here is a list of my sample data
Date ProductID ProductNameProductScore
Quantity
2008-11-10100 Red Light
0.05 10
2008-11-11100
SELECT ProductID,
ProductName,
AVG(ProductScore * Quantity) AS a
FROM Products
GROUP BY ProductID
ORDER BY a DESC
2008/10/24, Tompkins Neil [EMAIL PROTECTED]:
Following on from my email below I now need help with the following
problem. Here is a list of my sample data
Date
ProductID,
ProductName,
AVG(ProductScore * Quantity) AS a
FROM Products
GROUP BY ProductID
ORDER BY a DESC
2008/10/24, Tompkins Neil [EMAIL PROTECTED]:
Following on from my email below I now need help with the following
problem. Here is a list of my sample data
Date
, Tompkins Neil [EMAIL PROTECTED]:
Following on from my email below I now need help with the following
problem. Here is a list of my sample data
Date ProductID ProductNameProductScore
Quantity
2008-11-10100 Red Light
0.05
, Oct 24, 2008 at 2:28 PM, Olexandr Melnyk [EMAIL PROTECTED]wrote:
SELECT ProductID,
ProductName,
AVG(ProductScore * Quantity) AS a
FROM Products
GROUP BY ProductID
ORDER BY a DESC
2008/10/24, Tompkins Neil [EMAIL PROTECTED]:
Following on from my email below I now need help
Products
GROUP BY ProductID
ORDER BY a DESC
2008/10/24, Tompkins Neil [EMAIL PROTECTED]:
Following on from my email below I now need help with the following
problem. Here is a list of my sample data
Date ProductID ProductNameProductScore
Quantity
2008-11-10
,
ProductName,
AVG(ProductScore * Quantity) AS a
FROM Products
GROUP BY ProductID
ORDER BY a DESC
2008/10/24, Tompkins Neil [EMAIL PROTECTED]:
Following on from my email below I now need help with the following
problem. Here is a list of my sample data
Date
Hi,
For mysql stress test suite (mysql-stress-test.pl) to execute, it requires
--stress-tests-file to be provided which contains the list of tests to be
executed. As per the documentation the default name of the file is
stress-test.txt and it will be located under ./mysql-test directory.
But I
Hi all,
I have a table I needed to prune because it had grown to 5 million rows and
it appeared that that app that uses it couldnt anymore.
I am in the process of:
DELETE FROM mytable WHERE id 300;
the above has been running for close than an hour and I am starting to get a
little
Hello
I would not recommend delete massive numbers of records in a single sql
statement. I have had problems doing this on a system with few records (1.7
million) and doing a delete with a condition clause of where 1 = 1. The
server had problems with this.
The MySQL server is probably
, 25 Sep 2008 15:45:00 -0700
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Help!
Hello
I would not recommend delete massive numbers of records in a single sql
statement. I have had problems doing this on a system with few records (1.7
million
@lists.mysql.com
Subject: Re: Help!
Hello
I would not recommend delete massive numbers of records in a single sql
statement. I have had problems doing this on a system with few records (1.7
million) and doing a delete with a condition clause of where 1 = 1. The
server had problems
hi list.
I want to build a category system and a help system. I think that's a
very common task, and I'm curious about what's your SQLs to build these.
I'm really appreciated your sharing the table structure with me, Thanks.
Regards,
--
Fayland Lam // http://www.fayland.org/
Foorum based
When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
Does anyone know how I can resolve this?
QUERY (windows server from the cmd prompt)
mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
--password=[PASSWORD] --host=[HOST] [TARGET DB]
ERROR
Shaun Adams schrieb:
When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
Does anyone know how I can resolve this?
QUERY (windows server from the cmd prompt)
mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
--password=[PASSWORD]
Hi MySQL Users-
I have a query problem I have been working on for quite some time and I am
really at a loss to find a native function(s) to handle my task.
I have this table:
CREATE TABLE BookCategoryMetrics (
BookName VARCHAR(255),
CategoryId VARCHAR(128),
RatingSum DOUBLE,
Cost DOUBLE,
David,
My goal is to create a report, that lists the Top 100 most expensive
BookNames, for every CategoryId in this table.
I think you can map the example under Within-group quotas (Top N per
group) at http://www.artfulsoftware.com/infotree/queries.php to your
requirement.
PB
David
Dear All,
I am interested in performing a sub query that removes duplicate records from
a temporary table prior to pushing the data to the main table.
I am not sure if it is possible and thought I would ask prior to the endeavor.
I currently use php to perform this operation but is really bogs
the dreaded Unknown column 's1.div_id' in 'where
clause' error message.
I think the statement above shows what I am trying to do better than me
explaining it. My only real problem is that the div_id needs to be gotten
from the team_season table.
Any help would be appreciated
Thanks
Steve
);
Of course, I am getting the dreaded Unknown column 's1.div_id' in 'where
clause' error message.
I think the statement above shows what I am trying to do better than me
explaining it. My only real problem is that the div_id needs to be gotten
from the team_season table.
Any help would
PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Multiple Query/Insert help
Hi Steve,
You're seeing this error because this query:
select div_id
from team_season where team_id=s1.div_id
is being run independently of the rest, so it doesn't know of s1 in
this context. You would
/Insert help
Hi Steve,
You're seeing this error because this query:
select div_id
from team_season where team_id=s1.div_id
is being run independently of the rest, so it doesn't know of s1 in
this context. You would probably be better with an INNER JOIN here,
something like the following (may
Subject: Re: Multiple Query/Insert help
Hi Steve,
You're seeing this error because this query:
select div_id
from team_season where team_id=s1.div_id
is being run independently of the rest, so it doesn't know of s1 in
this context. You would probably be better with an INNER JOIN here,
something
@lists.mysql.com
Subject: RE: Multiple Query/Insert help
the only possible suggestion i have would be to disambiguate the selected
columns with 'as'
insert into games2 (sea_id,date,time,loc_id,hteam,vteam,div_id)
(
select
'36' as sea_id, game_date as date, begin_time as time, loc_id as loc_id
]; [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: RE: Multiple Query/Insert help
Date: Sat, 16 Aug 2008 10:10:15 -0500
Thank you, but I still get an error and I can't figure it out: Unknown
column 's1.div_id' in 'on clause'
Any other thoughts?
Steve
-Original Message-
From
Thank you Martin and Andy for your help in this matter. I redid the queries
taking hints from yours and came up with one that worked. I am not that
great with INNER JOIN's and couldn't get yours to work, even though you did
still say that I needed to tweek it. It would be nice to know the query
help in this matter. I redid the queries
taking hints from yours and came up with one that worked. I am not that
great with INNER JOIN's and couldn't get yours to work, even though you did
still say that I needed to tweek it. It would be nice to know the query
that would work with an INNER JOIN
you are
seeking for, I can help with PHP.
Saul
Kandy Wong wrote:
Hi,
I need to write a C++ program in a Linux environment to query with a
timestamp.
The user will only provide with an approximate time so I'd like to know
how can I write a program or a query to return the closest data
Hi Kandy,
this could be the query you are looking for. It should return record
with the closest timestamp to your required time:
(SELECT TIMEDIFF('20080815091907', timestamp_column) AS diff, t.* FROM
table1 t
WHERE timestamp_column = '20080815091907'
ORDER BY timestamp_column DESC LIMIT 1
)
Kandy Wong wrote:
Hi Saul,
I need to use C++ and I'm not writing a web application.
Thanks anyway.
you can do something like:
select min(abs(timediff(targettime,timestamp))) from table where
condition ;
if you use the libmysql you can get the result as strings back (the method i
Kandy Wong wrote:
And what is the good connector (C++ to MySQL) to use?
MySQL++ (http://tangentsoft.net/mysql++/) has native Date, Time, and
DateTime data types. You can convert to these types implicitly:
mysqlpp::DateTime dt = row[my_column];
Row::operator[] doesn't return
PROTECTED]
Sent: Friday, August 15, 2008 2:36 AM
To: Saul Bejarano
Cc: mysql@lists.mysql.com
Subject: Re: Need help to query with timestamp in C++
Hi Saul,
I need to use C++ and I'm not writing a web application.
Thanks anyway.
Kandy
I have done queries to the database in PHP with variables like month
Hi Dusan,
Thank you so much. It works!
Kandy
Hi Kandy,
this could be the query you are looking for. It should return record
with the closest timestamp to your required time:
(SELECT TIMEDIFF('20080815091907', timestamp_column) AS diff, t.* FROM
table1 t
WHERE timestamp_column =
Hi,
I need to write a C++ program in a Linux environment to query with a
timestamp.
The user will only provide with an approximate time so I'd like to know
how can I write a program or a query to return the closest data.
The followings are the timestamp in the MySQL database:
| 2008-08-05
I have done queries to the database in PHP with variables like month but
easily can select from a range of time and data to produce the same
results, the output goes directly to the web so if that is what you are
seeking for, I can help with PHP.
Saul
Kandy Wong wrote:
Hi,
I need to write
I want to remove all records from 'feed_tag' where the feed_id foreign key
doesn't have any corresponding records in feed.
For instance I may have a record in feed_tag that is like (23, 10, 4543,
'... (some date)').
Then lets say there is no record in feed that has a primary id key of 10.
I
Hi Daevid
If you are using a foreign key you can set the reference as cascade
and when a row is deleted from feed it will be deleted from feed_tag.
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
If you don't like it you can delete it easy with a query like this
Just do a left join with the delete query.
DELETE feed_tag FROM feed_tag LEFT JOIN feed ON
feed_tag.feed_id=feed.id WHERE feed.id IS NULL
That should do it. You can change DELETE feed_tag to SELECT and
test it first.
--
Brent Baisley
On Aug 13, 2008, at 4:51 PM, Daevid Vincent wrote:
First, you might want to move the WHERE...t3.int_a = some integer
condition into the join condition for t3.
Your not using anything from t4, so I'm not sure why you have that
table in your query.
You can suggest or force mysql to use an index if it's using the wrong
one:
I have this query:
SELECT DISTINCT t1.string FROM t1
LEFT JOIN t2 ON t1.string=t2.string
LEFT JOIN t3 ON t1.int_a=t3.int_a
LEFT JOIN t4 ON t1.int_b=t4.int_b
WHERE
t1.string != '' AND
t2.string IS NULL AND
t3.int_a = some integer
ORDER BY
Not sure how someone can intelligently comment on your table structure
when you haven't given any details of the data you are storing. In my
experience, the fact that you have 75 fields in your table is a strong
indicator that your data is not normalized. If that is the case you
tables are
Subject: Re: Help with Table structure
Not sure how someone can intelligently comment on your table structure
when you haven't given any details of the data you are storing. In my
experience, the fact that you have 75 fields in your table is a strong
indicator that your data is not normalized
'./naxbmisq02-relay-bin.000157' not found
(Errcode: 2)
mysql
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote
The background:
We are doing replication. The file-system containing the SLAVE's
relay-log got filled to capacity. Later on, I noticed replication has
not been working for the last month or more.
My Action:
I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now,
the SLAVE will not
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make up.
You can tell mysql to not keep relay logs that
Hi,
I have a table containing 75 fields with a primary index and index set on 5
other fields. Everything is working fine so far as the table contains only
about 80,000 records. I expect these records to reach 500,000 by end of
september.
I would like to know:
- if the number of records will
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote:
you should probably just resync your slave. If it hasn't run for over a
month then there's not a lot of point in trying to start it up. Even if
you
did start the slave (which seems doubtful) you'd have over a month's worth
of commands to make
Re: You can tell mysql to not keep relay logs that have already been
used.
What command does this
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On 8/10/08, Jim Lyons [EMAIL PROTECTED] wrote:
you should probably just resync your slave. If it hasn't run for over
a
month then there's not a lot of point in trying to start it up. Even
Hi!
Mark == Mark Callaghan [EMAIL PROTECTED] writes:
Mark Can MySQL share the results of performance testing that has been done to
Mark compare 5.1 with 5.0?
I would really like to see them too :)
I will ask around and see if I can find what was done and what the
results where.
Regards,
Hi,
Michael Widenius schrieb:
Note that you should also do this for bugs that you know of in MySQL
5.0 that are still open for MySQL 5.1 (or any bugs that are labelled
to be fixed in a future release). Bugs that are in earlier version
are also very likely to also be in 5.1 if the bugs database
I want to make sure that my master and slave machines are in sync. From
what I hear, mk-table-checksum is a good way to do that. So, I downloaded
and installed it on my Linux box (the slave). So, here's what I've got:
WS2003 Master (IP 192.168.1.10)
Ubuntu 8.04 Linux Slave (IP
Hi!
This is a request to all MySQL users to help mysql developers, by
providing information, so that we can help you, by providing a more
stable MySQL server for your needs.
As you may know, MySQL 5.1 has been in state of release candidate (RC)
for some time. The last RC was announced
Can MySQL share the results of performance testing that has been done to
compare 5.1 with 5.0?
On Wed, Jul 16, 2008 at 3:13 PM, Michael Widenius [EMAIL PROTECTED] wrote:
Hi!
This is a request to all MySQL users to help mysql developers, by
providing information, so that we can help you
(sending again without html encoding)
Can MySQL share the results of performance testing that has been done
to compare 5.1 with 5.0?
On Wed, Jul 16, 2008 at 3:13 PM, Michael Widenius [EMAIL PROTECTED] wrote:
Hi!
This is a request to all MySQL users to help mysql developers, by
providing
This question is strictly related to the mysql query not the php code.
I need to either create a new table from the old one or add columns.
The thing is don't know how to do it.
let me simplify things up:
I need a query to retrieve values from the table
PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS to a
you can do some thing like this.
create table new_table(id int, hair varchar(50),eyes varchar(50)) select
column1,column2,...from old_table;
On 7/3/08, axis [EMAIL PROTECTED] wrote:
This question is strictly related to the mysql query not the php code.
I need to either create a new table
Hi,
I want to create a new column or table from queries of the values of
columns I( already have.
My table is :
PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS
products_id products_extra_fields_id products_extra_fields_value
1
1
How large is your total memory?
There parameter seems too large.
On Sun, Feb 10, 2008 at 5:42 PM, VeeJay [EMAIL PROTECTED] wrote:
Hello
I am running a Freebsd server:
1. Software:
Apache 1.3
mysql 5.0.27
php 4.4
2. Hardware:
2 intel procerssors
4 gb ram
RAID 10 with hard drives 15K
How large is your total memory?
There parameters' value seem too large.
On Mon, Jun 16, 2008 at 4:49 PM, Moon's Father [EMAIL PROTECTED]
wrote:
How large is your total memory?
There parameter seems too large.
On Sun, Feb 10, 2008 at 5:42 PM, VeeJay [EMAIL PROTECTED] wrote:
Hello
I am
trying reducing session related parameters like
sort_buffer_size,read_buffer_size , read_rnd_buffer_size to 1MB
On 6/16/08, Moon's Father [EMAIL PROTECTED] wrote:
How large is your total memory?
There parameters' value seem too large.
On Mon, Jun 16, 2008 at 4:49 PM, Moon's Father [EMAIL
, 2008 11:43 PM
Subject: RE: Help needed
Your best bet would be to use a UUID:
SELECT UUID();
+--+
| uuid() |
+--+
| c712dc72-718d-102b-b3c8-97395a1766b9
: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original Message-
From: Velen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 13, 2008 11:28 AM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Help needed
Hi Jerry,
Thanks for the tip.
What is UUID
- Original Message -
From: Arthur Fuller
To: Velen
Sent: Saturday, May 10, 2008 10:44 PM
Subject: Re: Help needed
On my main machine the PCID is 135184-45-4-10-1513-1.
Hope it helps.
Arthur
On Sat, May 10, 2008 at 12:59 PM, Velen [EMAIL PROTECTED] wrote:
Hi
PROTECTED]
Sent: Monday, May 12, 2008 8:32 AM
To: Arthur Fuller
Cc: mysql@lists.mysql.com
Subject: Re: Help needed
Hi Arthur,
Could you please tell this guy that it was not a virus and you tested it
without any problem?
Thanks.
Velen
On Sat, 2008-05-10 at 20:59 +0400, Velen wrote:
Hi,
I'm
On May 9, 2008, at 6:58 AM, Chris Pirazzi wrote:
Hello,
I _thought_ I knew how InnoDB worked, but due to a recent mysql doc
change, I am no longer sure--the change made the dox significantly
less clear, and potentially code-breaking.
Please can someone tell me the real behavior of InnoDB in
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 12, 2008 11:59 AM
To: mysql@lists.mysql.com
Subject: RE: Help needed
Sorry, you can't prove uniqueness by running it against a hundred
thousand, million, or even a billion computers. (The billionth-and-first
computer could be the one with the non-unique
I tested the program before running it and it is virus-clean. I ran it
through AVG first and it's clean. I ran it in Windows. I don't know whether
there is a Linux version.
Arthur
On Mon, May 12, 2008 at 11:31 AM, Velen [EMAIL PROTECTED] wrote:
Hi Arthur,
Could you please tell this guy that
On Mon, May 12, 2008 at 8:31 AM, Velen [EMAIL PROTECTED] wrote:
Hi Arthur,
Could you please tell this guy that it was not a virus and you tested it
without any problem?
One guy that is brave/crazy/stupid enough to run a binary on his machine
that didn't have anything bad happen to him does
On Sat, 2008-05-10 at 20:59 +0400, Velen wrote:
Hi,
I'm testing a program and I need you assistance.
Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program.
Please supply a Linux version of your virus so I can test.
--
Daniel Kasak
IT Developer
NUS Consulting Group
as possible.
The program i'm testing is supposed to create a unique ID for each PC, this is
why I need to test if it is really unique.
This file is virus free and cannot do any harm to your PC. It is however a
voluntary testing.
Thanks for your help in advance.
Velen
Hello,
I _thought_ I knew how InnoDB worked, but due to a recent mysql doc
change, I am no longer sure--the change made the dox significantly
less clear, and potentially code-breaking.
Please can someone tell me the real behavior of InnoDB in the
following case, and ideally clarify the dox
Hi all,
You can read this article, written by a SUN benchmarking guru (hi
Dimitri :) ).
Best regards.
Web link : http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
)
left JOIN sf_threads ON sf_forums.id = sf_threads.forumidfk)
left JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk
GROUP BY
sf_conferences.id,
sf_conferences.name
--
View this message in context:
http://www.nabble.com/select-count%28%29.-Help-a-newb-tp16582786p16582786.html
Sent from
innodb_file_per_tables is so much slower than
running innodb with a single table space?
Thanks in advance for any help,
Nico
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi I think you would do this :
SELECT
sf_conferences.id,
sf_conferences.name,
count(*) AS `count`
FROM
((
LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
LEFT sf_threads ON sf_forums.id = sf_threads.forumidfk)
LEFT JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk
.-Help-a-newb-tp16582786p16590541.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi [EMAIL PROTECTED] wrote:
The problem I have is that importing the same 7 MB sql dump
takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
Is autocommit turned off?
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
When importing
Il Wednesday 09 April 2008 19:40:32 Rob Wultsch ha scritto:
On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi [EMAIL PROTECTED] wrote:
The problem I have is that importing the same 7 MB sql dump
takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
Is autocommit turned off?
Hello,
I've got a table which containes two date colomns.
The first one is called `date` and the second `update`
In the first one I put the ticket creation date, and on update I add or
change the update value.
So the update colomn does not contain a value until the first update has
been done.
I
mysql version?
http://dev.mysql.com/doc/refman/5.0/en/case-statement.html
order by case when updated is not null then updated else created end desc;
/Kristian
On Tue, Apr 8, 2008 at 1:04 PM, Richard [EMAIL PROTECTED] wrote:
Hello,
I've got a table which containes two date colomns.
The
Hello I've tried the following with mysql 4.1.11
SELECT * FROM quick_contact WHERE (`status` = '0') OR (`status` = '2'
AND `update` '.(time()-864000).') CASE WHEN `update` = '' THEN ORDER
BY `date` DESC ELSE ORDER BY `update` DESC END CASE;
It does not work but, is it my code that is wrong
Can't you do Something like:
ORDER BY (update,date)
The major column of ordering would be update and the second date.
I'm not sure about this solution
On Tue, Apr 8, 2008 at 8:54 AM, Richard [EMAIL PROTECTED] wrote:
Hello I've tried the following with mysql 4.1.11
SELECT * FROM
Thanks,
I think that your solution will be sufficient for my needs, however I
would still like to know for my personal knowledge how to manage
correctly this kind of need.
And to make it more complicated I've just rearlised that there is
another element to take into account, I would need to
A modification to my last email, try:
SELECT
*, IF(update != '', update + 10, date) AS o
FROM
my_table
ORDER BY o DESC;
+-+--++--+
| num | date | update | o|
+-+--++--+
| 5 | 40 | 90 | 100 |
| 2 | 10 | 60 | 70 |
| 6 | 50 |
I think the easiest is to create a new logical column with the correct
ordering, something like:
SELECT *, IF(update != '', update, date) AS o
FROM my_table ORDER BY o DESC;
I note that both 'update' and 'date' are reserved works :)
Also worth noting that this cannot be assigned an index
Thanks, it works like a charm :)
Ben Clewett a écrit :
A modification to my last email, try:
SELECT
*, IF(update != '', update + 10, date) AS o
FROM
my_table
ORDER BY o DESC;
+-+--++--+
| num | date | update | o|
+-+--++--+
| 5 | 40 | 90
701 - 800 of 7035 matches
Mail list logo