Re: subselect logic

"Within-group aggregates" at http://www.artfulsoftware.com/queries.php. PB - Kip Turk wrote: I'm having problems optimizing a series of subselects. I have the following sample table: mysql> select * from fake order by msgid, id desc; ++---+-+---

subselect logic

point even explain took a few minutes to respond). What can I do to optimize this query? Thanks, Kip Turk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: I'm new in Mysql

rchar( 40 ) null, > url varchar( 40 ) null, > comments text null, > ) > ; The last line of your table creation "comments text null," does NOT need a comma. Drop that and you should be fine. -- Kip Turk, RHCE [EMAIL PROTECTED] Systems Admi

Re: Difficult query

; The table is stored on a 3.23.43 mySQL Server. The table type is varchar(15) > but this can be changed. Possibly not the most optimized solution, but it functions as requested. select distinct(concat(substring_index(field, '.', 3), '.0')) as network from table

RE: safe_mysqld crashing

l (2.4.18-3smp) and glibc (2.2.5-40) when it came up after the reboot. I intend to test the new glibc (ftp://people.redhat.com/jakub/glibc/errata/) at my next maintenance window and will post an update if anything further changes. - sql to bypass the filter - -- Kip Turk, RHCE

safe_mysqld crashing

erver id 1 Start: binlog v 1, server v 3.23.52-log created 021101 16:33:50 Google didn't produce any helpful tips and the list archives seem pretty quiet on this problem. Anyone have a clue? -- Kip Turk, RHCE [EMAIL PROTECTED] Systems Administra

Something we didn't learn in class (fwd)

running clean for quite a while, but seems to have taken a nosedive at midnight last night. The segfault seems to come at a test to see if a thread is hanging, though I can't see why it would fail. Nothing has changed from what I can see. Any tips? -- Kip Turk, RHCE

Re: Advice on Random Numbers

dule mod_unique_id. If you need a cryptographic > randomness you should look into some litterature about the area so as to get > a better understanding of what you truly need. Would an MD5 encryption be another option? Use a auto incrementing ID to keep your records sorted, then the MD5 fie

Disregard Ugly Output

x27;ll drag my noise back off the list now. MySQL was not the culprit. -- === Kip Turkphone: 915.234.5678 Systems Administrator or 800.695.9016 Killer of Spam/Writer of

Ugly output

my apologies for the ugly line wraps. It looks that bad in my pine session also. Thanks, -- === Kip Turkphone: 915.234.5678 Systems Administrator or 800.695.9016 Killer of Spam/Writer of Co

Re: if or statement possible?

On Fri, 18 May 2001, Kip Turk wrote: > > Is it possible to make this type of logical command in MySQL? > > if ((x == y) or (x == z)) { response1 } > else { response2 } > I'll go ahead and follow up my own post, as I found a solution, using regexp. Here's a te

if or statement possible?

the results externally? -- === Kip Turkphone: 915.234.5678 Systems Administrator or 800.695.9016 Killer of Spam/Writer of Code/Penguin Proponent West Central Net fax: 915.656.0

Re: how to escape french characters

t of french characters]/\\$1/g; -- ======= Kip Turkphone: 915.234.5678 Systems Administrator or 800.695.9016 Killer of Spam/Writer of Code/Penguin Proponent West Central Net fax: 9

Sorting and Optimization

x27;t remember enough of the details to find it in the archives. Thanks for any assistance you can offer. -- === Kip Turkphone: 915.234.5678 Systems Administrator or 800