+Vote!
Top Questions - Stack Overflow (Free subscription) | 10 hours ago
SELECT ( SELECT SUM(IF(status = 'Active', 1, 0)) AS `univ_active`, SUM(IF(status = 'Inactive', 1, 0)) AS 'univ_inactive', Count(*) FROM online_university ) AS tot_university, ( SELECT SUM(IF(status = 'Active', 1,0)) AS `user_active`, SUM(IF(status = 'Inactive', 1,0)) AS 'user_inactive' Count(*) FROM online_register_user) AS tot_users Result must be univ_active=4 univ_inactive=2 tot_university=6 user_active=10...
+Vote!
MySQL Performance Blog (Free subscription) | yesterday
MySQL Performance Blog (and percona.com too) were down today because the switch in our rack died completely. It took a while to fix it using secondary switch we had. Provider was not willing to do it as remote hands so I had to drive to the data center to fix it. We got [...]
+Vote!
DIYMacServer (Free subscription) | 20/11/2009
MySQL released new versions of the 5.1.x and 5.0.x community versions of their database server. There is a security issue releated to them so if you are affected I would advise you to upgrade. I’ve upgraded all my servers without any issue following the normal upgrade path as documented. Read more about the specifics for each [...]
+Vote!
LWN.net (Free subscription) | 20/11/2009
MySQL Community Server 5.0.88 has been released. This release includes a security fix along with other bug fixes. " Security Fix: MySQL clients linked against OpenSSL did not check server certificates presented by a server linked against yaSSL. "
+Vote!
Cnet (Free subscription) | 20/11/2009
Microsoft is now offering support for MySQL, which should give pause to every open-source company that expects to make money through support subscriptions.
3Vote!
Open Source (Free subscription) | 20/11/2009
Mueller said the delay in Oracle's response means a decision on the merger won't come from the European Commission until January 27.
+Vote!
MySQL Performance Blog (Free subscription) | 20/11/2009
There is the rare bug which I ran into every so often. Last time I’ve seen it about 3 years ago on MySQL 4.1 and I hoped it is long fixed since… but it looks like it is not. I now get to see MySQL 5.4.2 in the funny state. When you see bug happening [...]
5Vote!
Silicon.com (Free subscription) | 19/11/2009
In an exclusive interview, former MySQL boss and silicon.com Agenda Setter, Marten Mickos talks to Tim Ferguson about the state of open source, Oracle's plans to buy Sun Microsystems and the value of working with people who are smarter than you. Marten Mickos is probably best known for his time as chief executive of open source database company MySQL, a position he held from 2001 until the beginning...
3Vote!
Database Journal (Free subscription) | 19/11/2009
Today's article continues to explore XML support in MySQL. Specifically, we'll look at a nicer way to format our resultset. We'll also discuss how to retrieve all of the records from the XML document, using a stored procedure.
3Vote!
Top Questions - Stack Overflow (Free subscription) | 18/11/2009
Hey guys, I have some code here that connects to my Mysql database. It checks your username and password and if your login was successful and it retrieves the phone number under that account. How would the SQL Query look like for retrieving the phone number once connected? Then how would I be able to display that phone number on a label? Thanks
3Vote!
DreamHost Status (Free subscription) | 17/11/2009
We’re currently experiencing some slow pings and packet loss to some of our MySQL servers in one of our server racks. We believe this is due to one of our links being saturated. Our networking team is working on adding more capacity to resolve these issues and hope to have things back to normal soon. [...]
3Vote!
CloudSync Developer's Blog (Free subscription) | 17/11/2009
We just learned that when you insert a UNIX_TIMESTAMP into MySQL that it will keep the UTC version of the timestamp, which is good. However, when you use FROM_UNIXTIME() to convert your Unix timestamp into a datetime string, it will localize the datetime to mysql’s timezone. So, a couple things here: System time and MySQL time are [...]
3Vote!
Edmonds Commerce Blog (Free subscription) | 17/11/2009
Just found this MySQL snippet for validating EAN numbers. http://snipplr.com/view.php?codeview&id=17928 I have modified it a bit to suit my requirements (namely totally corrupted EAN data). PLAIN TEXT SQL: SELECT ean FROM products WHERE (LENGTH(ean) != 13) || (SUBSTRING((10 - (((( SUBSTRING(ean FROM 2 FOR 1) + SUBSTRING(ean FROM 4 FOR 1) + SUBSTRING(ean FROM 6 FOR 1) + SUBSTRING(ean FROM 8 FOR...
3Vote!
Web Development & Stuff (Free subscription) | 16/11/2009
Quick reminder for myself of how to do a nested MySQL query with the nested statement in the parent where clause: 123456789$sql = <<<SQL SELECT id FROM invoices as Invoice WHERE id NOT IN ( SELECT parent_id FROM invoices WHERE parent_id > 0 ) AND billing_start <= '$end' SQL;
3Vote!
ratbagash (Free subscription) | 16/11/2009
Having just gone back to heavily using MAMP I was getting a little fed up with only being able to access the MySql database through phpMyAdmin so I figured I’d have a proper look at getting access through Navicat. I’d tried this hurriedly before – turns out it’s very simple. On your MAMP start screen you [...]
Videos