Conficker

Does anyone know if Conficker is suppose to affect MySQL? -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysq

Why do quotes in an IN() clause effect performance so drastically?

I'm really confused. First, I don't understand why quoting my IN() values here caused them to run significantly slower than the non-quoted versions... on just this simple contrived example it can be as much as 2.2 seconds vs. 0 seconds to return on a table that has 2.5M rows. The problem I'm facin

[OFFTOPIC] PHP and local-infile

Hi, sorry if this is an offtopic. I have a web site with LAMP, one module use a "LOAD DATA LOCAL INFILE" statement, all was running fine, but today I ran this module and I get an "The used command is not allowed with this MySQL version" message. If I use the same query from mysql command line I get

Re: how to check for null in string

Johan De Meersman wrote: > In SQL, the correct syntax is "IS NULL" or "IS NOT NULL". > > Random programming languages more often than not have no decent > support for > NULL content, although your DB library might have an isnull() function or > something similar. Once you've exported a field into a

Re: how to check for null in string

Hi ! Johan De Meersman wrote: > In SQL, the correct syntax is "IS NULL" or "IS NOT NULL". > > Random programming languages more often than not have no decent support for > NULL content, although your DB library might have an isnull() function or > something similar. Once you've exported a field

Re: how to check for null in string

In SQL, the correct syntax is "IS NULL" or "IS NOT NULL". Random programming languages more often than not have no decent support for NULL content, although your DB library might have an isnull() function or something similar. Once you've exported a field into a regular variable, however, most oft

Re: MySQL Community Server 5.0.77 has been released

Sorry, sorry, sorry. that was supposed to be a forward to a colleague :( Shame on me :( On Tue, Feb 17, 2009 at 10:25 AM, Walter Heck wrote: > Really? less then a week after we upgraded? Tough luck, haha :) > > Walter > > OlinData: Professional services for MySQL > Support * Consulting * Adminis

Re: MySQL Community Server 5.0.77 has been released

Really? less then a week after we upgraded? Tough luck, haha :) Walter OlinData: Professional services for MySQL Support * Consulting * Administration http://www.olindata.com On Tue, Feb 17, 2009 at 9:21 AM, Joerg Bruehe wrote: > Dear MySQL users, > > my sincere apologies for the noise - > th

MySQL Community Server 5.0.77 has been released

Dear MySQL users, my sincere apologies for the noise - this text is the final, official announcement; the word "DRAFT" in a previous mailing's subject line was an oversight of mine. Jörg Brühe = Dear MySQL users, MySQL Community Server 5.0.77, a new version of the popular Open Source Datab

DRAFT: MySQL Community Server 5.0.77 has been released

Dear MySQL users, MySQL Community Server 5.0.77, a new version of the popular Open Source Database Management System, has been released. The release is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror site