Hi all,
is there a WITH TIES function to use with the LIMIT keyword?
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au/ http://www.pacificfox.com.au an
industry leader with commercial IT experience since 1994 .
*
Taco Fleur wrote:
Hi all,
is there a WITH TIES function to use with the LIMIT keyword?
What does that WITH TIES function should do?
Greets
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives:
Sorry, should have included it
WITH TIES
Specifies that additional rows be returned from the base result set with the
same value in the ORDER BY columns appearing as the last of the TOP n
(PERCENT) rows. TOP ...WITH TIES can only be specified if an ORDER BY clause
is specified.
Kind regards,
Taco Fleur wrote:
Sorry, should have included it
WITH TIES
Specifies that additional rows be returned from the base result set
with the
same value in the ORDER BY columns appearing as the last of the TOP n
(PERCENT) rows. TOP ...WITH TIES can only be specified if an ORDER BY
clause
is
1. Please always reply to the List.
Who runs this list? Could it please be configured to send replies back to
the list rather than the individual? It's really annoying to keep ending up
with a personal address - it would make things so much easier, and is, to my
knowledge, standard practice for
I don't see how that would work?
I could do a join on the total sales price once I have the top 5, but I was
hoping there was something as easy as WITH TIES.
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au an industry leader
Jason Teagle wrote:
1. Please always reply to the List.
Who runs this list? Could it please be configured to send replies back to
the list rather than the individual? It's really annoying to keep ending up
with a personal address - it would make things so much easier, and is, to my
knowledge,
Barry wrote:
Jason Teagle wrote:
1. Please always reply to the List.
Who runs this list? Could it please be configured to send replies
back to
the list rather than the individual? It's really annoying to keep
ending up
with a personal address - it would make things so much easier, and
[snip]
1. Please always reply to the List.
Who runs this list? Could it please be configured to send replies back
to
the list rather than the individual? It's really annoying to keep ending
up
with a personal address - it would make things so much easier, and is,
to my
knowledge, standard
Yes this battle has been fought before. But this is still a pain in the
ass.
Whilst the list is unmoderated, surely someone at MySQL has the capacity to
make a change to the server configuration of whatever hosts the list?
How many times has someone had their problem solved by someone who
[snip]
Yes this battle has been fought before. But this is still a pain in the
ass.
[/snip]
Once you get in the habit your ass will hurt a little less. I know that
there are mysql-ites who 'monitor' the list, maybe they can ease your
pain.
[snip]
How many times has someone had their problem
The battle has been fought before - and the list administrator has given
his reasons why he has not made the requested change. The way the list
currently behaves is not an accident or omission, but a deliberate
decision. I do not recall the grounds for that decision - maybe RFCs or
the
The battle has been fought before - and the list administrator has given
his reasons why he has not made the requested change. The way the list
currently behaves is not an accident or omission, but a deliberate
decision. I do not recall the grounds for that decision - maybe RFCs or
the
On 4/18/06, Jason Teagle wrote:
1. Please always reply to the List.
Who runs this list? Could it please be configured to send replies back to
the list rather than the individual?
Please read the faq before rehashing issues that have been beaten to death.
Jochem
It is rather a shame if the method of reply is all that it takes to turn
you off the list. Personally the content of the list is far more
important to me.
There are forums if you want a web interface.
Having been through this argument on another list recently, I can say
there is no pleasing all
- Original Message -
From: mysql [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, April 18, 2006 7:55 AM
Subject: My Left Joins are Doubling the SUM()
My Left Joins are Doubling the SUM()
SELECT packageItemID, packageItemName,packageItemPrice
,SUM(packageItemTaxAmount) as
[snip]
However, if the subject has been addressed and the decision made, then
there's just no point in this topic. I guess those of us that don't like
it,
or don't like people inadvertently posting personal replies thanks to
that
decision, should simply find another list.
[/snip]
Either that or
[EMAIL PROTECTED] wrote:
The battle has been fought before - and the list administrator has given
his reasons why he has not made the requested change. The way the list
currently behaves is not an accident or omission, but a deliberate
decision. I do not recall the grounds for that decision -
Ok,
As expected, multiple flames were sent in my direction for suggesting that
this list should behave in the way that a logical person would expect it to.
I accept that this was probably done for a reason, and that other lists work
this way (though I've never seen one), so maybe I'd feel better
[snip]
I accept that this was probably done for a reason, and that other lists
work
this way (though I've never seen one), so maybe I'd feel better if
someone
could actually tell me a reason why it is better this way?
[/snip]
Here is the answer;
http://www.unicom.com/pw/reply-to-harmful.html
It's in the list FAQ http://lists.mysql.com/faq.php.
http://lists.mysql.com/faq.php#subjectprefix
This answer lists popular e-mail clients and is only _slightly_
biassed :-D
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
MS SQL Server
Upscene
mysql,
My Left Joins are Doubling the SUM()
SELECT packageItemID, packageItemName,packageItemPrice
,SUM(packageItemTaxAmount) as packageItemTaxAmount
,SUM(packageCreditAmount) as packageCreditAmount
FROM packageItem
LEFT JOIN packageCredit ON packageItemID=packageCreditItemID
LEFT JOIN
Hello
I'm new bie user of mysql, I need to create a database and import
some frm .myd .myi files
to that database , also if you can point me to some easy to start
tutorial for how to create user account in mysql , create a database ,
etc
Thanks for replying
Hicham
--
MySQL General
hicham wrote:
Hello
I'm new bie user of mysql, I need to create a database and import
some frm .myd .myi files
to that database , also if you can point me to some easy to start
tutorial for how to create user account in mysql , create a database ,
etc
Thanks for replying
Hicham
hicham schrieb:
Hello
I'm new bie user of mysql, I need to create a database and import
some frm .myd .myi files
to that database , also if you can point me to some easy to start
tutorial for how to create user account in mysql , create a database ,
etc
Thanks for replying
Hicham
mysql,
Add a grouping clause to that query, ie
SELECT
packageItemID,
SUM(packageItemPrice),
( SELECT SUM(c.packageCreditAmount)
FROM packageCredit c
WHERE c.packageCreditItemID = packageItemID
) AS CreditSum,
( SELECT SUM(t.packageItemTaxAmount)
FROM packageItemTax t
WHERE
On 4/18/06, Dominik Klein [EMAIL PROTECTED] wrote:
hicham schrieb:
Hello
I'm new bie user of mysql, I need to create a database and import
some frm .myd .myi files
to that database , also if you can point me to some easy to start
tutorial for how to create user account in mysql ,
Hey all,
I've checked the archives and found an explanation as to how the check
if a record is not in a many-to-many table. The answer to that is
somewhat simple and clear to me. But here's my problem: how do you
check if a record doesn't have a *particular* many-to-many
relationship? As
Marco,
I've checked the archives and found an explanation as to how the check
if a record is not in a many-to-many table. The answer to that is
somewhat simple and clear to me. But here's my problem: how do you
check if a record doesn't have a *particular* many-to-many
relationship? As in,
Hi,
I am a newbie. I need to change the datadir after the rpm installation
How to do it?
Thanks,
-
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2¢/min or less.
- Original Message -
From: tuxlinsecure [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, April 18, 2006 11:41 AM
Subject: Change datadir in rpm installation
Hi,
I am a newbie. I need to change the datadir after the rpm installation
How to do it?
Thanks,
in your my.cnf
I've checked the archives and found an explanation as to how the
check if a record is not in a many-to-many table. The answer to that
is somewhat simple and clear to me. But here's my problem: how do
you check if a record doesn't have a *particular* many-to-many
relationship? As in,
For an rpm Installation , the server-related my.cnf is saved at what lcoation ?
and is it ok that I copy /usr/share/mysql/my-large.cnf as /etc/my.cnf
and edit datadir only
Thanks,
Mike Blezien [EMAIL PROTECTED] wrote:
- Original Message -
From: tuxlinsecure
To:
Sent: Tuesday,
gerald_clark wrote:
I've checked the archives and found an explanation as to how the
check if a record is not in a many-to-many table. The answer to
that is somewhat simple and clear to me. But here's my problem: how
do you check if a record doesn't have a *particular* many-to-many
I get the current date with
SELECT CURDATE()
How can I get the first and the last day of the month?
[snip]
How can I get the first and the last day of the month?
[/snip]
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
last_day() for last day of the month. The first day is always the first.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Greetings.
I have Text fields in some tables which contain text in Portuguese with
accent characters like á, à, é, í, ú, ü, ó, ö, ç, etc.
When I query like:
SELECT text_column
FROM table
WHERE text_column LIKE %maçã%
[ or ]
WHERE text_column LIKE %ç%ã%
it also returns 'maca', 'maça',
2006/4/18, Pedro mpa [EMAIL PROTECTED]:
Greetings.
I have Text fields in some tables which contain text in Portuguese with
accent characters like á, à, é, í, ú, ü, ó, ö, ç, etc.
When I query like:
SELECT text_column
FROM table
WHERE text_column LIKE '%maçã%'
[ or ]
WHERE text_column
Hi,
I uninstalled Mysql 3.23 (tar.gz )and installed Mysql 5.0 (rpm) on my server.
When I check shared lib dependencies using the following command i get
undefined symbol
Any Clues?
Thanks,
ldd -r /usr/share/Fazzt/lib/libScriptMySQL.so.0.0.15
libKCScriptData.so.0 =
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What has happended to all the bk repo's? The documentation says there
there but they are not. For example.
http://dev.mysql.com/doc/administrator/en/mysql-gui-install-source-download.html
On Tue, Apr 18, 2006 at 06:19:53PM -0600, Boyd Lynn Gerber wrote:
What has happended to all the bk repo's? The documentation says there
there but they are not. For example.
http://dev.mysql.com/doc/administrator/en/mysql-gui-install-source-download.html
Hi all,
I am considering moving some archival records which largely consist of blobs
(PDF Image files) out of an Oracle DB and onto MySQL. Has anyone done this
(not necessarily the Oracle part) who can relate their experience(s)? I can
go with MyISAM or archive storage engine, from the looks
Tim,
I did this for a large collection of images, ~1million images up
around 40 gigs total last time I checked (no longer involved in the
project). It worked very well, performance was not horrible compared
to file-based storage. I always feared that MyISAM table getting
corrupted and
Seems like what you need is an auto-increment key. Is that out of the
question?
On Apr 18, 2006, at 1:34 AM, abhishek jain wrote:
Dear Friends,
I run several processes and they need to query the mysql 5.0.8
database
simultaneously .I have a config table which have the record id. I
need to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What has happended to all the bk repo's? The documentation says
there
there but they are not. For example.
http://dev.mysql.com/doc/administrator/en/mysql-gui-install-source-download.html
Hi,
I'm trying to make an backup of a database and this is what I got:
[EMAIL PROTECTED] mysql]# mysqldump -uroot -px OSCOMM test.sql
mysqldump: Can't get CREATE TABLE for table `orders_pay_methods` (Can't
open file: 'orders_pay_methods.InnoDB'. (errno: 1))
What's a problem?
Note: OSCOM
Tim Lucia wrote:
Hi all,
I am considering moving some archival records which largely consist of blobs
(PDF Image files) out of an Oracle DB and onto MySQL. Has anyone done this
(not necessarily the Oracle part) who can relate their experience(s)? I can
go with MyISAM or archive storage
47 matches
Mail list logo