Thanks both Devanada and Peter, your replies helped me resolve it.
/Jon
On 7/30/06, Peter Brawley [EMAIL PROTECTED] wrote:
*I'm trying to make stored procedures use parameters for limit and
tables, I
guess this is either me using the wrong datatype or it's not possible.
I'm
having the same
- Original Message
From: Greg 'groggy' Lehey
To: Abdullah Ibn Hamad Al-Marri
Cc: Jim Winstead ; mysql@lists.mysql.com
Sent: Monday, July 31, 2006 5:54:31 AM
Subject: Re: Why release 5.0.23 instead of 5.0.24?
On Saturday, 29 July 2006 at 9:53:29 -0700, Abdullah Ibn Hamad
I found a parameter called TimeBetweenWatchDogCheck for a MySql Cluster.
Could you give an example for not clustered MySql servers?
Info: Our application is not a webbased one.
Regards,
André
-Ursprüngliche Nachricht-
Von: Dan Nelson [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 28. Juli
I want to do a program to display birthday for our staff. I have a
field named birthday with date format (-mm-dd), from this field I
want to display the staff who will have their birthday start from
current date to 7 days a head.
please help, thanks in advance
--
MySQL General Mailing List
Hi,
Try here
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/*
What version of MySQL do you have? Depending on that, there are different
methods.
-Original Message-
From: Penduga Arus [mailto:[EMAIL PROTECTED]
Sent: Monday, July 31, 2006 6:33 PM
To: mysql@lists.mysql.com
Subject: select between date
I want to do a program to display birthday for
Hello,
I have two servers: one is oracle database and another
one is mysql database. We developed two web
application using cold fusion running on each one
Server 1: oracle database with cold fusion application
server 2: mysql database with cold fusion application
My question is if we decide
In the last episode (Jul 31), André Ress said:
I found a parameter called TimeBetweenWatchDogCheck for a MySql
Cluster. Could you give an example for not clustered MySql servers?
Info: Our application is not a webbased one.
That parameter has a different purpose; it looks like it's there to
On Monday 31 July 2006 06:26 am, Phong Nguyen wrote:
My question is if we decide to switch server 1 to
server 2 (oracle database to mysql) or server 2 to
server1 (mysql to oracle). Then, what happen to
sqlplus (oracle) and sql (mysql) using with
application. You can say what are # between
On Mon, 31 Jul 2006 06:26:01 -0700 (PDT)
Phong Nguyen [EMAIL PROTECTED] wrote:
My question is if we decide to switch server 1 to
server 2 (oracle database to mysql) or server 2 to
server1 (mysql to oracle). Then, what happen to
sqlplus (oracle) and sql (mysql) using with
application. You can
Is there an efficient way to find the closest numerical value, across
three columns? I do not know if there is a way to find it across one.
I thought about plotting the values in a geometric space, but that would
seem to require more dimensions that the server can handle. I thought
about
Is there an efficient way to find the closest numerical value,
across
three columns? I do not know if there is a way to find it across
one.
Not sure about efficiency, but if the criterion number is @n, do you
mean ...
SELECT LEAST( ABS(MIN(@n-col1)),
LEAST( ABS(MIN(@n-col2)),
My MySQL server (4.0.20, Linux) was running slowly. I checked the slow queries
log, and found many of these during the problem period:
# Time: 060730 20:44:40
# [EMAIL PROTECTED]: xxx []
# Query_time: 68 Lock_time: 0 Rows_sent: 0 Rows_examined: 2
# administrator command: Quit;
# [EMAIL
Hello,
I'm looking to replace and aging an aging database
server and was wondering if anyone has any advice
about AMD Opteron dual/quad core processors and MySQL
on a 64 bit box. We're currently running MySQL 5.0.15
and we'd like to stay with that release. Are there any
problems with running
On Monday 31 July 2006 03:18 pm, Tripp Bishop wrote:
Hello,
I'm looking to replace and aging an aging database
server and was wondering if anyone has any advice
about AMD Opteron dual/quad core processors and MySQL
on a 64 bit box. We're currently running MySQL 5.0.15
and we'd like to stay
1. Get as much memory as possible.
2. Get the fastest disks you can. Ones with fast access time and 10 or
15K RPMs are best.
3. I think SCSI has a slight advantage over SATA but they are more
expensive also. So only get them if it doesn't have a negative effect on
1 or 2.
4. Use whatever $$$
A while back, someone asked if a stored procedure could take a
parameter that can be used within a statement as a value for LIMIT.
I have a solution using Prepared Statements and placeholders. Prepared
Statements with placeholders are available from 5.0.7.
Anyway, here goes using the standard
hi all...
how can i do a query on a list of ids without doing individual queries
for each one of them?
something like:
select id,title from content where id = 100,106,109;
of course this doesn't work... is it possible somehow?
thanks
--
MySQL General Mailing List
For list
kalin mintchev wrote:
hi all...
how can i do a query on a list of ids without doing individual queries
for each one of them?
something like:
select id,title from content where id = 100,106,109;
select id,title from content where id IN(10,20,30);
--
MySQL General Mailing List
For list
If you know the list of Ids, try
select id, title from content where id in (100, 106, 109);
If you want the list to be random, then you can use the RAND() function.
Quentin
-Original Message-
From: kalin mintchev [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 1 August 2006 2:10 p.m.
To:
TK wrote:
My MySQL server (4.0.20, Linux) was running slowly. I checked the slow queries
log, and found many of these during the problem period:
# Time: 060730 20:44:40
# [EMAIL PROTECTED]: xxx []
# Query_time: 68 Lock_time: 0 Rows_sent: 0 Rows_examined: 2
# administrator command: Quit;
#
Penduga Arus wrote:
On 7/31/06, Peter Lauri [EMAIL PROTECTED] wrote:
What version of MySQL do you have? Depending on that, there are different
methods.
MySQL 5, can you please show me how to do it..
Did you look at the link David sent you?
You could also use OR
select id, title from content where id = 100 or id =106;
Brian
From: Quentin Bennett [EMAIL PROTECTED]
To: [EMAIL PROTECTED],mysql@lists.mysql.com
Subject: RE: select random ids from list
Date: Tue, 1 Aug 2006 14:59:14 +1200
If you know the list of Ids, try
select
I use Toad for MySQL 2.0 and SQLyog 5.02.
I want to insert unicode myanmar characters.
I change uft8 charset and utf8_unicode_ci collation.
But I can't insert myanmar characters.
What is needed to do?
Please tell me.
Thanks
--
MySQL General Mailing List
For list archives:
Hello all,
Just wanted to know if using IN in the where clause is better than OR in terms
of performance.
that is :
Are these both same in terms of performance
SELECT * FROM TABLE
WHERE ( COLUMN = 1 OR COLUMN = 2 );
SELECT * FROM TABLE
WHERE COLUMN IN ( 1, 2 );
thanks,
Ratheesh
select id,title from content where id IN(10,20,30);
cool thanks.. what if i want it to be random ordering like:
select id,title from content where id IN(20,10,30);
and i would like the order of the ids and the in() to be kept in the
result array. what 'order by' would i use?!
--
MySQL
kalin mintchev wrote:
select id,title from content where id IN(10,20,30);
cool thanks.. what if i want it to be random ordering like:
select id,title from content where id IN(20,10,30);
and i would like the order of the ids and the in() to be kept in the
result array. what 'order by' would
Ratheesh K J wrote:
Hello all,
Just wanted to know if using IN in the where clause is better than OR in terms
of performance.
that is :
Are these both same in terms of performance
SELECT * FROM TABLE
WHERE ( COLUMN = 1 OR COLUMN = 2 );
SELECT * FROM TABLE
WHERE COLUMN IN ( 1, 2 );
28 matches
Mail list logo
