Thanks a lot
On Mon, Apr 7, 2008 at 10:59 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Sun, Apr 6, 2008 at 9:57 PM, Eric Bergen [EMAIL PROTECTED]
wrote:
I don't see what the issue is. As Jay said the row counts in explain
outputs are estimates. When running an explain query MySQL asks the
Hi,
I have two instances of Mysql 5.0 on a server Scientific Linux CERN SLC release
4.6 (Beryllium)
and the instances work well, I turn on and turn off the instances by
mysqld_multi.
I would like to start automatically instances at the start of the server Linux.
I took the script
Am Dienstag, den 08.04.2008, 09:27 +0200 schrieb Stefano Elmopi:
This command is available from the latest MySQL distribution. Please
make sure you have the command in your PATH.
Set the $PATH variable in the init script, and make sure it contains the
path to the MySQL binaries.
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
Hi,
I have a question regarding mysql master-slave replication's
Relay_Master_Log_File. I hope someone can answer me.
I have mysql setup to purge old logs that arent being used by master, and
also the max log size is set as 500MB. I see that new logs are created with
next number in order.
What
On Tue, Apr 8, 2008 at 7:28 AM, Steven Macintyre
[EMAIL PROTECTED] wrote:
Hi all,
I have the following SQL statement;
SELECT count( salesID ) AS count, branch_name, company_name, branch.branchID
FROM sales
LEFT JOIN IGuser ON sales.IGuid = IGuser.IGuid
LEFT JOIN
Richard,
No problem, glad it works. But note: this is not scalable. If you have
more than a few hundred rows, you may want to think about a better
solution, like storing the order field permanetly and giving it an index :)
Ben
Richard wrote:
Thanks, it works like a charm :)
Ben Clewett
Thanks,
This is for the unanswered list of questions, so the output list (not
the list stored in the mysql database) should never go over 100.
by scalable, do you mean alot of ressources being used or a long wait
for the answer? Because I belive I Could just use a simple limit if I
needed
On Tue, Apr 8, 2008 at 7:44 AM, Chanchal James [EMAIL PROTECTED] wrote:
What could happen when this numbering reaches the limit, say,
mysql-bin.99. Will it break replication in anyway or will it just get
reset, and the slave starts to pick up replication from the new log(which
I
presume
On Tue, 8 Apr 2008, Richard [EMAIL PROTECTED] wrote:
Kristian Myllym?ki a ?crit :
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;
Hello I've tried the following with mysql 4.1.11
SELECT *
I searched for a few combination of words, and didnt reach anywhere. Thats
how I ended up posting here.
From this thread it looks like it never gets reset and keeps increasing the
numbering; I would still wish if it reset someday without affecting the
replication!
Thanks for the link, Rob.
On
Not sure, but perhaps an even simpler method would be to consider the
initial insert an update as well... so the update column would always have
a value. Then the sort would (I believe) always be in the order you want,
and if you need to differentiate between rows that are new vs rows that
are
Richard,
The query I gave you required the column 'o' to be calculated for each
row at the time of gathering the data. When all rows have been
gathered, the data will be stored and sorted in a temporary table. This
temporary table will be in memory or on disk depending on the setting of
Yes that would be easier, except that I would still have to create a
tempory table to add 10 days onto the ones which have a status waiting
for answer from customer and have not been answered for more than 10 days.
This system is for customers who do not have an account yet to contact
me. And
Hi All,
I am trying to figure out the best way to do database synchronisation. I have
my database at the head office and the application runs, partly at
remote/branch office. I am considering having a copy of the database there but
how can I have it synchronise in real time so that the
Hi:
I have successfully loaded an image into my database (I believe). When I go
to retrieve it, I get this...
array('c', '\xff\xd8\xff\xe0\\0...
How do I convert that into an image.
TIA,
Victor
Hi Paul,
You need to set up replication. Check
http://dev.mysql.com/doc/refman/5.0/en/replication.html
-Raj.
-Original Message-
From: Paul Ikanza [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 08, 2008 1:05 PM
To: 'mysql@lists.mysql.com'
Subject: Database Synchronisation Methods
Hi
The recent thread about merge tables led me to explore using them with
replication.
I see bug reports for the 4.0.** series regarding replication and merge
tables, and I've read the manual about merge table problems in the 5.0.**
series ( we are using 5.0.22 ), but I'm curious if anyone has
What is your column's type? Is it blob?
See this, might help:
http://www.phpriot.com/articles/images-in-mysql
On Tue, Apr 8, 2008 at 2:18 PM, Victor Subervi [EMAIL PROTECTED]
wrote:
Hi:
I have successfully loaded an image into my database (I believe). When I
go
to retrieve it, I get
hello,
im trying to make a DB for a message system.
the best way i have made is this:
*TABLE conversations* (informacion de cada conversacion)
.
i*d_conversation (bigint)
count(smallint) updated every time a new message is
27 matches
Mail list logo