Minor bug in MySQL REPLACE function
Mar 100
I’ve come across what I think is a… well, if it’s not a bug, it’s certainly not documented either, in MySQL’s REPLACE function. The nub of the problem occurs when replacing out a repeated string enclosed with space marks… easier to show than explain further:
SELECT
REPLACE(‘Column1 Column2 Column3 – - Column6 – Column8′, ‘ – ‘, [...]
» Read moreMySQL combine date AND time fields
Mar 100
I genuinely don’t know how often this comes up for others but I came upon an occasion where I needed to be able to combine date and time fields, which were stored separately within a MySQL database, into a single datetime field.
In my case I had a “date” field, a “time” field (which were both [...]
MyISAM vs InnoDB – a MySQL database engine comparison
Mar 100
I’ve recently found that selecting the right database engine for your database or for individual tables, is not an easy chore. Actually, yes, chore is the right word and as apparently oxymoronic as it might be to find oneself an easy chore, wouldn’t life be easier if that were possible.
Instead, like so much database engineering, [...]
MySQL – limit number of tables?
Feb 100
Seems like a fairly simple question -
Is there a limit to the number of tables in a MySQL database?
The answer, it appears, is “No, not really”. A more accurate answer would be to suggest that, since MySQL databases are file based, there may be a limit imposed by your operating system for the number of [...]
MySQL limit on table name length
Feb 100
Just came across a semi-interesting one… creating online tables using MySQL, on the fly, and I needed them to be semi-random so I started using GUIDs. It turns out this is not such a great idea because I started to run into table name length problems.
After a bit of searching and testing, it appears that [...]
MySQL – how to change order of results in SHOW TABLES
Feb 100
Seems like a fairly simple requirement, to get the results of a SHOW TABLES command in a particular order. The obvious choices for the ordering would be either alpha-numerically, or date/time created (maybe even by size!), ASC or DESC.
However, it appears there’s no way to do this using SHOW TABLES itself. Instead you’re forced to [...]
How to remove/cancel private registration from GoDaddy
Feb 100
Just nearly been stung by an apparent problem with GoDaddy. Last year I bulk-registered about 30 domains and when I’ve just tried to renew about half of those, I very quickly noticed that I was being hugely stung on Private Registration fees. Now, when I first registered the domains, a nice little feature came up [...]
» Read moreColdFusion MX 6 gotcha – XML + WDDX
Jan 100
Here’s an error I had with ColdFusion CFMX 6.1 which I didn’t in 7. The problem was easy enough to solve once the little gotcha was out of the way. I find that’s true with a lot of ColdFusion errors, that sometimes the underlying Java is actually very useful in solving the problem.
I encountered an [...]
hMailServer – install guides
Dec 090
After choosing the right mail server for me, promising quick and easy setup – hMailServer - the installation was very straightforward – once I’d asked my ISP to unblock the right ports, in my case:
POP3 – port 110
IMAP – port 143
SMTP – port 25
The software installed with just one hitch and after I sorted that out [...]
» Read more