taken from the manual 3.6.2 The Row Holding the Maximum of a Certain Column
which of the two queries will in general be faster:
1)
SELECT article, dealer, price
FROM shop
WHERE price=(SELECT MAX(price) FROM shop);
2)
SELECT article, dealer, price
FROM shop
ORDER BY price DESC
LIMIT 1;
or do
--
Best regards,
DebugasRumailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> At least this mailing list has progressed beyond "Why didn't they have
> a UPS?", I suppose. :-)
Yes that was my primary intend :)
I'd really like people to care more about their data safety and more
awareness about the problems involved.
>> That didn't get rid of the race condition, it just mov
>> Many data centers do not allow customers to install their own UPS
>> inside the rack.
The questions is not whether they have (wish to have, can afford etc ) UPS or
not,
or if the OS is buggy ( fsync() function or others ),
the problem is the database management system failed to ensure
data int
SH> MySql is getting bashed pretty hard in some cases as apparently, in power
SH> failures, you get database corruption.
One can do a simple test
start lengthy transaction and plug off the computer while the
transaction is still in progress.
Will your DBMS recover the errors after switching your c
Exactly:
m> If you distribute an application (outside of the GPL) that requires MySQL to run
m> then THE PERSON RECEIVING the application needs a commercial MySQL license.
Whether the person in question gets the license from you or someone else is not
your problem
--
MySQL General Mailing List
>> Sticking with the May example... I would like to be able to return
>> results for only students named May or Maya, but not Mayra, Jessica-May,
>> or Maylita.
SELECT * FROM students WHERE first_name LIKE 'May_'
_ in like means any single character
% in like means arbitrary number of characters
LF> What if I sell a web site built using mysql?
LF> Do I need a license on my web server?
The conclusion i have made is that from end-user point of view his
mySQL is running under multiple licencies simultaniously depending on
what 3rd parties software makes request to it. To be more precise at a
1)
LM> If your software is licensed under either the GPL-compatible Free Software
LM> License as defined by the Free Software Foundation or approved by OSI, then
LM> use our GPL licensed version.
2)
LM> If you distribute a proprietary application in any way, and you are not
LM> licensing and distr
>> as far as i know, there is only 1 way to extract the foreign key relations
>> from a table: "show create table ".
>> Are there any others?
MT> The "comments" column in SHOW TABLE STATUS is supposed
MT> to list the FKs as well.
since SQL89 standard lot of things got standartized but still the
PP> try:
PP> update tmpISM,ta
PP> set tmp.SUMA=tmp.SUMA-ta.SUMA
PP> where (tmp.PID=ta.PID) and (tmp.PAJ=ta.PAJ)
Does update work on more than one table ?
thank you for your input but i've just resolved the problem as follows
(i have had forgotten the EXISTS keyword for a moment):
update tmp
Hello i can't figure out how to update the table tmpISM based on other
table ta values. What i need i can intuitivly express as follows:
update tmpISM
set tmp.SUMA=tmp.SUMA-ta.SUMA
where (tmp.PID=ta.PID) and (tmp.PAJ=ta.PAJ)
index PID+PAJ is unique both for tmpISM and ta
Any suggestions how the u
since GPLed software can also be commercial i think
the subject of the thread should probably read
"using mysql in proprietary software." instead of "commercial"
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
Hello Aman,
Monday, July 26, 2004, 6:03:07 PM, you wrote:
>> Hello,
>>
>> I have a question related to nested sets:
>>
>> On my website a user should be able to create subusers and give them the
>> rights to add/change/delete subsites of the users website. If I remove one
>> or more rights to a
14 matches
Mail list logo
