MySQL

Featured on Fossfa.Net

Author: joe May 27, 2011 0 Comments

I got featured on the Fossfa.Net website. Please do not mind the English as I was interviewed by a German lady. Here is the link: http://www.ict-innovation.fossfa.net/blog/%5Buser-raw%5D/featuring-our-community-members-joe-murithi-njeru

Linux, MySQL, PHP, Web App Development

BLOG, FEATURED, FOSS, ICT@INNOVATION

“/usr/bin/ld: cannot find -lprobes_mysql”

Author: joe March 10, 2011 1 Comment

I got the following error when I was building my PHP 5.3.5 on MySQL 5.5 / HTTPD 2.2.17 / CentOS 5.5 64bit. checking for mysql_set_server_option in -lmysqlclient… no configure: error: wrong mysql library version or lib not found. Check config.log…
Read more

MySQL, PHP

CentOS, Compile, DTRACE, Error, libmysqlclient, MySQL 5.5, PHP 5.3.5

Convert string from dd/mm/yyyy to yyyy-mm-dd using mysql

Author: joe February 16, 2011 1 Comment

I had a large dataset with all the date fields in the format DD/MM/YYYY. I needed to convert them to YYYY-MM-DD . I ran the following queries: UPDATE TABLE_NAME SET FIELD_NAME = replace(FIELD_NAME, ‘/’, ‘-‘); UPDATE TABLE_NAME SET FIELD_NAME =…
Read more

MySQL

Convert, Date, Formats, mysql, Tip

MySQL Workbench CONCAT showing BLOB data fix

Author: joe December 4, 2010 4 Comments

If you find CONCAT results over a remote connection bringing a BLOB value use the following to fix this. fix confirmed in repository. option: “Treat BINARY/VARBINARY as nonbinary character string” has been added to app Preferences “SQL Editor” section http://bugs.mysql.com/bug.php?id=53920

MySQL

BLOB, CONCAT, Fix, Workbench