Today I found a couple of useful articles about upgrading MySQL 4. One is written by Peter Zaitsev and other by Guillaume Lefranc.
They are talking about problems you may face while upgrading as well as benefits of MySQL 5.
I hope you guys can really benefit from it.
Red Hat Enterprise Linux 5 and CentOS 5 are now shipping MySQL 5.0.77 instead of MySQL 5.0.45 on security grounds.
This is moderate security release according to RHEL and CentOS.
MySQL.com is conducting webinars on its usage in online applications. It is a series of 5 webinars i.e.
Part 1: Introduction to MySQL Scale Out and Replication Services
In the first installment we look at the basics for deploying MySQL for a scalable online application such as:
North America -- Tuesday, August 18, 2009: 10:00 Pacific time / 1:00 Eastern time
EMEA -- Wednesday, August 26, 2009: 10:00 am European Central Time
It is a common requirement to count number of words in a column of a MySQL database table. But MySQL does not have any built in function to count number of words as it usually has for number of purposes.
But you can do it without it with a simple trick e.g. you have a column name and want to count number of words in it. This query will return number of words separated with space in a column
SELECT SUM( LENGTH(name) - LENGTH(REPLACE(name, ' ', ''))+1) FROM table
If you want to count number of words separated by some other string for example comma (,) or semicolon (;), simply replace space with your required character.
I am creating a list of MySQL GUI (front end) tools. I hope you will contribute this list.
A wide variety of MySQL GUI tools are available in the market. Most of them are free but some are paid as well. We can divide GUIs in 2 categories i.e. desktop and web based applications. Here is the list of popular MySQL GUI tools I have heard of
If you know any good GUI Tool, please let me know.
People have different opinions on saving images in database. Some says, "Why bother database if we can handle this by saving images to disk". I am agree with this;).
Most of the requirements can be fulfilled by saving the images to disk. This reduces the unnecessary load on MySQL.
Here is the small code to save the image in MySQL with the help of PHP.
Read the rest of this entry »
This is a very simple example to download data in csv format using PHP and MySQL. I have used a table with two columns i.e. id and name.
The main point to download file is a proper use of header(). It has said many times in many places but I repeat here, "Make sure there must not be any sort of output (including whitespaces) before header()". We can also set a default file name for the file.
Here is the PHP code
Read the rest of this entry »