‘MySQL’ Archive

Upgrading MySQL to 5.6.10 on mac os and fixing mysql2 gem February 21, 2013 4 Comments

After updating MySQL to 5.6.10 in mac os with homebrew package manager you can notice that mysql2 gem will show such an error: “Incorrect MySQL client library version! This gem was compiled for 5.5.29 but the client library is 5.6.10” To fix it you can rebuild mysql2 with new mysql version config with the following […]

 

Row number in MySQL September 10, 2012 No Comments

I’ve faced recently with a problem to update positions of accounts ordered by some criteria right in MySQL database. I needed it for accounts rating so I will know in what rating position each account is placed on in the current time. And it reminded me ROW_NUMBER() in MS SQL Server which isn’t available unfortunately […]