Category: MySQL
-
Featured on Fossfa.Net
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
-
“/usr/bin/ld: cannot find -lprobes_mysql”
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 for more information. I discovered the issue was with my build of MySQL 5.5. You…
-
Convert string from dd/mm/yyyy to yyyy-mm-dd using mysql
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 = str_to_date(FIELD_NAME,’%d-%m-%Y’); Hope it helps…
-
MySQL Workbench CONCAT showing BLOB data fix
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