Old news, but I felt I should write something about it.
First they start with Open Sourcing Java and Solaris calling it OpenJDK and OpenSolaris.
Then they say “It’s just a fucking kernel” because Linus Torvalds didnt release Linux in GPL 3 license.
And now they started to close MySQL features.
But hey guys no need to worry. IT’S JUST A FUCKING DBMS we can use PostgreSQL
Today I was searching for a ways to pass arrays to stored procedures in MySQL and came across this interesting link:
http://www.freepatentsonline.com/5978580.html
Kartik was online and he gave me this link which gives better explanation with PDF’s:
http://www.google.com/patents?id=boAYAAAAEBAJ&dq=5978580
So its clear that I wont be able to do that with PHP-MySQL as its not and may never be implemented because of the patent.
Has any body managed to simulate this functionality in MySQL?
Suppose you write a query to sort a table by date field.
SELECT aDate FROM aTable ORDER BY aDate
The above query should sort aDate column in ascending order. But it doesnt work the way it should.
To sort date field in MySQL use following query:
SELECT DATE_FORMAT(aDate, '%d-%M-%Y') AS aDate, aDate AS sDate FROM aTable ORDER BY sDate
